explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NtZV

Settings
# exclusive inclusive rows x rows loops node
1. 74.964 52,525.218 ↑ 1.0 1 1

Aggregate (cost=1,652,139.16..1,652,139.19 rows=1 width=8) (actual time=52,525.218..52,525.218 rows=1 loops=1)

  • Buffers: shared hit=4,652 read=115,433
  • I/O Timings: read=51,989.141
2. 52,450.254 52,450.254 ↑ 1.1 438,762 1

Index Scan using idx_creator_urn_lower on published_event (cost=0.56..1,650,946.81 rows=476,941 width=0) (actual time=0.052..52,450.254 rows=438,762 loops=1)

  • Index Cond: (lower((creator_urn)::text) = 'unknown'::text)
  • Buffers: shared hit=4,652 read=115,433
  • I/O Timings: read=51,989.141
Planning time : 1.095 ms
Execution time : 52,525.313 ms