explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PvKx

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

GroupAggregate (cost=33,923.49..38,923.49 rows=250,000 width=26) (actual rows= loops=)

  • Group Key: store.item_id, item.item_name
2. 0.000 0.000 ↓ 0.0

Sort (cost=33,923.49..34,548.49 rows=250,000 width=26) (actual rows= loops=)

  • Sort Key: store.item_id, item.item_name
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=31.75..5,527.53 rows=250,000 width=26) (actual rows= loops=)

  • Hash Cond: (store.item_id = item.item_id)
4. 0.000 0.000 ↓ 0.0

Seq Scan on store (cost=0.00..4,837.00 rows=250,000 width=16) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=18.00..18.00 rows=1,100 width=18) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on item (cost=0.00..18.00 rows=1,100 width=18) (actual rows= loops=)