explain.depesz.com

PostgreSQL's explain analyze made readable

Result: inHm

Settings
# exclusive inclusive rows x rows loops node
1. 1.839 148.150 ↓ 195.9 6,856 1

Nested Loop Left Join (cost=1,605.78..148,322.12 rows=35 width=19) (actual time=6.286..148.150 rows=6,856 loops=1)

2. 7.111 139.457 ↓ 195.8 6,854 1

Nested Loop (cost=1,605.50..148,184.31 rows=35 width=19) (actual time=6.281..139.457 rows=6,854 loops=1)

3. 12.887 42.836 ↓ 2.0 44,755 1

Hash Left Join (cost=1,605.07..7,343.97 rows=22,440 width=11) (actual time=6.269..42.836 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))
4. 24.206 29.931 ↓ 2.0 44,755 1

Bitmap Heap Scan on t_vetrino (cost=1,603.04..7,085.89 rows=22,799 width=11) (actual time=6.237..29.931 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
5. 5.725 5.725 ↓ 1.0 86,221 1

Bitmap Index Scan on i_vetrino3 (cost=0.00..1,597.35 rows=85,990 width=0) (actual time=5.725..5.725 rows=86,221 loops=1)

  • Index Cond: (user_taglio = 0)
6. 0.007 0.018 ↑ 1.0 38 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
7. 0.011 0.011 ↑ 1.0 38 1

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

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

Index Scan using t_caso2 on t_caso v2 (cost=0.43..6.27 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=44,755)

  • Index Cond: (id_acc_mat = t_vetrino.id_acc_mat)
  • Filter: ((fl_stato)::text <> ALL ('{I,P,V,R,Z,F}'::text[]))
  • Rows Removed by Filter: 1
9. 6.854 6.854 ↓ 0.0 0 6,854

Index Scan using t_vetrino_test1 on t_vetrino_test (cost=0.29..3.93 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=6,854)

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