#	exclusive	inclusive	rows x	rows	loops	node
1.	0.012	34.124	↓ 107.0	107	1	→ Subquery Scan on v_no_ass2 (cost=223,772.36..223,772.38 rows=1 width=214) (actual time=34.085..34.124 rows=107 loops=1)
2.	0.281	34.112	↓ 107.0	107	1	→ HashAggregate (cost=223,772.36..223,772.37 rows=1 width=78) (actual time=34.083..34.112 rows=107 loops=1)
3.	0.095	33.831	↓ 195.0	195	1	→ Nested Loop (cost=875.37..223,772.31 rows=1 width=78) (actual time=13.728..33.831 rows=195 loops=1)
4.	0.743	33.342	↓ 197.0	197	1	→ Nested Loop (cost=874.95..223,766.67 rows=1 width=66) (actual time=13.719..33.342 rows=197 loops=1) Join Filter: ((t_caso.tp_accesso)::text = (t_tp_accesso.tp_accesso)::text) Rows Removed by Join Filter: 2,364
5.	0.038	32.205	↓ 197.0	197	1	→ Nested Loop (cost=874.95..223,765.32 rows=1 width=64) (actual time=13.698..32.205 rows=197 loops=1)
6.	0.000	31.773	↓ 197.0	197	1	→ Nested Loop Left Join (cost=874.52..223,760.05 rows=1 width=62) (actual time=13.690..31.773 rows=197 loops=1) Filter: (c.dt_cancel IS NULL)
7.	0.000	31.385	↓ 197.0	197	1	→ Nested Loop (cost=874.10..223,754.75 rows=1 width=50) (actual time=13.682..31.385 rows=197 loops=1)
8.	17.838	22.236	↑ 10.2	3,318	1	→ Bitmap Heap Scan on t_blocchetto b (cost=873.67..4,814.12 rows=33,729 width=28) (actual time=4.848..22.236 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: 43,388
9.	4.398	4.398	↓ 1.0	46,706	1	→ Bitmap Index Scan on i_blocchetto (cost=0.00..865.24 rows=46,509 width=0) (actual time=4.398..4.398 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	:	34.348 ms

"Subquery Scan on v_no_ass2  (cost=223772.36..223772.38 rows=1 width=214) (actual time=34.085..34.124 rows=107 loops=1)"
"  ->  HashAggregate  (cost=223772.36..223772.37 rows=1 width=78) (actual time=34.083..34.112 rows=107 loops=1)"
"        ->  Nested Loop  (cost=875.37..223772.31 rows=1 width=78) (actual time=13.728..33.831 rows=195 loops=1)"
"              ->  Nested Loop  (cost=874.95..223766.67 rows=1 width=66) (actual time=13.719..33.342 rows=197 loops=1)"
"                    Join Filter: ((t_caso.tp_accesso)::text = (t_tp_accesso.tp_accesso)::text)"
"                    Rows Removed by Join Filter: 2364"
"                    ->  Nested Loop  (cost=874.95..223765.32 rows=1 width=64) (actual time=13.698..32.205 rows=197 loops=1)"
"                          ->  Nested Loop Left Join  (cost=874.52..223760.05 rows=1 width=62) (actual time=13.690..31.773 rows=197 loops=1)"
"                                Filter: (c.dt_cancel IS NULL)"
"                                ->  Nested Loop  (cost=874.10..223754.75 rows=1 width=50) (actual time=13.682..31.385 rows=197 loops=1)"
"                                      ->  Bitmap Heap Scan on t_blocchetto b  (cost=873.67..4814.12 rows=33729 width=28) (actual time=4.848..22.236 rows=3318 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"
"                                            ->  Bitmap Index Scan on i_blocchetto  (cost=0.00..865.24 rows=46509 width=0) (actual time=4.398..4.398 rows=46706 loops=1)"
"                                                  Index Cond: (user_inclusione = 0)"
"                                      ->  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=3318)"
"                                            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"
"                                ->  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)"
"                          ->  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)"
"                    ->  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"
"              ->  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: 34.348 ms"

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	17.838 ms	52.3 %
Bitmap Index Scan	1	4.398 ms	12.9 %
HashAggregate	1	0.281 ms	0.8 %
Index Scan	4	11.136 ms	32.6 %
Nested Loop	4	0.876 ms	2.6 %
Nested Loop Left Join	1	0.000 ms	0.0 %
Seq Scan	1	0.394 ms	1.2 %
Subquery Scan	1	0.012 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
t_blocchetto	1	17.838 ms	52.3 %
Bitmap Heap Scan	1	17.838 ms	100.0 %
t_campionamento	1	0.394 ms	1.2 %
Index Scan	1	0.394 ms	100.0 %
t_caso	1	9.954 ms	29.2 %
Index Scan	1	9.954 ms	100.0 %
t_paziente	1	0.394 ms	1.2 %
Index Scan	1	0.394 ms	100.0 %
t_prelievo	1	0.394 ms	1.2 %
Index Scan	1	0.394 ms	100.0 %
t_tp_accesso	1	0.394 ms	1.2 %
Seq Scan	1	0.394 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1BVG

Color mode:

Visible columns:

Per node type stats

Per table stats