explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aqfU

Settings
# exclusive inclusive rows x rows loops node
1. 5.333 786.641 ↓ 169.3 5,927 1

Nested Loop Left Join (cost=1,595.90..272,299.89 rows=35 width=10,298) (actual time=4.880..786.641 rows=5,927 loops=1)

  • Filter: (c.dt_cancel IS NULL)
2. 9.229 757.600 ↓ 169.3 5,927 1

Nested Loop (cost=1,595.48..272,072.04 rows=35 width=10,278) (actual time=4.872..757.600 rows=5,927 loops=1)

3. 4.178 653.539 ↓ 169.3 5,927 1

Nested Loop (cost=1,595.05..271,844.29 rows=35 width=9,430) (actual time=4.861..653.539 rows=5,927 loops=1)

4. 2.467 571.855 ↓ 170.3 5,962 1

Nested Loop (cost=1,594.63..271,602.48 rows=35 width=7,579) (actual time=4.852..571.855 rows=5,962 loops=1)

5. 42.956 549.159 ↓ 182.2 6,743 1

Nested Loop (cost=1,594.21..271,362.43 rows=37 width=6,750) (actual time=4.842..549.159 rows=6,743 loops=1)

6. 35.273 220.708 ↓ 3.7 57,099 1

Hash Join (cost=1,593.78..170,769.28 rows=15,440 width=3,564) (actual time=4.833..220.708 rows=57,099 loops=1)

  • Hash Cond: ((t_caso.tp_accesso)::text = (t_tp_accesso.tp_accesso)::text)
7. 42.503 185.426 ↓ 2.5 57,144 1

Nested Loop (cost=1,592.43..170,528.91 rows=22,566 width=3,486) (actual time=4.815..185.426 rows=57,144 loops=1)

8. 22.499 53.413 ↓ 2.0 44,755 1

Hash Left Join (cost=1,592.00..7,319.50 rows=22,322 width=300) (actual time=4.805..53.413 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. 26.600 30.899 ↓ 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.779..30.899 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.299 4.299 ↓ 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.299..4.299 rows=86,221 loops=1)

  • Index Cond: (user_taglio = 0)
11. 0.008 0.015 ↑ 1.0 38 1

Hash (cost=1.55..1.55 rows=38 width=51) (actual time=0.015..0.015 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 ↑ 1.0 1 44,755

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

  • Index Cond: (id_acc_mat = t_vetrino.id_acc_mat)
  • Filter: (dt_cancel IS NULL)
  • Rows Removed by Filter: 0
14. 0.002 0.009 ↑ 1.0 13 1

Hash (cost=1.19..1.19 rows=13 width=78) (actual time=0.009..0.009 rows=13 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
15. 0.007 0.007 ↑ 1.0 13 1

Seq Scan on t_tp_accesso (cost=0.00..1.19 rows=13 width=78) (actual time=0.005..0.007 rows=13 loops=1)

  • Filter: (dt_cancel IS NULL)
  • Rows Removed by Filter: 6
16. 285.495 285.495 ↓ 0.0 0 57,099

Index Scan using i_caso7 on t_caso t_caso_1 (cost=0.43..6.51 rows=1 width=3,186) (actual time=0.005..0.005 rows=0 loops=57,099)

  • Index Cond: (id_caso_p = t_caso.id_caso)
  • Filter: ((dt_cancel IS NULL) AND ((fl_stato)::text <> ALL ('{I,P,V,R,Z,F}'::text[])))
  • Rows Removed by Filter: 1
17. 20.229 20.229 ↑ 1.0 1 6,743

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

  • 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. 77.506 77.506 ↑ 1.0 1 5,962

Index Scan using p_t_paziente on t_paziente (cost=0.42..6.90 rows=1 width=1,851) (actual time=0.012..0.013 rows=1 loops=5,962)

  • Index Cond: (id_paziente = t_caso_1.id_paziente)
  • Filter: (dt_cancel IS NULL)
  • Rows Removed by Filter: 0
19. 94.832 94.832 ↑ 1.0 1 5,927

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

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

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

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