explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 64uI

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

Nested Loop (cost=7,125.78..11,705.54 rows=1 width=18) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=7,125.50..11,705.25 rows=1 width=24) (actual rows= loops=)

  • Workers Planned: 1
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=6,125.50..10,705.15 rows=1 width=24) (actual rows= loops=)

  • Hash Cond: ((store.item_id = store_1.item_id) AND (store.received = (max(store_1.received))))
4. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on store (cost=0.00..3,807.59 rows=147,059 width=16) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=6,109.00..6,109.00 rows=1,100 width=16) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

HashAggregate (cost=6,087.00..6,098.00 rows=1,100 width=16) (actual rows= loops=)

  • Group Key: store_1.item_id
7. 0.000 0.000 ↓ 0.0

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

8. 0.000 0.000 ↓ 0.0

Index Scan using item_pkey on item items (cost=0.28..0.30 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (item_id = store.item_id)