explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9csSU

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 31.995 ↓ 107.0 107 1

Subquery Scan on v_no_ass2 (cost=226,311.47..226,311.49 rows=1 width=214) (actual time=31.958..31.995 rows=107 loops=1)

2. 0.267 31.984 ↓ 107.0 107 1

HashAggregate (cost=226,311.47..226,311.48 rows=1 width=78) (actual time=31.957..31.984 rows=107 loops=1)

3. 0.119 31.717 ↓ 195.0 195 1

Nested Loop (cost=882.06..226,311.42 rows=1 width=78) (actual time=12.250..31.717 rows=195 loops=1)

4. 0.689 31.204 ↓ 197.0 197 1

Nested Loop (cost=881.63..226,305.78 rows=1 width=66) (actual time=12.242..31.204 rows=197 loops=1)

  • Join Filter: ((t_caso.tp_accesso)::text = (t_tp_accesso.tp_accesso)::text)
  • Rows Removed by Join Filter: 2364
5. 0.028 30.121 ↓ 197.0 197 1

Nested Loop (cost=881.63..226,304.43 rows=1 width=64) (actual time=12.227..30.121 rows=197 loops=1)

6. 0.000 29.699 ↓ 197.0 197 1

Nested Loop Left Join (cost=881.21..226,299.17 rows=1 width=62) (actual time=12.220..29.699 rows=197 loops=1)

  • Filter: (c.dt_cancel IS NULL)
7. 0.000 29.315 ↓ 197.0 197 1

Nested Loop (cost=880.78..226,293.87 rows=1 width=50) (actual time=12.212..29.315 rows=197 loops=1)

8. 16.618 20.298 ↑ 10.3 3,318 1

Bitmap Heap Scan on t_blocchetto b (cost=880.35..4,828.54 rows=34,139 width=28) (actual time=4.054..20.298 rows=3,318 loops=1)

  • Recheck Cond: (user_inclusione = 0)
  • Filter: ((dt_cancel IS NULL) AND (((fl_estemporanea)::text <> 'S'::text) OR (fl_estemporanea IS NULL)) AND ((tp_inclusione IS NULL) OR ((tp_inclusione)::text <> 'O'::text)) AND ((tp_blocchetto IS NULL) OR ((tp_bl (...)
  • Rows Removed by Filter: 43388
9. 3.680 3.680 ↑ 1.0 46,706 1

Bitmap Index Scan on i_blocchetto2 (cost=0.00..871.82 rows=46,853 width=0) (actual time=3.680..3.680 rows=46,706 loops=1)

  • Index Cond: (user_inclusione = 0)
10. 9.954 9.954 ↓ 0.0 0 3,318

Index Scan using t_caso2 on t_caso (cost=0.43..6.48 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=3,318)

  • Index Cond: (id_acc_mat = b.id_acc_mat)
  • Filter: ((dt_cancel IS NULL) AND (id_caso_p = id_caso) AND (((fl_stato)::text <> ALL ('{I,P,V,R,Z,F}'::text[])) OR ((b.splittato)::text = 'S'::text)))
  • Rows Removed by Filter: 1
11. 0.394 0.394 ↑ 1.0 1 197

Index Scan using p_t_campionamento on t_campionamento c (cost=0.43..5.29 rows=1 width=24) (actual time=0.001..0.002 rows=1 loops=197)

  • Index Cond: (b.id_campionamento = id_campionamento)
12. 0.394 0.394 ↑ 1.0 1 197

Index Scan using p_t_prelievo on t_prelievo (cost=0.43..5.25 rows=1 width=10) (actual time=0.002..0.002 rows=1 loops=197)

  • Index Cond: (id_prelievo = b.id_prelievo)
  • Filter: (dt_cancel IS NULL)
13. 0.394 0.394 ↑ 1.0 13 197

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

  • Filter: (dt_cancel IS NULL)
  • Rows Removed by Filter: 6
14. 0.394 0.394 ↑ 1.0 1 197

Index Scan using p_t_paziente on t_paziente (cost=0.42..5.63 rows=1 width=20) (actual time=0.002..0.002 rows=1 loops=197)

  • Index Cond: (id_paziente = t_caso.id_paziente)
  • Filter: (dt_cancel IS NULL)
Total runtime : 32.231 ms