explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fkS9

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

Sort (cost=19,767.060..19,776.190 rows=3,650 width=34) (actual rows= loops=)

  • Sort Key: (lima_sierra((five(quebec_sierra.oscar_xray))::real, 'november'::real)) DESC
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=19,495.780..19,551.100 rows=3,650 width=34) (actual rows= loops=)

  • Hash Cond: (echo1.quebec_seven = kilo.quebec_seven)
3. 0.000 0.000 ↓ 0.0

Sort (cost=19,478.570..19,487.690 rows=3,650 width=30) (actual rows= loops=)

  • Sort Key: (lima_sierra((five(quebec_sierra.oscar_xray))::real, 'november'::real)) DESC
4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=19,216.980..19,262.600 rows=3,650 width=30) (actual rows= loops=)

  • Group Key: quebec_sierra.oscar_three, echo1.quebec_seven
5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.000..18,854.550 rows=36,243 width=28) (actual rows= loops=)

  • Join Filter: (quebec_sierra.whiskey = ANY (echo1.romeo))
6. 0.000 0.000 ↓ 0.0

Seq Scan on papa_zulu quebec_sierra (cost=0.000..308.110 rows=2,031 width=19) (actual rows= loops=)

  • Filter: (oscar_three = 'tango'::text)
7. 0.000 0.000 ↓ 0.0

Materialize (cost=0.000..14.470 rows=365 width=50) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on lima_november papa_delta (cost=0.000..12.650 rows=365 width=50) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=12.650..12.650 rows=365 width=26) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on lima_november kilo (cost=0.000..12.650 rows=365 width=26) (actual rows= loops=)