explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CO7N

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 0.180 ↑ 1.0 50 1

Limit (cost=0.84..1.65 rows=50 width=174) (actual time=0.053..0.180 rows=50 loops=1)

2. 0.022 0.164 ↑ 15,153,893.0 50 1

Merge Join (cost=0.84..12,326,753.62 rows=757,694,651 width=174) (actual time=0.044..0.164 rows=50 loops=1)

  • Merge Cond: ((am.demo_block)::text = ld.demo_block)
3. 0.022 0.022 ↑ 2,544.0 1 1

Index Scan using demo_block_idx on audience_map am (cost=0.28..214.10 rows=2,544 width=57) (actual time=0.022..0.022 rows=1 loops=1)

4. 0.023 0.120 ↑ 178,801.2 50 1

Materialize (cost=0.56..983,463.54 rows=8,940,058 width=117) (actual time=0.018..0.120 rows=50 loops=1)

5. 0.097 0.097 ↑ 178,801.2 50 1

Index Scan using lv_demo_block_idx on live_delivery ld (cost=0.56..961,113.39 rows=8,940,058 width=117) (actual time=0.015..0.097 rows=50 loops=1)