explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I9CV

Settings
# exclusive inclusive rows x rows loops node
1. 59.193 378.733 ↑ 1.0 1 1

Aggregate (cost=4,188.260..4,188.270 rows=1 width=32) (actual time=378.733..378.733 rows=1 loops=1)

2. 0.569 319.540 ↓ 7.9 252 1

Subquery Scan on echo_lima (cost=31.890..4,188.100 rows=32 width=123) (actual time=2.308..319.540 rows=252 loops=1)

3. 1.178 318.971 ↓ 7.9 252 1

Nested Loop (cost=31.890..4,187.780 rows=32 width=131) (actual time=2.301..318.971 rows=252 loops=1)

4.          

CTE six_charlie

5. 0.006 0.006 ↑ 1.0 7 1

Values Scan on "*VALUES*" (cost=0.000..0.090 rows=7 width=4) (actual time=0.004..0.006 rows=7 loops=1)

6. 0.292 0.515 ↓ 7.9 254 1

HashAggregate (cost=31.530..31.850 rows=32 width=8) (actual time=0.318..0.515 rows=254 loops=1)

  • Group Key: quebec_sierra.mike_foxtrot
7. 0.031 0.223 ↓ 13.2 424 1

Nested Loop (cost=0.280..31.450 rows=32 width=8) (actual time=0.077..0.223 rows=424 loops=1)

8. 0.010 0.010 ↑ 1.0 7 1

CTE Scan on six_charlie (cost=0.000..0.140 rows=7 width=4) (actual time=0.006..0.010 rows=7 loops=1)

9. 0.182 0.182 ↓ 12.2 61 7

Index Only Scan using foxtrot on two_india quebec_sierra (cost=0.280..4.420 rows=5 width=10) (actual time=0.016..0.026 rows=61 loops=7)

  • Index Cond: ((five_charlie = six_charlie.four) AND (golf_tango = 'seven'::text))
  • Heap Fetches: 0
10. 1.270 1.270 ↑ 1.0 1 254

Index Scan using two_hotel on mike_xray victor (cost=0.280..0.470 rows=1 width=99) (actual time=0.005..0.005 rows=1 loops=254)

  • Index Cond: (quebec_seven = quebec_sierra.mike_foxtrot)
11.          

SubPlan (for Nested Loop)

12. 62.496 316.008 ↑ 1.0 1 252

Aggregate (cost=129.390..129.400 rows=1 width=32) (actual time=1.254..1.254 rows=1 loops=252)

13. 3.024 253.512 ↓ 32.0 32 252

Subquery Scan on whiskey (cost=129.370..129.390 rows=1 width=199) (actual time=0.993..1.006 rows=32 loops=252)

14. 14.112 250.488 ↓ 32.0 32 252

Sort (cost=129.370..129.380 rows=1 width=187) (actual time=0.992..0.994 rows=32 loops=252)

  • Sort Key: lima.golf_papa, romeo.tango_romeo, romeo.golf_papa
  • Sort Method: quicksort Memory: 43kB
15. 2.376 236.376 ↓ 32.0 32 252

Nested Loop (cost=120.470..129.360 rows=1 width=187) (actual time=0.784..0.938 rows=32 loops=252)

16. 4.691 226.044 ↓ 32.0 32 252

Nested Loop (cost=120.190..129.050 rows=1 width=90) (actual time=0.781..0.897 rows=32 loops=252)

17. 0.120 212.436 ↓ 17.5 35 252

Nested Loop (cost=119.910..128.370 rows=2 width=106) (actual time=0.766..0.843 rows=35 loops=252)

18. 2.016 193.536 ↓ 18.5 37 252

Unique (cost=119.620..119.640 rows=2 width=16) (actual time=0.759..0.768 rows=37 loops=252)

19. 3.024 191.520 ↓ 25.5 51 252

Sort (cost=119.620..119.630 rows=2 width=16) (actual time=0.758..0.760 rows=51 loops=252)

  • Sort Key: two_mike.india, two_mike.mike_foxtrot
  • Sort Method: quicksort Memory: 30kB
20. 1.260 188.496 ↓ 25.5 51 252

Nested Loop (cost=0.420..119.610 rows=2 width=16) (actual time=0.209..0.748 rows=51 loops=252)

21. 0.252 0.252 ↑ 1.0 7 252

CTE Scan on six_charlie five_whiskey (cost=0.000..0.140 rows=7 width=4) (actual time=0.000..0.001 rows=7 loops=252)

22. 186.984 186.984 ↓ 7.0 7 1,764

Index Only Scan using sierra on alpha two_mike (cost=0.420..17.060 rows=1 width=18) (actual time=0.048..0.106 rows=7 loops=1,764)

  • Index Cond: ((five_charlie = hotel1.four) AND (golf_tango = 'seven'::text) AND (mike_foxtrot = victor.quebec_seven))
  • Heap Fetches: 19
23. 18.780 18.780 ↑ 1.0 1 9,390

Index Scan using echo_two on six_three romeo (cost=0.290..4.370 rows=1 width=90) (actual time=0.002..0.002 rows=1 loops=9,390)

  • Index Cond: (quebec_seven = two_mike.india)
24. 8.917 8.917 ↑ 1.0 1 8,917

Index Only Scan using bravo on kilo zulu (cost=0.290..0.340 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=8,917)

  • Index Cond: ((mike_foxtrot = victor.quebec_seven) AND (india = romeo.quebec_seven))
  • Heap Fetches: 0
25. 7.956 7.956 ↑ 1.0 1 7,956

Index Scan using tango_lima on echo_bravo lima (cost=0.280..0.310 rows=1 width=97) (actual time=0.001..0.001 rows=1 loops=7,956)

  • Index Cond: (quebec_seven = romeo.tango_romeo)
Planning time : 3.382 ms
Execution time : 379.689 ms