explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tae8

Settings
# exclusive inclusive rows x rows loops node
1. 0.092 1,221.133 ↑ 1.0 1 1

Aggregate (cost=169,800.13..169,800.14 rows=1 width=8) (actual time=1,221.123..1,221.133 rows=1 loops=1)

2. 424.279 1,221.041 ↓ 31.7 476 1

Hash Join (cost=9,191.41..169,800.10 rows=15 width=0) (actual time=39.233..1,221.041 rows=476 loops=1)

  • Hash Cond: (g.id = z.id)
3. 782.526 782.526 ↓ 1.0 808,402 1

Seq Scan on tbl_visual_zone_119270 g (cost=0.00..157,572.46 rows=808,146 width=4) (actual time=0.009..782.526 rows=808,402 loops=1)

4. 0.148 14.236 ↑ 1.2 476 1

Hash (cost=9,184.31..9,184.31 rows=568 width=8) (actual time=14.228..14.236 rows=476 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 27kB
5. 0.268 14.088 ↑ 1.2 476 1

Hash Join (cost=9,171.46..9,184.31 rows=568 width=8) (actual time=13.662..14.088 rows=476 loops=1)

  • Hash Cond: (rtpezoav.zo_id = z.id)
6. 0.504 2.553 ↑ 1.2 476 1

HashAggregate (cost=8,542.68..8,548.36 rows=568 width=56) (actual time=2.346..2.553 rows=476 loops=1)

  • Group Key: rtpezoav.id, rtpezoav.ad_id, rtpezoav.pe_id, rtpezoav.zo_id, rtpezoav.value_num, rtpezoav.value_text
7. 0.074 2.049 ↑ 1.2 476 1

Append (cost=619.00..8,534.16 rows=568 width=56) (actual time=1.569..2.049 rows=476 loops=1)

8. 0.188 1.742 ↑ 1.2 476 1

Bitmap Heap Scan on rtpezoav_distr_119221 rtpezoav (cost=619.00..1,724.48 rows=567 width=56) (actual time=1.568..1.742 rows=476 loops=1)

  • Recheck Cond: ((pe_id = 66) AND (ad_id = 50))
  • Heap Blocks: exact=5
9. 1.554 1.554 ↑ 1.2 476 1

Bitmap Index Scan on rtpezoav_distr_unique_119221 (cost=0.00..618.86 rows=567 width=0) (actual time=1.554..1.554 rows=476 loops=1)

  • Index Cond: ((pe_id = 66) AND (ad_id = 50))
10. 0.002 0.233 ↓ 0.0 0 1

Hash Anti Join (cost=1,738.58..6,801.16 rows=1 width=56) (actual time=0.229..0.233 rows=0 loops=1)

  • Hash Cond: ((rtpe.id = av_1_1.pe_id) AND (av_1.ad_id = av_1_1.ad_id) AND (av_1.zo_id = av_1_1.zo_id))
11. 0.008 0.231 ↓ 0.0 0 1

Hash Join (cost=4.18..4,035.34 rows=532 width=56) (actual time=0.228..0.231 rows=0 loops=1)

  • Hash Cond: (av_1.pe_id = rtpe.baseline_id)
12. 0.208 0.208 ↑ 4,732.0 1 1

Seq Scan on rtpezoav_distr_119221 av_1 (cost=0.00..4,012.83 rows=4,732 width=56) (actual time=0.207..0.208 rows=1 loops=1)

  • Filter: (ad_id = 50)
  • Rows Removed by Filter: 952
13. 0.002 0.015 ↓ 0.0 0 1

Hash (cost=4.17..4.17 rows=1 width=8) (actual time=0.014..0.015 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
14. 0.013 0.013 ↑ 1.0 1 1

Index Only Scan using rtpe_id_baseline_id_idx_102089 on rtpe_102089 rtpe (cost=0.15..4.17 rows=1 width=8) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: (id = 66)
  • Heap Fetches: 0
15. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,724.48..1,724.48 rows=567 width=12) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on rtpezoav_distr_119221 av_1_1 (cost=619.00..1,724.48 rows=567 width=12) (never executed)

  • Recheck Cond: ((pe_id = 66) AND (ad_id = 50))
17. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on rtpezoav_distr_unique_119221 (cost=0.00..618.86 rows=567 width=0) (never executed)

  • Index Cond: ((pe_id = 66) AND (ad_id = 50))
18. 5.834 11.267 ↑ 1.0 21,768 1

Hash (cost=356.68..356.68 rows=21,768 width=4) (actual time=11.266..11.267 rows=21,768 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,022kB
19. 5.433 5.433 ↑ 1.0 21,768 1

Seq Scan on rtzo_102093 z (cost=0.00..356.68 rows=21,768 width=4) (actual time=0.011..5.433 rows=21,768 loops=1)

Planning time : 1.063 ms
Execution time : 1,221.292 ms