explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 835Y

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

Unique (cost=60.37..64.06 rows=200 width=186) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=60.37..62.21 rows=738 width=186) (actual rows= loops=)

  • Sort Key: tracking.id, tracking."timestamp" DESC
3. 0.000 0.000 ↓ 0.0

Append (cost=0.00..25.21 rows=738 width=186) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on tracking (cost=0.00..0.00 rows=1 width=340) (actual rows= loops=)

  • Filter: (game_id = 'e43bc6c9-8909-4276-902a-50b7b380c822'::uuid)
5. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_2_1449_chunk (cost=0.00..25.21 rows=737 width=186) (actual rows= loops=)

  • Filter: (game_id = 'e43bc6c9-8909-4276-902a-50b7b380c822'::uuid)