explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D67H

Settings
# exclusive inclusive rows x rows loops node
1. 1,342.330 1,514.636 ↓ 5.3 20,237 1

Nested Loop (cost=3,912.72..7,265.27 rows=3,793 width=634) (actual time=74.022..1,514.636 rows=20,237 loops=1)

2. 28.781 111.595 ↓ 4.1 20,237 1

Hash Join (cost=3,912.43..5,498.91 rows=4,932 width=171) (actual time=73.650..111.595 rows=20,237 loops=1)

  • Hash Cond: (plp.property_id = psi.property_id)
3. 9.242 9.242 ↑ 1.0 58,412 1

Seq Scan on property_list_possible plp (cost=0.00..1,020.01 rows=59,101 width=26) (actual time=0.012..9.242 rows=58,412 loops=1)

4. 11.567 73.572 ↓ 4.2 20,237 1

Hash (cost=3,851.57..3,851.57 rows=4,869 width=145) (actual time=73.572..73.572 rows=20,237 loops=1)

  • Buckets: 32,768 (originally 8192) Batches: 1 (originally 1) Memory Usage: 3,890kB
5. 6.676 62.005 ↓ 4.2 20,237 1

Nested Loop (cost=897.71..3,851.57 rows=4,869 width=145) (actual time=11.665..62.005 rows=20,237 loops=1)

6. 1.688 23.528 ↓ 1.6 2,891 1

Hash Join (cost=897.29..1,843.28 rows=1,764 width=149) (actual time=11.613..23.528 rows=2,891 loops=1)

  • Hash Cond: (mp.application_id = ap.application_id)
7. 3.223 18.996 ↓ 1.6 2,891 1

Hash Join (cost=615.90..1,557.26 rows=1,764 width=131) (actual time=8.748..18.996 rows=2,891 loops=1)

  • Hash Cond: (ps.message_panel_id = mp.message_panel_id)
8. 7.064 7.064 ↓ 1.0 5,832 1

Seq Scan on panel_section ps (cost=0.00..901.96 rows=5,810 width=79) (actual time=0.016..7.064 rows=5,832 loops=1)

  • Filter: (type = '4'::numeric)
  • Rows Removed by Filter: 27,765
9. 0.872 8.709 ↑ 1.0 3,085 1

Hash (cost=577.34..577.34 rows=3,085 width=67) (actual time=8.709..8.709 rows=3,085 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 346kB
10. 1.996 7.837 ↑ 1.0 3,085 1

Hash Join (cost=510.00..577.34 rows=3,085 width=67) (actual time=5.571..7.837 rows=3,085 loops=1)

  • Hash Cond: ((ho.message_panel_id)::numeric = mp.message_panel_id)
11. 0.370 0.370 ↑ 1.0 3,085 1

Seq Scan on message_panel_handling_option ho (cost=0.00..58.85 rows=3,085 width=17) (actual time=0.010..0.370 rows=3,085 loops=1)

12. 2.293 5.471 ↑ 1.0 10,178 1

Hash (cost=382.78..382.78 rows=10,178 width=50) (actual time=5.471..5.471 rows=10,178 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 953kB
13. 3.178 3.178 ↑ 1.0 10,178 1

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

14. 1.146 2.844 ↑ 1.0 5,884 1

Hash (cost=207.84..207.84 rows=5,884 width=30) (actual time=2.844..2.844 rows=5,884 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 427kB
15. 1.698 1.698 ↑ 1.0 5,884 1

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

16. 31.801 31.801 ↑ 1.0 7 2,891

Index Scan using uc_ps_item_order on panel_section_item psi (cost=0.42..1.07 rows=7 width=39) (actual time=0.009..0.011 rows=7 loops=2,891)

  • Index Cond: (panel_section_id = ps.section_id)
17. 60.711 60.711 ↑ 1.0 1 20,237

Index Scan using property_pk on property p (cost=0.29..0.34 rows=1 width=153) (actual time=0.003..0.003 rows=1 loops=20,237)

  • Index Cond: (property_id = psi.property_id)
Planning time : 3.364 ms
Execution time : 1,516.441 ms