explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rYPL

Settings
# exclusive inclusive rows x rows loops node
1. 5.991 343,683.800 ↑ 1.0 10,000 1

Limit (cost=0.57..96,643.84 rows=10,000 width=311) (actual time=336,769.117..343,683.800 rows=10,000 loops=1)

  • Buffers: shared hit=250,812 read=309,145 dirtied=7,657 written=1,589
  • I/O Timings: read=337,690.103 write=184.880
2. 343,677.809 343,677.809 ↑ 193.1 10,000 1

Index Scan using index_audit_events_on_entity_id_entity_type_id_desc_author_id on public.audit_events (cost=0.57..18,662,046.55 rows=1,931,024 width=311) (actual time=336,769.114..343,677.809 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))
  • Filter: ((audit_events.created_at <= '2020-08-01 00:00:00'::timestamp without time zone) AND (audit_events.created_at >= '2020-07-01 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 558,395
  • Buffers: shared hit=250,812 read=309,145 dirtied=7,657 written=1,589
  • I/O Timings: read=337,690.103 write=184.880