explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yc0r

Settings
# exclusive inclusive rows x rows loops node
1. 0.060 6.748 ↑ 1.0 1 1

Limit (cost=29.11..29.14 rows=1 width=8) (actual time=6.748..6.748 rows=1 loops=1)

  • Buffers: shared hit=2 read=7
2. 6.688 6.688 ↑ 1,223.5 1,001 1

Index Only Scan using analytics_index_audit_events_on_created_at_and_author_id on audit_events audit_events (cost=0.57..34,956.55 rows=1,224,744 width=8) (actual time=3.277..6.688 rows=1,001 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))
  • Buffers: shared hit=2 read=7
Planning time : 0.342 ms
Execution time : 6.778 ms