explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bHqu

Settings
# exclusive inclusive rows x rows loops node
1. 56.942 507.067 ↓ 3.8 120,863 1

Hash Join (cost=9,466.48..11,261.42 rows=31,440 width=432) (actual time=302.320..507.067 rows=120,863 loops=1)

  • Hash Cond: (mp.application_id = ap.application_id)
2. 60.942 447.617 ↓ 3.8 120,863 1

Hash Join (cost=9,163.11..10,875.46 rows=31,440 width=401) (actual time=299.793..447.617 rows=120,863 loops=1)

  • Hash Cond: (ps.message_panel_id = mp.message_panel_id)
3. 81.670 381.661 ↓ 3.8 120,863 1

Hash Right Join (cost=8,638.03..10,267.82 rows=31,440 width=358) (actual time=294.746..381.661 rows=120,863 loops=1)

  • Hash Cond: (plp.property_id = p.property_id)
4. 5.316 5.316 ↑ 1.0 58,412 1

Seq Scan on property_list_possible plp (cost=0.00..1,150.06 rows=60,606 width=26) (actual time=0.015..5.316 rows=58,412 loops=1)

5. 46.893 294.675 ↓ 2.5 77,621 1

Hash (cost=8,245.03..8,245.03 rows=31,440 width=332) (actual time=294.674..294.675 rows=77,621 loops=1)

  • Buckets: 131,072 (originally 32768) Batches: 1 (originally 1) Memory Usage: 21,665kB
6. 51.002 247.782 ↓ 2.5 77,621 1

Hash Right Join (cost=7,285.11..8,245.03 rows=31,440 width=332) (actual time=193.984..247.782 rows=77,621 loops=1)

  • Hash Cond: (hpv.property_id = p.property_id)
7. 2.866 2.866 ↑ 1.0 34,546 1

Seq Scan on hierarchy_possible_values hpv (cost=0.00..686.46 rows=34,546 width=47) (actual time=0.013..2.866 rows=34,546 loops=1)

8. 41.500 193.914 ↓ 2.0 63,556 1

Hash (cost=6,892.11..6,892.11 rows=31,440 width=285) (actual time=193.914..193.914 rows=63,556 loops=1)

  • Buckets: 65,536 (originally 32768) Batches: 1 (originally 1) Memory Usage: 17,195kB
9. 40.471 152.414 ↓ 2.0 63,556 1

Hash Join (cost=4,142.77..6,892.11 rows=31,440 width=285) (actual time=61.922..152.414 rows=63,556 loops=1)

  • Hash Cond: (psi.property_id = p.property_id)
10. 40.449 60.730 ↓ 2.0 63,556 1

Hash Join (cost=1,071.60..3,738.41 rows=31,440 width=126) (actual time=10.544..60.730 rows=63,556 loops=1)

  • Hash Cond: (psi.panel_section_id = ps.section_id)
11. 9.786 9.786 ↑ 1.0 92,735 1

Seq Scan on panel_section_item psi (cost=0.00..2,423.35 rows=92,735 width=76) (actual time=0.022..9.786 rows=92,735 loops=1)

12. 3.147 10.495 ↑ 1.0 11,378 1

Hash (cost=928.90..928.90 rows=11,416 width=93) (actual time=10.495..10.495 rows=11,378 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,509kB
13. 7.348 7.348 ↑ 1.0 11,378 1

Seq Scan on panel_section ps (cost=0.00..928.90 rows=11,416 width=93) (actual time=0.006..7.348 rows=11,378 loops=1)

  • Filter: (type = '1'::numeric)
  • Rows Removed by Filter: 22,219
14. 28.490 51.213 ↓ 1.0 75,867 1

Hash (cost=2,127.74..2,127.74 rows=75,474 width=165) (actual time=51.213..51.213 rows=75,867 loops=1)

  • Buckets: 131,072 Batches: 1 Memory Usage: 11,662kB
15. 22.723 22.723 ↓ 1.0 75,867 1

Seq Scan on property p (cost=0.00..2,127.74 rows=75,474 width=165) (actual time=0.009..22.723 rows=75,867 loops=1)

16. 2.035 5.014 ↓ 1.0 10,178 1

Hash (cost=398.37..398.37 rows=10,137 width=50) (actual time=5.014..5.014 rows=10,178 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 953kB
17. 2.979 2.979 ↓ 1.0 10,178 1

Seq Scan on message_panel mp (cost=0.00..398.37 rows=10,137 width=50) (actual time=0.009..2.979 rows=10,178 loops=1)

18. 0.969 2.508 ↓ 1.0 5,884 1

Hash (cost=229.83..229.83 rows=5,883 width=30) (actual time=2.508..2.508 rows=5,884 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 427kB
19. 1.539 1.539 ↓ 1.0 5,884 1

Seq Scan on application ap (cost=0.00..229.83 rows=5,883 width=30) (actual time=0.008..1.539 rows=5,884 loops=1)

Planning time : 1.857 ms
Execution time : 513.341 ms