explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xlif

Settings
# exclusive inclusive rows x rows loops node
1. 99.322 65,213.887 ↑ 1.0 1 1

Aggregate (cost=1,460,439.36..1,460,439.39 rows=1 width=8) (actual time=65,213.886..65,213.887 rows=1 loops=1)

  • Buffers: shared hit=4,286 read=115,795
  • I/O Timings: read=64,397.886
2. 65,114.565 65,114.565 ↓ 1.0 438,758 1

Index Scan using idx_creator_urn_lower on published_event (cost=0.56..1,459,386.17 rows=421,278 width=0) (actual time=4.987..65,114.565 rows=438,758 loops=1)

  • Index Cond: (lower((creator_urn)::text) = 'unknown'::text)
  • Buffers: shared hit=4,286 read=115,795
  • I/O Timings: read=64,397.886
Planning time : 8.282 ms
Execution time : 65,213.973 ms