explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Vdv

Settings
# exclusive inclusive rows x rows loops node
1. 81.289 63,322.207 ↑ 1.0 1 1

Aggregate (cost=1,516,522.34..1,516,522.37 rows=1 width=8) (actual time=63,322.206..63,322.207 rows=1 loops=1)

  • Buffers: shared hit=3,738 read=116+++++++++83 dirtied=2
  • I/O Timings: read=62,737.496
2. 63,240.918 63,240.918 ↓ 1.0 438,758 1

Index Scan using idx_creator_urn_lower on published_event (cost=0.56..1,515,428.08 rows=437,702 width=0) (actual time=2.520..63,240.918 rows=438,758 loops=1)

  • Index Cond: (lower((creator_urn)::text) = 'unknown'::text)
  • Buffers: shared hit=3,738 read=116,383 dirtied=2
  • I/O Timings: read=62,737.496
Planning time : 16.775 ms
Execution time : 63,322.288 ms