explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i86r

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 114.920 ↓ 101.4 5,476 1

Nested Loop (cost=1,590.40..149,308.48 rows=54 width=15) (actual time=5.503..114.920 rows=5,476 loops=1)

2. 24.026 29.038 ↓ 2.0 44,755 1

Bitmap Heap Scan on t_vetrino (cost=1,589.97..7,062.74 rows=22,679 width=7) (actual time=5.493..29.038 rows=44,755 loops=1)

  • Recheck Cond: (user_taglio = 0)
  • Filter: ((dt_cancel IS NULL) AND (user_consegna = 0))
  • Rows Removed by Filter: 41466
3. 5.012 5.012 ↓ 1.0 86,221 1

Bitmap Index Scan on i_ppppp (cost=0.00..1,584.31 rows=85,318 width=0) (actual time=5.012..5.012 rows=86,221 loops=1)

  • Index Cond: (user_taglio = 0)
4. 89.510 89.510 ↓ 0.0 0 44,755

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

  • Index Cond: (id_caso = t_vetrino.id_caso)
  • Filter: ((fl_stato)::text <> ALL ('{I,P,V,R,Z,F}'::text[]))
  • Rows Removed by Filter: 1
Total runtime : 115.232 ms