explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n12E

Settings
# exclusive inclusive rows x rows loops node
1. 16.803 201.252 ↓ 5,192.0 67,496 1

Nested Loop (cost=1,158.18..169,675.35 rows=13 width=71) (actual time=3.957..201.252 rows=67,496 loops=1)

2. 3.398 174.065 ↓ 5,192.0 5,192 1

Nested Loop Left Join (cost=1,158.18..169,674.03 rows=1 width=71) (actual time=3.947..174.065 rows=5,192 loops=1)

3. 0.184 165.476 ↓ 5,191.0 5,191 1

Nested Loop Left Join (cost=1,157.89..169,667.84 rows=1 width=72) (actual time=3.943..165.476 rows=5,191 loops=1)

  • Filter: (c.dt_cancel IS NULL)
4. 1.639 154.910 ↓ 5,191.0 5,191 1

Nested Loop (cost=1,157.47..169,661.46 rows=1 width=60) (actual time=3.936..154.910 rows=5,191 loops=1)

5. 1.709 142.327 ↓ 5,472.0 5,472 1

Nested Loop (cost=1,157.05..169,655.11 rows=1 width=58) (actual time=3.926..142.327 rows=5,472 loops=1)

  • Join Filter: (t_caso_1.id_caso_p = t_caso.id_caso)
  • Rows Removed by Join Filter: 2806
6. 2.786 129.666 ↓ 156.5 5,476 1

Nested Loop (cost=1,156.62..169,401.27 rows=35 width=36) (actual time=3.921..129.666 rows=5,476 loops=1)

7. 16.577 37.370 ↓ 2.0 44,755 1

Hash Left Join (cost=1,156.19..6,533.33 rows=22,440 width=36) (actual time=3.911..37.370 rows=44,755 loops=1)

  • Hash Cond: ((t_vetrino.id_colorazione)::text = (t_colorazione.id_colorazione)::text)
  • Filter: (((t_colorazione.tp_colorazione)::text <> 'R'::text) OR (t_vetrino.id_colorazione IS NULL))
8. 17.364 20.777 ↓ 2.0 44,755 1

Bitmap Heap Scan on t_vetrino (cost=1,154.17..6,275.26 rows=22,799 width=37) (actual time=3.885..20.777 rows=44,755 loops=1)

  • Recheck Cond: (user_consegna = 0)
  • Filter: ((dt_cancel IS NULL) AND (annullato IS NULL) AND (user_taglio = 0))
  • Rows Removed by Filter: 17121
9. 3.413 3.413 ↓ 1.0 61,876 1

Bitmap Index Scan on i_vetrino1 (cost=0.00..1,148.47 rows=61,873 width=0) (actual time=3.413..3.413 rows=61,876 loops=1)

  • Index Cond: (user_consegna = 0)
10. 0.007 0.016 ↑ 1.0 38 1

Hash (cost=1.55..1.55 rows=38 width=6) (actual time=0.016..0.016 rows=38 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
11. 0.009 0.009 ↑ 1.0 38 1

Seq Scan on t_colorazione (cost=0.00..1.55 rows=38 width=6) (actual time=0.004..0.009 rows=38 loops=1)

  • Filter: (dt_cancel IS NULL)
  • Rows Removed by Filter: 17
12. 89.510 89.510 ↓ 0.0 0 44,755

Index Scan using p_t_caso on t_caso t_caso_1 (cost=0.43..7.25 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=44,755)

  • Index Cond: (id_caso = t_vetrino.id_caso)
  • Filter: ((dt_cancel IS NULL) AND ((fl_stato)::text <> ALL ('{I,P,V,R,Z,F}'::text[])))
  • Rows Removed by Filter: 1
13. 10.952 10.952 ↓ 2.0 2 5,476

Index Scan using t_caso2 on t_caso (cost=0.43..7.24 rows=1 width=34) (actual time=0.001..0.002 rows=2 loops=5,476)

  • Index Cond: (id_acc_mat = t_vetrino.id_acc_mat)
  • Filter: (dt_cancel IS NULL)
  • Rows Removed by Filter: 0
14. 10.944 10.944 ↑ 1.0 1 5,472

Index Scan using p_t_blocchetto on t_blocchetto b (cost=0.42..6.34 rows=1 width=10) (actual time=0.002..0.002 rows=1 loops=5,472)

  • Index Cond: (id_blocchetto = t_vetrino.id_blocchetto)
  • Filter: ((dt_cancel IS NULL) AND ((tp_blocchetto)::text <> 'P'::text))
  • Rows Removed by Filter: 0
15. 10.382 10.382 ↑ 1.0 1 5,191

Index Scan using p_t_campionamento on t_campionamento c (cost=0.43..6.37 rows=1 width=24) (actual time=0.001..0.002 rows=1 loops=5,191)

  • Index Cond: (b.id_campionamento = id_campionamento)
16. 5.191 5.191 ↓ 0.0 0 5,191

Index Scan using t_vetrino_test1 on t_vetrino_test (cost=0.29..6.18 rows=1 width=7) (actual time=0.001..0.001 rows=0 loops=5,191)

  • Index Cond: (t_vetrino.id_vetrino = id_vetrino)
17. 10.384 10.384 ↑ 1.0 13 5,192

Seq Scan on t_tp_accesso (cost=0.00..1.19 rows=13 width=0) (actual time=0.001..0.002 rows=13 loops=5,192)

  • Filter: (dt_cancel IS NULL)
  • Rows Removed by Filter: 6
Total runtime : 203.105 ms