explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yMS : Optimization for: base plan for \d from psql; plan #KrT2

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.001 0.017 ↓ 0.0 0 1

Limit (cost=3.170..43.490 rows=1 width=2,841) (actual time=0.017..0.017 rows=0 loops=1)

2. 0.000 0.016 ↓ 0.0 0 1

Nested Loop (cost=3.170..43.490 rows=1 width=2,841) (actual time=0.016..0.016 rows=0 loops=1)

3. 0.002 0.016 ↓ 0.0 0 1

Nested Loop (cost=2.730..35.020 rows=1 width=2,608) (actual time=0.016..0.016 rows=0 loops=1)

4. 0.000 0.014 ↓ 0.0 0 1

Nested Loop (cost=2.160..26.430 rows=1 width=1,222) (actual time=0.014..0.014 rows=0 loops=1)

5. 0.000 0.014 ↓ 0.0 0 1

Nested Loop (cost=2.030..26.220 rows=1 width=1,204) (actual time=0.014..0.014 rows=0 loops=1)

6. 0.000 0.014 ↓ 0.0 0 1

Nested Loop (cost=1.880..26.040 rows=1 width=1,172) (actual time=0.014..0.014 rows=0 loops=1)

7. 0.000 0.014 ↓ 0.0 0 1

Nested Loop (cost=1.440..17.570 rows=1 width=953) (actual time=0.014..0.014 rows=0 loops=1)

8. 0.002 0.014 ↓ 0.0 0 1

Nested Loop (cost=1.000..17.050 rows=1 width=901) (actual time=0.014..0.014 rows=0 loops=1)

9. 0.012 0.012 ↓ 0.0 0 1

Index Scan using zulu_zulu on delta (cost=0.560..8.580 rows=1 width=889) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (charlie = 83,814,785)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using zulu_uniform on five (cost=0.440..8.460 rows=1 width=12) (never executed)

  • Index Cond: (quebec = delta.yankee_uniform)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using seven on hotel_three (cost=0.440..0.510 rows=1 width=52) (never executed)

  • Index Cond: (quebec = five.bravo)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using golf on india (cost=0.440..8.460 rows=1 width=219) (never executed)

  • Index Cond: (quebec = delta.foxtrot)
13. 0.000 0.000 ↓ 0.0 0

Index Scan using whiskey_delta on oscar (cost=0.150..0.170 rows=1 width=32) (never executed)

  • Index Cond: (quebec = india.hotel_hotel)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using yankee_oscar on echo (cost=0.130..0.200 rows=1 width=18) (never executed)

  • Index Cond: (quebec = oscar.whiskey_india)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using three_alpha on three_four (cost=0.560..8.580 rows=1 width=1,386) (never executed)

  • Index Cond: (quebec = delta.four)
16. 0.000 0.000 ↓ 0.0 0

Index Scan using yankee_whiskey on whiskey_quebec (cost=0.440..8.460 rows=1 width=233) (never executed)

  • Index Cond: (quebec = delta.alpha)