explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RV3g : QUERY8

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.015 4.393 ↑ 1.0 1 1

Aggregate (cost=104.080..104.090 rows=1 width=72) (actual time=4.389..4.393 rows=1 loops=1)

2. 0.008 4.378 ↓ 0.0 0 1

Unique (cost=104.010..104.040 rows=2 width=44) (actual time=4.378..4.378 rows=0 loops=1)

3. 0.045 4.370 ↓ 0.0 0 1

Sort (cost=104.010..104.020 rows=2 width=44) (actual time=4.370..4.370 rows=0 loops=1)

  • Sort Key: seven_juliet.hotel, seven_juliet.two_echo, seven_juliet.seven_mike, seven_juliet.victor
  • Sort Method: quicksort Memory: 25kB
4. 0.012 4.325 ↓ 0.0 0 1

Append (cost=51.980..104.000 rows=2 width=44) (actual time=4.325..4.325 rows=0 loops=1)

5. 0.009 2.322 ↓ 0.0 0 1

Subquery Scan on seven_juliet (cost=51.980..51.990 rows=1 width=31) (actual time=2.322..2.322 rows=0 loops=1)

6. 0.009 2.313 ↓ 0.0 0 1

Limit (cost=51.980..51.980 rows=1 width=35) (actual time=2.313..2.313 rows=0 loops=1)

7. 0.019 2.304 ↓ 0.0 0 1

Sort (cost=51.980..51.980 rows=1 width=35) (actual time=2.304..2.304 rows=0 loops=1)

  • Sort Key: romeo_quebec.whiskey DESC
  • Sort Method: quicksort Memory: 25kB
8. 0.210 2.285 ↓ 0.0 0 1

Hash Join (cost=8.910..51.970 rows=1 width=35) (actual time=2.285..2.285 rows=0 loops=1)

  • Hash Cond: (romeo_quebec.five = tango.quebec)
9. 0.342 0.342 ↓ 1.6 39 1

Index Scan using alpha_tango on alpha_echo romeo_quebec (cost=0.420..43.380 rows=24 width=13) (actual time=0.038..0.342 rows=39 loops=1)

  • Index Cond: (zulu = 23935)
10. 0.035 1.733 ↑ 1.3 3 1

Hash (cost=8.440..8.440 rows=4 width=4) (actual time=1.733..1.733 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.894 1.698 ↑ 1.3 3 1

Hash Join (cost=1.540..8.440 rows=4 width=4) (actual time=1.157..1.698 rows=3 loops=1)

  • Hash Cond: (tango.xray_zulu = yankee.quebec)
12. 0.762 0.762 ↓ 1.1 140 1

Seq Scan on romeo_mike tango (cost=0.000..6.400 rows=123 width=8) (actual time=0.013..0.762 rows=140 loops=1)

  • Filter: ((three = 1) AND ((echo)::text = 'lima'::text))
  • Rows Removed by Filter: 37
13. 0.020 0.042 ↑ 1.0 1 1

Hash (cost=1.520..1.520 rows=1 width=4) (actual time=0.042..0.042 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 0.022 0.022 ↑ 1.0 1 1

Seq Scan on romeo_four yankee (cost=0.000..1.520 rows=1 width=4) (actual time=0.012..0.022 rows=1 loops=1)

  • Filter: ((three = 1) AND ((juliet_oscar_four)::text = 'two_oscar'::text))
  • Rows Removed by Filter: 34
15. 0.010 1.991 ↓ 0.0 0 1

Subquery Scan on india (cost=51.980..51.990 rows=1 width=31) (actual time=1.991..1.991 rows=0 loops=1)

16. 0.008 1.981 ↓ 0.0 0 1

Limit (cost=51.980..51.980 rows=1 width=35) (actual time=1.981..1.981 rows=0 loops=1)

17. 0.025 1.973 ↓ 0.0 0 1

Sort (cost=51.980..51.980 rows=1 width=35) (actual time=1.973..1.973 rows=0 loops=1)

  • Sort Key: juliet_oscar_bravo1.whiskey DESC
  • Sort Method: quicksort Memory: 25kB
18. 0.210 1.948 ↓ 0.0 0 1

Hash Join (cost=8.910..51.970 rows=1 width=35) (actual time=1.948..1.948 rows=0 loops=1)

  • Hash Cond: (juliet_oscar_bravo1.five = delta_two1.quebec)
19. 0.221 0.221 ↓ 1.6 39 1

Index Scan using alpha_tango on alpha_echo xray_romeo (cost=0.420..43.380 rows=24 width=13) (actual time=0.012..0.221 rows=39 loops=1)

  • Index Cond: (zulu = 23935)
20. 0.033 1.517 ↑ 1.3 3 1

Hash (cost=8.440..8.440 rows=4 width=4) (actual time=1.517..1.517 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
21. 0.694 1.484 ↑ 1.3 3 1

Hash Join (cost=1.540..8.440 rows=4 width=4) (actual time=0.946..1.484 rows=3 loops=1)

  • Hash Cond: (delta_two1.xray_zulu = juliet_seven1.quebec)
22. 0.746 0.746 ↓ 1.1 140 1

Seq Scan on romeo_mike delta_five (cost=0.000..6.400 rows=123 width=8) (actual time=0.012..0.746 rows=140 loops=1)

  • Filter: ((three = 1) AND ((echo)::text = 'lima'::text))
  • Rows Removed by Filter: 37
23. 0.021 0.044 ↑ 1.0 1 1

Hash (cost=1.520..1.520 rows=1 width=4) (actual time=0.044..0.044 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
24. 0.023 0.023 ↑ 1.0 1 1

Seq Scan on romeo_four kilo (cost=0.000..1.520 rows=1 width=4) (actual time=0.011..0.023 rows=1 loops=1)

  • Filter: ((three = 1) AND ((juliet_oscar_four)::text = 'two_oscar'::text))
  • Rows Removed by Filter: 34