explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4ld1

Settings
# exclusive inclusive rows x rows loops node
1. 1.565 148.502 ↓ 124.7 6,856 1

Nested Loop Left Join (cost=0.71..150,152.35 rows=55 width=19) (actual time=0.016..148.502 rows=6,856 loops=1)

2. 4.320 140.083 ↓ 124.6 6,854 1

Nested Loop (cost=0.43..149,935.77 rows=55 width=19) (actual time=0.013..140.083 rows=6,854 loops=1)

3. 46.253 46.253 ↓ 2.0 44,755 1

Seq Scan on t_vetrino (cost=0.00..7,554.03 rows=22,679 width=11) (actual time=0.006..46.253 rows=44,755 loops=1)

  • Filter: ((dt_cancel IS NULL) AND (annullato IS NULL) AND (user_taglio = 0) AND (user_consegna = 0))
  • Rows Removed by Filter: 179314
4. 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
5. 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.805 ms