explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lhnE

Settings
# exclusive inclusive rows x rows loops node
1. 3.696 275.530 ↓ 5,926.0 5,926 1

Nested Loop Left Join (cost=1,594.55..171,118.75 rows=1 width=10,298) (actual time=4.704..275.530 rows=5,926 loops=1)

  • Filter: (c.dt_cancel IS NULL)
2. 4.961 259.982 ↓ 5,926.0 5,926 1

Nested Loop (cost=1,594.12..171,112.24 rows=1 width=10,278) (actual time=4.696..259.982 rows=5,926 loops=1)

3. 5.741 243.169 ↓ 5,926.0 5,926 1

Nested Loop (cost=1,593.70..171,105.73 rows=1 width=9,430) (actual time=4.688..243.169 rows=5,926 loops=1)

4. 27.804 224.014 ↓ 6,707.0 6,707 1

Nested Loop (cost=1,593.28..171,099.25 rows=1 width=8,601) (actual time=4.680..224.014 rows=6,707 loops=1)

  • Join Filter: ((t_caso.tp_accesso)::text = (t_tp_accesso.tp_accesso)::text)
  • Rows Removed by Join Filter: 80484
5. 6.129 182.796 ↓ 6,707.0 6,707 1

Nested Loop (cost=1,593.28..171,097.89 rows=1 width=8,523) (actual time=4.669..182.796 rows=6,707 loops=1)

  • Join Filter: (t_caso_1.id_paziente = t_paziente.id_paziente)
6. 11.172 163.183 ↓ 6,742.0 6,742 1

Nested Loop (cost=1,592.85..171,091.42 rows=1 width=6,672) (actual time=4.661..163.183 rows=6,742 loops=1)

  • Join Filter: ((t_caso_1.id_paziente = t_caso.id_paziente) AND (t_caso_1.id_caso_p = t_caso.id_caso))
  • Rows Removed by Join Filter: 4562
7. 9.608 145.264 ↓ 124.9 6,747 1

Nested Loop (cost=1,592.43..170,696.32 rows=54 width=3,486) (actual time=4.657..145.264 rows=6,747 loops=1)

8. 19.536 46.146 ↓ 2.0 44,755 1

Hash Left Join (cost=1,592.00..7,319.50 rows=22,322 width=300) (actual time=4.647..46.146 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))
9. 22.443 26.596 ↓ 2.0 44,755 1

Bitmap Heap Scan on t_vetrino (cost=1,589.97..7,062.74 rows=22,679 width=249) (actual time=4.622..26.596 rows=44,755 loops=1)

  • Recheck Cond: (user_taglio = 0)
  • Filter: ((dt_cancel IS NULL) AND (annullato IS NULL) AND (user_consegna = 0))
  • Rows Removed by Filter: 41466
10. 4.153 4.153 ↓ 1.0 86,221 1

Bitmap Index Scan on i_ppppp (cost=0.00..1,584.31 rows=85,318 width=0) (actual time=4.153..4.153 rows=86,221 loops=1)

  • Index Cond: (user_taglio = 0)
11. 0.007 0.014 ↑ 1.0 38 1

Hash (cost=1.55..1.55 rows=38 width=51) (actual time=0.014..0.014 rows=38 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
12. 0.007 0.007 ↑ 1.0 38 1

Seq Scan on t_colorazione (cost=0.00..1.55 rows=38 width=51) (actual time=0.003..0.007 rows=38 loops=1)

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

Index Scan using t_caso2 on t_caso t_caso_1 (cost=0.43..7.31 rows=1 width=3,186) (actual time=0.002..0.002 rows=0 loops=44,755)

  • Index Cond: (id_acc_mat = t_vetrino.id_acc_mat)
  • Filter: ((dt_cancel IS NULL) AND ((fl_stato)::text <> ALL ('{I,P,V,R,Z,F}'::text[])))
  • Rows Removed by Filter: 1
14. 6.747 6.747 ↓ 2.0 2 6,747

Index Scan using t_caso2 on t_caso (cost=0.43..7.30 rows=1 width=3,186) (actual time=0.001..0.001 rows=2 loops=6,747)

  • Index Cond: (id_acc_mat = t_vetrino.id_acc_mat)
  • Filter: (dt_cancel IS NULL)
  • Rows Removed by Filter: 0
15. 13.484 13.484 ↑ 1.0 1 6,742

Index Scan using p_t_paziente on t_paziente (cost=0.42..6.46 rows=1 width=1,851) (actual time=0.002..0.002 rows=1 loops=6,742)

  • Index Cond: (id_paziente = t_caso.id_paziente)
  • Filter: (dt_cancel IS NULL)
  • Rows Removed by Filter: 0
16. 13.414 13.414 ↑ 1.0 13 6,707

Seq Scan on t_tp_accesso (cost=0.00..1.19 rows=13 width=78) (actual time=0.001..0.002 rows=13 loops=6,707)

  • Filter: (dt_cancel IS NULL)
  • Rows Removed by Filter: 6
17. 13.414 13.414 ↑ 1.0 1 6,707

Index Scan using p_t_blocchetto on t_blocchetto b (cost=0.42..6.48 rows=1 width=829) (actual time=0.002..0.002 rows=1 loops=6,707)

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

Index Scan using p_t_prelievo on t_prelievo (cost=0.43..6.50 rows=1 width=848) (actual time=0.002..0.002 rows=1 loops=5,926)

  • Index Cond: (id_prelievo = b.id_prelievo)
  • Filter: ((dt_cancel IS NULL) AND ((cd_prelievo)::text <> '-'::text))
19. 11.852 11.852 ↑ 1.0 1 5,926

Index Scan using p_t_campionamento on t_campionamento c (cost=0.43..6.50 rows=1 width=28) (actual time=0.002..0.002 rows=1 loops=5,926)

  • Index Cond: (b.id_campionamento = id_campionamento)
Total runtime : 276.533 ms