explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CcTZ

Settings
# exclusive inclusive rows x rows loops node
1. 2.270 322.258 ↑ 1.0 10,000 1

Limit (cost=0.57..37,076.07 rows=10,000 width=334) (actual time=5.652..322.258 rows=10,000 loops=1)

  • Buffers: shared hit=3,953 read=5,928
  • I/O Timings: read=289.804
2. 319.988 319.988 ↑ 90.8 10,000 1

Index Scan using idx_audit_events_with_created_at on public.audit_events (cost=0.57..3,365,191.73 rows=907,659 width=334) (actual time=5.649..319.988 rows=10,000 loops=1)

  • Index Cond: ((audit_events.entity_id = '-1'::integer) AND ((audit_events.entity_type)::text = 'User'::text) AND (audit_events.author_id = '-1'::integer) AND (audit_events.created_at <= '2020-09-01 00:00:00'::timestamp without time zone) AND (audit_events.created_at >= '2020-08-01 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=3,953 read=5,928
  • I/O Timings: read=289.804