explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BZz1

Settings
# exclusive inclusive rows x rows loops node
1. 0.532 6.797 ↓ 2.2 1,046 1

Hash Join (cost=100.11..111.70 rows=479 width=420) (actual time=5.103..6.797 rows=1,046 loops=1)

  • Hash Cond: (mp.application_id = ap.application_id)
2. 0.510 6.223 ↓ 2.2 1,046 1

Hash Join (cost=96.92..107.15 rows=479 width=389) (actual time=5.002..6.223 rows=1,046 loops=1)

  • Hash Cond: (ps.message_panel_id = mp.message_panel_id)
3. 0.586 5.580 ↓ 2.2 1,046 1

Hash Right Join (cost=91.98..100.89 rows=479 width=346) (actual time=4.858..5.580 rows=1,046 loops=1)

  • Hash Cond: (plp.property_id = p.property_id)
4. 0.163 0.163 ↑ 1.0 308 1

Seq Scan on property_list_possible plp (cost=0.00..6.08 rows=308 width=25) (actual time=0.014..0.163 rows=308 loops=1)

5. 0.576 4.831 ↓ 2.0 970 1

Hash (cost=86.00..86.00 rows=479 width=321) (actual time=4.831..4.831 rows=970 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 244kB
6. 0.468 4.255 ↓ 2.0 970 1

Hash Right Join (cost=84.77..86.00 rows=479 width=321) (actual time=3.796..4.255 rows=970 loops=1)

  • Hash Cond: (hpv.property_id = p.property_id)
7. 0.011 0.011 ↑ 1.0 12 1

Seq Scan on hierarchy_possible_values hpv (cost=0.00..1.12 rows=12 width=45) (actual time=0.011..0.011 rows=12 loops=1)

8. 0.549 3.776 ↓ 2.0 948 1

Hash (cost=78.78..78.78 rows=479 width=276) (actual time=3.776..3.776 rows=948 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 238kB
9. 0.538 3.227 ↓ 2.0 948 1

Hash Join (cost=44.76..78.78 rows=479 width=276) (actual time=1.309..3.227 rows=948 loops=1)

  • Hash Cond: (psi.property_id = p.property_id)
10. 0.499 1.516 ↓ 2.0 948 1

Hash Join (cost=8.85..41.60 rows=479 width=125) (actual time=0.126..1.516 rows=948 loops=1)

  • Hash Cond: (psi.panel_section_id = ps.section_id)
11. 0.909 0.909 ↑ 1.0 1,165 1

Seq Scan on panel_section_item psi (cost=0.00..29.65 rows=1,165 width=71) (actual time=0.010..0.909 rows=1,165 loops=1)

12. 0.037 0.108 ↑ 1.0 113 1

Hash (cost=7.44..7.44 rows=113 width=87) (actual time=0.108..0.108 rows=113 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 21kB
13. 0.071 0.071 ↑ 1.0 113 1

Seq Scan on panel_section ps (cost=0.00..7.44 rows=113 width=87) (actual time=0.011..0.071 rows=113 loops=1)

  • Filter: (type = '1'::numeric)
  • Rows Removed by Filter: 162
14. 0.350 1.173 ↑ 1.0 885 1

Hash (cost=24.85..24.85 rows=885 width=157) (actual time=1.173..1.173 rows=885 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 129kB
15. 0.823 0.823 ↑ 1.0 885 1

Seq Scan on property p (cost=0.00..24.85 rows=885 width=157) (actual time=0.010..0.823 rows=885 loops=1)

16. 0.020 0.133 ↑ 1.0 86 1

Hash (cost=3.86..3.86 rows=86 width=49) (actual time=0.133..0.133 rows=86 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
17. 0.113 0.113 ↑ 1.0 86 1

Seq Scan on message_panel mp (cost=0.00..3.86 rows=86 width=49) (actual time=0.007..0.113 rows=86 loops=1)

18. 0.016 0.042 ↑ 1.0 53 1

Hash (cost=2.53..2.53 rows=53 width=30) (actual time=0.042..0.042 rows=53 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
19. 0.026 0.026 ↑ 1.0 53 1

Seq Scan on application ap (cost=0.00..2.53 rows=53 width=30) (actual time=0.014..0.026 rows=53 loops=1)

Planning time : 1.768 ms
Execution time : 7.017 ms