explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4dad

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 152,606.739 ↑ 1.0 1 1

Limit (cost=23,393.36..23,393.37 rows=1 width=8) (actual time=152,606.738..152,606.739 rows=1 loops=1)

2. 22.130 152,606.737 ↑ 1.0 1 1

Aggregate (cost=23,393.36..23,393.37 rows=1 width=8) (actual time=152,606.737..152,606.737 rows=1 loops=1)

3. 64.332 152,584.607 ↓ 55.7 19,328 1

Nested Loop (cost=1.12..23,392.49 rows=347 width=19) (actual time=6.977..152,584.607 rows=19,328 loops=1)

4. 81,736.666 152,423.635 ↓ 55.7 19,328 1

Nested Loop (cost=0.85..23,272.49 rows=347 width=23) (actual time=6.964..152,423.635 rows=19,328 loops=1)

  • Join Filter: (phase_model.id = ANY (digimat_model.dmf_id))
  • Rows Removed by Join Filter: 552877440
5. 33.214 352.377 ↓ 102.3 19,328 1

Nested Loop (cost=0.56..794.69 rows=189 width=4) (actual time=0.071..352.377 rows=19,328 loops=1)

6. 29.840 222.523 ↓ 102.3 19,328 1

Nested Loop (cost=0.29..738.94 rows=189 width=8) (actual time=0.063..222.523 rows=19,328 loops=1)

  • Join Filter: (phase_model.unit_id = unit.id)
  • Rows Removed by Join Filter: 924
7. 17.610 192.683 ↓ 102.3 19,328 1

Nested Loop (cost=0.29..714.58 rows=189 width=12) (actual time=0.048..192.683 rows=19,328 loops=1)

8. 0.710 0.710 ↓ 1.1 21 1

Seq Scan on dmf_material (cost=0.00..358.19 rows=19 width=103) (actual time=0.022..0.710 rows=21 loops=1)

9. 174.363 174.363 ↓ 92.0 920 21

Index Scan using phase_model_pkey on phase_model (cost=0.29..18.66 rows=10 width=12) (actual time=0.008..8.303 rows=920 loops=21)

  • Index Cond: (id = ANY (dmf_material.phase_model_id))
  • Filter: (type = 'elastic'::text)
  • Rows Removed by Filter: 4
10. 0.000 0.000 ↑ 9.0 1 19,328

Materialize (cost=0.00..1.14 rows=9 width=4) (actual time=0.000..0.000 rows=1 loops=19,328)

11. 0.012 0.012 ↑ 1.3 7 1

Seq Scan on unit (cost=0.00..1.09 rows=9 width=4) (actual time=0.010..0.012 rows=7 loops=1)

12. 96.640 96.640 ↑ 1.0 1 19,328

Index Only Scan using dmf_file_info_pkey on dmf_file_info (cost=0.28..0.29 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=19,328)

  • Index Cond: (id = phase_model.dmf_file_info_id)
  • Heap Fetches: 19328
13. 70,277.509 70,334.592 ↓ 8.0 28,606 19,328

Materialize (cost=0.29..5,623.20 rows=3,569 width=50) (actual time=0.008..3.639 rows=28,606 loops=19,328)

14. 9.323 57.083 ↓ 8.0 28,606 1

Nested Loop (cost=0.29..5,605.35 rows=3,569 width=50) (actual time=0.080..57.083 rows=28,606 loops=1)

15. 2.778 2.778 ↑ 1.0 357 1

Seq Scan on material_nomenclature (cost=0.00..2,320.57 rows=357 width=115) (actual time=0.009..2.778 rows=357 loops=1)

16. 44.982 44.982 ↓ 8.0 80 357

Index Scan using digimat_model_pkey on digimat_model (cost=0.29..9.10 rows=10 width=31) (actual time=0.002..0.126 rows=80 loops=357)

  • Index Cond: (id = ANY (material_nomenclature.material_model_id))
17. 96.640 96.640 ↑ 1.0 1 19,328

Index Only Scan using constituent_pkey on constituent (cost=0.27..0.35 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=19,328)

  • Index Cond: (id = material_nomenclature.constituent_id)
  • Heap Fetches: 0
Planning time : 1.293 ms
Execution time : 152,609.306 ms