#	exclusive	inclusive	rows x	rows	loops	node
1.	0.011	51.387	↓ 107.0	107	1	→ Subquery Scan on v_no_ass2 (cost=225,370.11..225,370.13 rows=1 width=214) (actual time=51.349..51.387 rows=107 loops=1)
2.	0.278	51.376	↓ 107.0	107	1	→ HashAggregate (cost=225,370.11..225,370.12 rows=1 width=78) (actual time=51.348..51.376 rows=107 loops=1)
3.	0.085	51.098	↓ 195.0	195	1	→ Nested Loop (cost=1.71..225,370.06 rows=1 width=78) (actual time=12.629..51.098 rows=195 loops=1)
4.	0.748	50.619	↓ 197.0	197	1	→ Nested Loop (cost=1.28..225,364.42 rows=1 width=66) (actual time=12.622..50.619 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.042	49.477	↓ 197.0	197	1	→ Nested Loop (cost=1.28..225,363.07 rows=1 width=64) (actual time=12.600..49.477 rows=197 loops=1)
6.	0.000	49.041	↓ 197.0	197	1	→ Nested Loop Left Join (cost=0.85..225,357.81 rows=1 width=62) (actual time=12.593..49.041 rows=197 loops=1) Filter: (c.dt_cancel IS NULL)
7.	1.616	48.650	↓ 197.0	197	1	→ Nested Loop (cost=0.43..225,352.50 rows=1 width=50) (actual time=12.586..48.650 rows=197 loops=1)
8.	40.398	40.398	↑ 10.2	3,318	1	→ Seq Scan on t_blocchetto b (cost=0.00..6,411.88 rows=33,729 width=28) (actual time=0.040..40.398 rows=3,318 loops=1) 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 (user_inclusione = 0) AND ((tp_bloc (...) Rows Removed by Filter: 153,032
9.	6.636	6.636	↓ 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.002..0.002 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
10.	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)
11.	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)
12.	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
13.	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	:	51.609 ms

"Subquery Scan on v_no_ass2  (cost=225370.11..225370.13 rows=1 width=214) (actual time=51.349..51.387 rows=107 loops=1)"
"  ->  HashAggregate  (cost=225370.11..225370.12 rows=1 width=78) (actual time=51.348..51.376 rows=107 loops=1)"
"        ->  Nested Loop  (cost=1.71..225370.06 rows=1 width=78) (actual time=12.629..51.098 rows=195 loops=1)"
"              ->  Nested Loop  (cost=1.28..225364.42 rows=1 width=66) (actual time=12.622..50.619 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=1.28..225363.07 rows=1 width=64) (actual time=12.600..49.477 rows=197 loops=1)"
"                          ->  Nested Loop Left Join  (cost=0.85..225357.81 rows=1 width=62) (actual time=12.593..49.041 rows=197 loops=1)"
"                                Filter: (c.dt_cancel IS NULL)"
"                                ->  Nested Loop  (cost=0.43..225352.50 rows=1 width=50) (actual time=12.586..48.650 rows=197 loops=1)"
"                                      ->  Seq Scan on t_blocchetto b  (cost=0.00..6411.88 rows=33729 width=28) (actual time=0.040..40.398 rows=3318 loops=1)"
"                                            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 (user_inclusione = 0) AND ((tp_bloc (...)"
"                                            Rows Removed by Filter: 153032"
"                                      ->  Index Scan using t_caso2 on t_caso  (cost=0.43..6.48 rows=1 width=40) (actual time=0.002..0.002 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: 51.609 ms"

Per node type stats

node type	count	sum of times	% of query
HashAggregate	1	0.278 ms	0.5 %
Index Scan	4	7.818 ms	15.2 %
Nested Loop	4	2.491 ms	4.8 %
Nested Loop Left Join	1	0.000 ms	0.0 %
Seq Scan	2	40.792 ms	79.4 %
Subquery Scan	1	0.011 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	40.398 ms	78.6 %
Seq Scan	1	40.398 ms	100.0 %
t_campionamento	1	0.394 ms	0.8 %
Index Scan	1	0.394 ms	100.0 %
t_caso	1	6.636 ms	12.9 %
Index Scan	1	6.636 ms	100.0 %
t_paziente	1	0.394 ms	0.8 %
Index Scan	1	0.394 ms	100.0 %
t_prelievo	1	0.394 ms	0.8 %
Index Scan	1	0.394 ms	100.0 %
t_tp_accesso	1	0.394 ms	0.8 %
Seq Scan	1	0.394 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nN86

Color mode:

Visible columns:

Per node type stats

Per table stats