explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pKem

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 43.185 ↑ 1.0 5 1

Limit (cost=0.28..0.44 rows=5 width=174) (actual time=43.166..43.185 rows=5 loops=1)

2. 0.009 43.182 ↑ 151,538,930.2 5 1

Nested Loop Left Join (cost=0.28..23,652,725.40 rows=757,694,651 width=174) (actual time=43.165..43.182 rows=5 loops=1)

3. 0.020 0.020 ↑ 8,940,058.0 1 1

Seq Scan on live_delivery ld (cost=0.00..251,947.58 rows=8,940,058 width=117) (actual time=0.020..0.020 rows=1 loops=1)

4. 43.153 43.153 ↑ 17.0 5 1

Index Scan using demo_block_idx on audience_map am (cost=0.28..1.77 rows=85 width=57) (actual time=43.138..43.153 rows=5 loops=1)

  • Index Cond: (ld.demo_block = (demo_block)::text)