# | 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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
Total runtime | : | 51.609 ms |
---|