explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GgdD

Settings
# 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)

  • Sort Key: tochki.date_create
  • Sort Method: quicksort Memory: 25kB
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)

  • Hash Cond: (tochki.id_mesta = mesta.id)
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)

  • Index Cond: (id_order = 22,208,030)
  • Filter: (del_ IS NULL)
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)

  • Index Cond: (id = tochki.id_adres)
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)

  • Index Cond: (id = tochki.id_org)
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)

  • Index Cond: (id = tochki.id_all)
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)

  • Buckets: 2,048 Batches: 1 Memory Usage: 76kB
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)

  • Index Cond: (id = tochki.id_crossroad)