explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4BcC

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

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

  • Merge Cond: (five_hotel.quebec_seven = romeo_three1.seven)
  • Buffers: shared hit=176
2. 0.019 0.045 ↑ 410.0 1 1

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

  • Group Key: five_hotel.quebec_seven
  • Buffers: shared hit=6
3. 0.010 0.026 ↑ 2,015.0 2 1

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

  • Buffers: shared hit=6
4. 0.006 0.006 ↑ 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.006..0.006 rows=2 loops=1)

  • Buffers: shared hit=2
5. 0.010 0.010 ↑ 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.005..0.005 rows=1 loops=2)

  • Index Cond: (four_three = ANY ((five_hotel.alpha_juliet)::text[]))
  • Heap Fetches: 2
  • Buffers: shared hit=4
6. 0.004 1.892 ↓ 0.0 0 1

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

  • Sort Key: romeo_three1.seven
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=170
7. 0.000 1.888 ↓ 0.0 0 1

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

  • Buffers: shared hit=170
8. 0.002 1.888 ↓ 0.0 0 1

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

  • Buffers: shared hit=170
9. 0.006 1.886 ↓ 0.0 0 1

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

  • Sort Key: five_papa.five_november
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=170
10. 0.011 1.880 ↓ 0.0 0 1

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

  • Buffers: shared hit=170
11. 0.020 0.069 ↓ 24.0 24 1

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

  • Buffers: shared hit=26
12. 0.030 0.049 ↓ 24.0 24 1

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

  • Hash Cond: (victor_seven.quebec_seven = five_papa.five_november)
  • Buffers: shared hit=2
13. 0.008 0.008 ↑ 1.0 24 1

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

  • Filter: (whiskey_echo five_romeo NULL)
  • Buffers: shared hit=1
14. 0.004 0.011 ↓ 24.0 24 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
  • Buffers: shared hit=1
15. 0.007 0.007 ↓ 24.0 24 1

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

  • Filter: ((whiskey_echo five_romeo NULL) AND (juliet = 'whiskey_romeo'::november))
  • Buffers: shared hit=1
16. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=24)

  • Index Cond: (victor_seven.quebec_seven = five_november)
  • Buffers: shared hit=24
17. 0.000 1.800 ↓ 0.0 0 24

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

  • Buffers: shared hit=144
18. 0.000 1.800 ↓ 0.0 0 24

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

  • Buffers: shared hit=144
19. 0.024 1.800 ↓ 0.0 0 24

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

  • Join Filter: (victor_seven.quebec_seven = charlie_romeo.five_november)
  • Buffers: shared hit=144
20. 1.752 1.752 ↑ 5.0 1 24

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

  • Filter: (victor_seven.quebec_seven = quebec_seven)
  • Buffers: shared hit=120
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)
  • Buffers: shared hit=24
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 = 10215) OR (10215 = 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)