explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J2q4

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=18,378.980..18,398.980 rows=1,000 width=200) (actual rows= loops=)

  • Merge Cond: (six_seven.six_seven = romeo1.alpha)
2.          

CTE four_november

3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=17,934.970..18,154.870 rows=3,715 width=261) (actual rows= loops=)

  • Hash Cond: ((romeo1kilo_oscar1.juliet_victor = romeo3.juliet_victor) AND (romeo1kilo_oscar1.alpha = romeo3.alpha))
4. 0.000 0.000 ↓ 0.0

Seq Scan on zulu_india zulu_xray (cost=0.000..99.150 rows=3,715 width=53) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=17,934.930..17,934.930 rows=3 width=216) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Subquery Scan on india_november (cost=17,934.830..17,934.930 rows=3 width=216) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

HashAggregate (cost=17,934.830..17,934.900 rows=3 width=39) (actual rows= loops=)

  • Group Key: romeo4.juliet_victor, romeo4.alpha, romeo4.oscar
8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.560..17,934.680 rows=3 width=39) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on juliet_lima xray_five (cost=0.000..24.490 rows=1,249 width=25) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using uniform on foxtrot victor (cost=0.560..14.330 rows=1 width=53) (actual rows= loops=)

  • Index Cond: ((juliet_victor = romeo5.juliet_victor) AND (juliet_victor = ANY ('kilo_delta'::integer[])) AND ((oscar)::text = 'india_echo'::text) AND ((mike)::text = (romeo5.mike)::text))
  • Filter: (alpha >= 'six_foxtrot'::timestamp without time zone)
11. 0.000 0.000 ↓ 0.0

Sort (cost=59.860..62.360 rows=1,000 width=8) (actual rows= loops=)

  • Sort Key: six_seven.six_seven
12. 0.000 0.000 ↓ 0.0

Function Scan on xray_yankee six_seven (cost=0.030..10.030 rows=1,000 width=8) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Sort (cost=164.240..164.740 rows=200 width=196) (actual rows= loops=)

  • Sort Key: romeo1.alpha
14. 0.000 0.000 ↓ 0.0

Subquery Scan on four_uniform (cost=148.600..156.600 rows=200 width=196) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

HashAggregate (cost=148.600..154.600 rows=200 width=196) (actual rows= loops=)

  • Group Key: four_november.alpha
16. 0.000 0.000 ↓ 0.0

CTE Scan on four_november (cost=0.000..74.300 rows=3,715 width=196) (actual rows= loops=)