explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YFix

Settings
# exclusive inclusive rows x rows loops node
1. 19.647 288.703 ↓ 5,158.0 5,158 1

Nested Loop (cost=7,350.81..172,804.74 rows=1 width=95) (actual time=37.980..288.703 rows=5,158 loops=1)

  • Join Filter: ((t_caso.tp_accesso)::text = (t_tp_accesso.tp_accesso)::text)
  • Rows Removed by Join Filter: 61896
2. 3.353 258.740 ↓ 5,158.0 5,158 1

Nested Loop (cost=7,350.81..172,803.39 rows=1 width=93) (actual time=37.961..258.740 rows=5,158 loops=1)

3. 1.371 245.003 ↓ 5,192.0 5,192 1

Nested Loop Left Join (cost=7,350.39..172,796.48 rows=1 width=81) (actual time=37.953..245.003 rows=5,192 loops=1)

  • Filter: (c.dt_cancel IS NULL)
4. 2.276 233.248 ↓ 5,192.0 5,192 1

Nested Loop (cost=7,349.96..172,789.96 rows=1 width=69) (actual time=37.946..233.248 rows=5,192 loops=1)

5. 3.032 220.588 ↓ 5,192.0 5,192 1

Nested Loop (cost=7,349.53..172,783.45 rows=1 width=67) (actual time=37.938..220.588 rows=5,192 loops=1)

6. 2.937 206.610 ↓ 5,473.0 5,473 1

Nested Loop (cost=7,349.11..172,776.96 rows=1 width=61) (actual time=37.928..206.610 rows=5,473 loops=1)

  • Join Filter: (t_caso_1.id_caso_p = t_caso.id_caso)
  • Rows Removed by Join Filter: 2807
7. 19.608 192.719 ↓ 101.4 5,477 1

Nested Loop (cost=7,348.68..172,381.97 rows=54 width=39) (actual time=37.920..192.719 rows=5,477 loops=1)

8. 11.610 83.599 ↓ 2.0 44,756 1

Hash Left Join (cost=7,348.26..8,973.65 rows=22,322 width=35) (actual time=37.904..83.599 rows=44,756 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. 32.234 71.973 ↓ 2.0 44,756 1

Hash Right Join (cost=7,346.23..8,716.89 rows=22,679 width=36) (actual time=37.876..71.973 rows=44,756 loops=1)

  • Hash Cond: (t_vetrino_test.id_vetrino = t_vetrino.id_vetrino)
10. 1.888 1.888 ↑ 1.0 29,919 1

Seq Scan on t_vetrino_test (cost=0.00..1,041.19 rows=29,919 width=7) (actual time=0.004..1.888 rows=29,919 loops=1)

11. 7.699 37.851 ↓ 2.0 44,755 1

Hash (cost=7,062.74..7,062.74 rows=22,679 width=37) (actual time=37.851..37.851 rows=44,755 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 2296kB
12. 25.442 30.152 ↓ 2.0 44,755 1

Bitmap Heap Scan on t_vetrino (cost=1,589.97..7,062.74 rows=22,679 width=37) (actual time=5.218..30.152 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
13. 4.710 4.710 ↓ 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.710..4.710 rows=86,221 loops=1)

  • Index Cond: (user_taglio = 0)
14. 0.006 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
15. 0.010 0.010 ↑ 1.0 38 1

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

  • Filter: (dt_cancel IS NULL)
  • Rows Removed by Filter: 17
16. 89.512 89.512 ↓ 0.0 0 44,756

Index Scan using p_t_caso on t_caso t_caso_1 (cost=0.43..7.31 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=44,756)

  • 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
17. 10.954 10.954 ↓ 2.0 2 5,477

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

  • Index Cond: (id_acc_mat = t_vetrino.id_acc_mat)
  • Filter: (dt_cancel IS NULL)
  • Rows Removed by Filter: 0
18. 10.946 10.946 ↑ 1.0 1 5,473

Index Scan using p_t_blocchetto on t_blocchetto b (cost=0.42..6.48 rows=1 width=14) (actual time=0.002..0.002 rows=1 loops=5,473)

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

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

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

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

  • Index Cond: (b.id_campionamento = id_campionamento)
21. 10.384 10.384 ↑ 1.0 1 5,192

Index Scan using p_t_paziente on t_paziente (cost=0.42..6.90 rows=1 width=20) (actual time=0.002..0.002 rows=1 loops=5,192)

  • Index Cond: (id_paziente = t_caso_1.id_paziente)
  • Filter: (dt_cancel IS NULL)
  • Rows Removed by Filter: 0
22. 10.316 10.316 ↑ 1.0 13 5,158

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

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