explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ff6m

Settings
# exclusive inclusive rows x rows loops node
1. 5,731.397 5,908.726 ↓ 3.3 52,174 1

Hash Right Join (cost=8,378.83..10,331.22 rows=16,037 width=633) (actual time=168.986..5,908.726 rows=52,174 loops=1)

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

Seq Scan on property_list_possible plp (cost=0.00..1,128.12 rows=58,412 width=26) (actual time=0.013..8.671 rows=58,412 loops=1)

3. 19.858 168.658 ↓ 1.8 29,179 1

Hash (cost=8,178.37..8,178.37 rows=16,037 width=291) (actual time=168.658..168.658 rows=29,179 loops=1)

  • Buckets: 32,768 (originally 16384) Batches: 1 (originally 1) Memory Usage: 8,367kB
4. 23.690 148.800 ↓ 1.8 29,179 1

Hash Join (cost=5,204.79..8,178.37 rows=16,037 width=291) (actual time=84.323..148.800 rows=29,179 loops=1)

  • Hash Cond: (psi.property_id = p.property_id)
5. 31.546 70.554 ↓ 1.8 29,179 1

Hash Join (cost=2,133.63..5,065.10 rows=16,037 width=145) (actual time=29.542..70.554 rows=29,179 loops=1)

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

Seq Scan on panel_section_item psi (cost=0.00..2,423.35 rows=92,735 width=39) (actual time=0.008..9.508 rows=92,735 loops=1)

7. 2.147 29.500 ↓ 1.0 5,832 1

Hash (cost=2,060.84..2,060.84 rows=5,823 width=149) (actual time=29.500..29.500 rows=5,832 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 1,124kB
8. 2.866 27.353 ↓ 1.0 5,832 1

Hash Join (cost=1,830.14..2,060.84 rows=5,823 width=149) (actual time=18.165..27.353 rows=5,832 loops=1)

  • Hash Cond: (mp.application_id = ap.application_id)
9. 3.112 21.383 ↓ 1.0 5,832 1

Hash Join (cost=1,526.77..1,742.18 rows=5,823 width=131) (actual time=15.039..21.383 rows=5,832 loops=1)

  • Hash Cond: (ps.message_panel_id = mp.message_panel_id)
10. 2.929 12.696 ↓ 1.0 5,832 1

Hash Right Join (cost=1,001.69..1,201.80 rows=5,823 width=88) (actual time=9.429..12.696 rows=5,832 loops=1)

  • Hash Cond: ((ho.message_panel_id)::numeric = ps.message_panel_id)
11. 0.376 0.376 ↓ 1.0 3,085 1

Seq Scan on message_panel_handling_option ho (cost=0.00..59.71 rows=3,071 width=17) (actual time=0.011..0.376 rows=3,085 loops=1)

12. 1.698 9.391 ↓ 1.0 5,832 1

Hash (cost=928.90..928.90 rows=5,823 width=79) (actual time=9.391..9.391 rows=5,832 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 705kB
13. 7.693 7.693 ↓ 1.0 5,832 1

Seq Scan on panel_section ps (cost=0.00..928.90 rows=5,823 width=79) (actual time=0.013..7.693 rows=5,832 loops=1)

  • Filter: (type = '4'::numeric)
  • Rows Removed by Filter: 27,765
14. 2.225 5.575 ↓ 1.0 10,178 1

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

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

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

16. 1.218 3.104 ↓ 1.0 5,884 1

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

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

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

18. 29.629 54.556 ↓ 1.0 75,867 1

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

  • Buckets: 131,072 Batches: 1 Memory Usage: 10,825kB
19. 24.927 24.927 ↓ 1.0 75,867 1

Seq Scan on property p (cost=0.00..2,127.74 rows=75,474 width=152) (actual time=0.012..24.927 rows=75,867 loops=1)

Planning time : 2.131 ms
Execution time : 5,913.114 ms