text: Title: Close datetimes result in repeated monthly X axis labels
  Body: I'm quite enjoying this, but I have come across a serious data interpretation problem. 
  
  I have a dataframe read like so:
  
  ```
  df = pd.read_sql_query(query,conn, parse_dates=['date'])
  ```
  
  However, the datetime values are all relatively high resolution ones (i.e., 5-15 second samples over many days), and the X axis nearly always shows only "2023-02" instead of showing the date (or the hour if I'm looking at the last 24 hours).
  
  Can we get a way to change the X-axis label resolution, or (even better), a stepwise automatic scale to format those datetimes according to the dataset granularity?