explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TCKS

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

Sort (cost=11,705.55..11,705.56 rows=1 width=18) (actual rows= loops=)

  • Sort Key: it.item_name
2. 0.000 0.000 ↓ 0.0

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

3. 0.000 0.000 ↓ 0.0

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

  • Workers Planned: 1
4. 0.000 0.000 ↓ 0.0

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

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

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

6. 0.000 0.000 ↓ 0.0

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

7. 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.item_id
8. 0.000 0.000 ↓ 0.0

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

9. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (item_id = st.item_id)