explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DL50 : Optimization for: test; plan #ITfd

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 166.299 631.928 ↓ 4,193.3 29,353 1

Sort (cost=23.810..23.830 rows=7 width=142) (actual time=628.101..631.928 rows=29,353 loops=1)

  • Sort Key: papa.lima, three.quebec_juliet
  • Sort Method: quicksort Memory: 7239kB
2. 20.743 465.629 ↓ 4,193.3 29,353 1

Nested Loop Left Join (cost=1.990..23.710 rows=7 width=142) (actual time=0.191..465.629 rows=29,353 loops=1)

3. 11.763 327.474 ↓ 4,193.3 29,353 1

Nested Loop (cost=1.700..21.210 rows=7 width=92) (actual time=0.172..327.474 rows=29,353 loops=1)

4. 18.103 257.005 ↓ 4,193.3 29,353 1

Nested Loop (cost=1.560..20.030 rows=7 width=73) (actual time=0.149..257.005 rows=29,353 loops=1)

5. 24.459 180.196 ↓ 4,193.3 29,353 1

Nested Loop (cost=1.420..18.820 rows=7 width=74) (actual time=0.136..180.196 rows=29,353 loops=1)

6. 12.994 97.067 ↓ 4,190.7 29,335 1

Nested Loop (cost=1.270..17.610 rows=7 width=62) (actual time=0.131..97.067 rows=29,335 loops=1)

7. 11.333 25.403 ↓ 4,190.7 29,335 1

Nested Loop (cost=1.130..16.400 rows=7 width=54) (actual time=0.120..25.403 rows=29,335 loops=1)

8. 0.007 0.104 ↑ 1.0 1 1

Nested Loop (cost=0.710..14.750 rows=1 width=38) (actual time=0.101..0.104 rows=1 loops=1)

9. 0.078 0.078 ↑ 1.0 1 1

Index Scan using kilo_uniform on two_golf juliet (cost=0.420..7.440 rows=1 width=8) (actual time=0.077..0.078 rows=1 loops=1)

  • Index Cond: ((bravo = 17647) AND (sierra = 1))
10. 0.019 0.019 ↑ 1.0 1 1

Index Scan using alpha on two_india india_charlie (cost=0.290..7.300 rows=1 width=30) (actual time=0.018..0.019 rows=1 loops=1)

  • Index Cond: (oscar = juliet.two_alpha)
11. 13.966 13.966 ↓ 946.3 29,335 1

Index Scan using five_four on quebec_golf (cost=0.420..1.340 rows=31 width=32) (actual time=0.016..13.966 rows=29,335 loops=1)

  • Index Cond: (mike = india_charlie.oscar)
12. 58.670 58.670 ↑ 1.0 1 29,335

Index Only Scan using kilo_alpha on charlie whiskey_yankee (cost=0.140..0.160 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=29,335)

  • Index Cond: (india_whiskey = quebec_golf.india_whiskey)
  • Heap Fetches: 29335
13. 58.670 58.670 ↑ 1.0 1 29,335

Index Scan using delta on five_echo golf_juliet (cost=0.140..0.160 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=29,335)

  • Index Cond: (six = quebec_golf.india_whiskey)
14. 58.706 58.706 ↑ 1.0 1 29,353

Index Scan using uniform on hotel papa (cost=0.140..0.160 rows=1 width=19) (actual time=0.001..0.002 rows=1 loops=29,353)

  • Index Cond: (six = quebec_golf.india_whiskey)
15. 58.706 58.706 ↑ 1.0 1 29,353

Index Scan using victor on romeo (cost=0.140..0.160 rows=1 width=23) (actual time=0.001..0.002 rows=1 loops=29,353)

  • Index Cond: (whiskey_november = quebec_golf.zulu)
16. 117.412 117.412 ↑ 1.0 1 29,353

Index Scan using alpha on two_india three (cost=0.290..0.340 rows=1 width=30) (actual time=0.003..0.004 rows=1 loops=29,353)

  • Index Cond: (oscar = quebec_golf.golf_charlie)