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