explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kjoY

Settings
# exclusive inclusive rows x rows loops node
1. 0.441 554.673 ↑ 1.0 1,000 1

Limit (cost=0.57..51,048.53 rows=1,000 width=311) (actual time=13.462..554.673 rows=1,000 loops=1)

  • Buffers: shared hit=516 read=493
  • I/O Timings: read=547.247
2. 554.232 554.232 ↑ 3.5 1,000 1

Index Scan using index_audit_events_on_entity_id_entity_type_id_desc_author_id on public.audit_events (cost=0.57..177,851.66 rows=3,484 width=311) (actual time=13.460..554.232 rows=1,000 loops=1)

  • Index Cond: ((audit_events.entity_id = '-1'::integer) AND ((audit_events.entity_type)::text = 'User'::text) AND (audit_events.id > 357698842) AND (audit_events.author_id = '-1'::integer))
  • Filter: ((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))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=516 read=493
  • I/O Timings: read=547.247