explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VYRK

Settings
# exclusive inclusive rows x rows loops node
1. 1.375 141.234 ↓ 5,473.0 5,473 1

Nested Loop Left Join (cost=1,157.33..168,501.93 rows=1 width=19) (actual time=3.688..141.234 rows=5,473 loops=1)

2. 0.000 134.387 ↓ 5,472.0 5,472 1

Nested Loop (cost=1,157.05..168,495.84 rows=1 width=19) (actual time=3.684..134.387 rows=5,472 loops=1)

  • Join Filter: (t_caso_1.id_caso_p = t_caso.id_caso)
  • Rows Removed by Join Filter: 2806
3. 0.000 123.593 ↓ 156.5 5,476 1

Nested Loop (cost=1,156.62..168,243.79 rows=35 width=15) (actual time=3.679..123.593 rows=5,476 loops=1)

4. 14.986 35.659 ↓ 2.0 44,755 1

Hash Left Join (cost=1,156.19..6,533.33 rows=22,440 width=15) (actual time=3.670..35.659 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))
5. 17.484 20.657 ↓ 2.0 44,755 1

Bitmap Heap Scan on t_vetrino (cost=1,154.17..6,275.26 rows=22,799 width=15) (actual time=3.645..20.657 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
6. 3.173 3.173 ↓ 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.173..3.173 rows=61,876 loops=1)

  • Index Cond: (user_consegna = 0)
7. 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
8. 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
9. 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.20 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
10. 10.952 10.952 ↓ 2.0 2 5,476

Index Scan using t_caso2 on t_caso (cost=0.43..7.19 rows=1 width=20) (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
11. 5.472 5.472 ↓ 0.0 0 5,472

Index Scan using t_vetrino_test1 on t_vetrino_test (cost=0.29..6.07 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=5,472)

  • Index Cond: (t_vetrino.id_vetrino = id_vetrino)
Total runtime : 141.588 ms