# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.024 | 7.370 | ↑ 4.5 | 2 | 1 |
→
Sort (cost=361.20..361.23 rows=9 width=144) (actual time=7.369..7.370 rows=2 loops=1)
|
2. | 6.455 | 7.346 | ↑ 4.5 | 2 | 1 |
→
Nested Loop Left Join (cost=44.25..361.06 rows=9 width=144) (actual time=5.628..7.346 rows=2 loops=1) |
3. | 0.012 | 0.889 | ↑ 4.5 | 2 | 1 |
→
Hash Left Join (cost=43.97..283.10 rows=9 width=128) (actual time=0.867..0.889 rows=2 loops=1)
|
4. | 0.002 | 0.040 | ↑ 4.5 | 2 | 1 |
→
Nested Loop Left Join (cost=1.69..240.77 rows=9 width=112) (actual time=0.021..0.040 rows=2 loops=1) |
5. | 0.004 | 0.038 | ↑ 4.5 | 2 | 1 |
→
Nested Loop Left Join (cost=1.27..164.75 rows=9 width=92) (actual time=0.020..0.038 rows=2 loops=1) |
6. | 0.010 | 0.026 | ↑ 4.5 | 2 | 1 |
→
Nested Loop Left Join (cost=0.98..89.96 rows=9 width=72) (actual time=0.012..0.026 rows=2 loops=1) |
7. | 0.010 | 0.010 | ↑ 4.5 | 2 | 1 |
→
Index Scan using tochki_idx on tochki (cost=0.56..13.93 rows=9 width=48) (actual time=0.008..0.010 rows=2 loops=1)
|
8. | 0.006 | 0.006 | ↓ 0.0 | 0 | 2 |
→
Index Scan using adress_table_pkey on adress (cost=0.42..8.44 rows=1 width=28) (actual time=0.003..0.003 rows=0 loops=2)
|
9. | 0.008 | 0.008 | ↓ 0.0 | 0 | 2 |
→
Index Scan using org_pkey on org (cost=0.28..8.30 rows=1 width=24) (actual time=0.003..0.004 rows=0 loops=2)
|
10. | 0.000 | 0.000 | ↓ 0.0 | 0 | 2 |
→
Index Scan using all_pkey on ""all"" (cost=0.42..8.44 rows=1 width=28) (actual time=0.000..0.000 rows=0 loops=2)
|
11. | 0.431 | 0.837 | ↑ 1.0 | 1,168 | 1 |
→
Hash (cost=27.68..27.68 rows=1,168 width=20) (actual time=0.837..0.837 rows=1,168 loops=1)
|
12. | 0.406 | 0.406 | ↑ 1.0 | 1,168 | 1 |
→
Seq Scan on mesta (cost=0.00..27.68 rows=1,168 width=20) (actual time=0.003..0.406 rows=1,168 loops=1) |
13. | 0.002 | 0.002 | ↓ 0.0 | 0 | 2 |
→
Index Scan using crossroad_table_2_crossroad_pkey on crossroad_table_2 (cost=0.29..8.30 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=2)
|
Planning time | : | 3.030 ms |
---|