explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2YPu

Settings
# exclusive inclusive rows x rows loops node
1. 23,689.877 23,689.877 ↓ 2.0 2,228,568 1

Index Scan using analytics_index_audit_events_on_created_at_and_author_id on audit_events audit_events (cost=0.57..824,020.13 rows=1,113,825 width=308) (actual time=6.431..23,689.877 rows=2,228,568 loops=1)

  • Index Cond: ((audit_events.created_at <= '2020-10-15 00:00:00'::timestamp without time zone) AND (audit_events.created_at >= '2020-10-01 00:00:00'::timestamp without time zone) AND (audit_events.created_at >= '2020-10-08 05:13:09.577754'::timestamp without time zone) AND (audit_events.created_at < '2020-10-13 10:00:05.463357'::timestamp without time zone))
  • Buffers: shared hit=2,010,213 read=128,826
Planning time : 0.166 ms
Execution time : 23,891.524 ms