explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gryq : Kra

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

Sort (cost=5,898.880..5,899.140 rows=104 width=76) (actual rows= loops=)

  • Sort Key: (five(two.*)) DESC
2. 0.000 0.000 ↓ 0.0

WindowAgg (cost=5,883.000..5,895.400 rows=104 width=76) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=5,883.000..5,891.760 rows=104 width=44) (actual rows= loops=)

  • Group Key: ((victor.delta_alpha ->> 'golf'::text))
4. 0.000 0.000 ↓ 0.0

Sort (cost=5,883.000..5,884.490 rows=597 width=119) (actual rows= loops=)

  • Sort Key: ((victor.delta_alpha ->> 'golf'::text))
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=5.340..5,855.470 rows=597 width=119) (actual rows= loops=)

  • Hash Cond: (two.echo = victor.sierra)
6. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_foxtrot two (cost=0.000..5,847.000 rows=597 width=91) (actual rows= loops=)

  • Filter: (whiskey_alpha > ('delta_whiskey'::timestamp with time zone - 'seven'::interval))
7. 0.000 0.000 ↓ 0.0

Hash (cost=4.040..4.040 rows=104 width=65) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on uniform victor (cost=0.000..4.040 rows=104 width=65) (actual rows= loops=)