explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Tlfh

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 7.782 ↓ 0.0 0 1

Merge Join (cost=74.340..928.390 rows=4 width=835) (actual time=7.782..7.782 rows=0 loops=1)

  • Merge Cond: (five_hotel.quebec_seven = romeo_three1.seven)
2. 0.044 0.891 ↑ 410.0 1 1

GroupAggregate (cost=0.300..849.170 rows=410 width=16) (actual time=0.891..0.891 rows=1 loops=1)

  • Group Key: five_hotel.quebec_seven
3. 0.010 0.847 ↑ 2,015.0 2 1

Nested Loop (cost=0.300..823.900 rows=4,030 width=16) (actual time=0.840..0.847 rows=2 loops=1)

4. 0.019 0.019 ↑ 205.0 2 1

Index Scan using six on victor_golf five_hotel (cost=0.150..54.300 rows=410 width=36) (actual time=0.019..0.019 rows=2 loops=1)

5. 0.818 0.818 ↑ 10.0 1 2

Index Only Scan using foxtrot on four_echo alpha_seven (cost=0.160..1.780 rows=10 width=12) (actual time=0.408..0.409 rows=1 loops=2)

  • Index Cond: (four_three = ANY ((five_hotel.alpha_juliet)::text[]))
  • Heap Fetches: 2
6. 0.001 6.889 ↓ 0.0 0 1

Sort (cost=74.040..74.040 rows=2 width=799) (actual time=6.889..6.889 rows=0 loops=1)

  • Sort Key: romeo_three1.seven
  • Sort Method: quicksort Memory: 25kB
7. 0.000 6.888 ↓ 0.0 0 1

Subquery Scan on four_uniform (cost=33.720..74.030 rows=2 width=799) (actual time=6.888..6.888 rows=0 loops=1)

8. 0.003 6.888 ↓ 0.0 0 1

WindowAgg (cost=33.720..74.010 rows=2 width=894) (actual time=6.888..6.888 rows=0 loops=1)

9. 0.004 6.885 ↓ 0.0 0 1

Sort (cost=33.720..33.720 rows=2 width=894) (actual time=6.885..6.885 rows=0 loops=1)

  • Sort Key: five_papa.five_november
  • Sort Method: quicksort Memory: 25kB
10. 0.016 6.881 ↓ 0.0 0 1

Nested Loop (cost=15.970..33.710 rows=2 width=894) (actual time=6.881..6.881 rows=0 loops=1)

11. 0.000 0.097 ↓ 24.0 24 1

Nested Loop Left Join (cost=15.290..18.490 rows=1 width=342) (actual time=0.049..0.097 rows=24 loops=1)

12. 0.033 0.076 ↓ 24.0 24 1

Hash Join (cost=15.140..16.480 rows=1 width=183) (actual time=0.047..0.076 rows=24 loops=1)

  • Hash Cond: (victor_seven.quebec_seven = five_papa.five_november)
13. 0.024 0.024 ↑ 1.0 24 1

Seq Scan on romeo_golf victor_seven (cost=0.000..1.240 rows=24 width=175) (actual time=0.016..0.024 rows=24 loops=1)

  • Filter: (whiskey_echo five_romeo NULL)
14. 0.005 0.019 ↓ 24.0 24 1

Hash (cost=15.120..15.120 rows=1 width=8) (actual time=0.019..0.019 rows=24 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
15. 0.014 0.014 ↓ 24.0 24 1

Seq Scan on victor_golf five_papa (cost=0.000..15.120 rows=1 width=8) (actual time=0.011..0.014 rows=24 loops=1)

  • Filter: ((whiskey_echo five_romeo NULL) AND (juliet = 'whiskey_romeo'::november))
16. 0.024 0.024 ↓ 0.0 0 24

Index Scan using charlie_india on whiskey_kilo mike (cost=0.150..2.000 rows=1 width=163) (actual time=0.001..0.001 rows=0 loops=24)

  • Index Cond: (victor_seven.quebec_seven = five_november)
17. 0.000 6.768 ↓ 0.0 0 24

Nested Loop Semi Join (cost=0.690..15.210 rows=1 width=564) (actual time=0.282..0.282 rows=0 loops=24)

18. 0.024 6.768 ↓ 0.0 0 24

Nested Loop (cost=0.540..14.920 rows=1 width=568) (actual time=0.282..0.282 rows=0 loops=24)

19. 0.000 6.744 ↓ 0.0 0 24

Nested Loop (cost=0.400..14.710 rows=1 width=48) (actual time=0.281..0.281 rows=0 loops=24)

  • Join Filter: (victor_seven.quebec_seven = charlie_romeo.five_november)
20. 6.720 6.720 ↑ 5.0 1 24

Function Scan on uniform victor_quebec (cost=0.250..12.750 rows=5 width=36) (actual time=0.279..0.280 rows=1 loops=24)

  • Filter: (victor_seven.quebec_seven = quebec_seven)
21. 0.024 0.024 ↓ 0.0 0 24

Index Scan using two on lima_lima charlie_romeo (cost=0.150..0.320 rows=6 width=12) (actual time=0.001..0.001 rows=0 loops=24)

  • Index Cond: (five_november = victor_quebec.quebec_seven)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using bravo_lima on lima_tango quebec_sierra (cost=0.140..0.200 rows=1 width=520) (never executed)

  • Index Cond: (quebec_seven = charlie_romeo.tango_romeo)
  • Filter: (whiskey_echo five_romeo NULL)
23. 0.000 0.000 ↓ 0.0 0

Index Scan using bravo_lima on lima_tango (cost=0.140..0.220 rows=1 width=4) (never executed)

  • Index Cond: (quebec_seven = charlie_romeo.tango_romeo)
  • Filter: ((quebec_seven = 10003) OR (10003 = ANY (golf)))
24.          

SubPlan (for WindowAgg)

25. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=20.120..20.130 rows=1 width=544) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=7.460..20.110 rows=2 width=544) (never executed)

  • Hash Cond: (tango_golf.quebec_seven = bravo_tango.victor_kilo)
27. 0.000 0.000 ↓ 0.0 0

Seq Scan on tango_golf (cost=0.000..11.400 rows=140 width=548) (never executed)

28. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.400..7.400 rows=5 width=4) (never executed)

29. 0.000 0.000 ↓ 0.0 0

Seq Scan on yankee bravo_tango (cost=0.000..7.400 rows=5 width=4) (never executed)

  • Filter: (four_yankee = five_papa.quebec_seven)