explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aDqe

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

Append (cost=80,879,960.24..105,842,422.72 rows=104,299,219 width=40) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=80,879,960.24..83,444,776.96 rows=95,897,170 width=40) (actual rows= loops=)

  • Group Key: i.provider_id, p.name
3. 0.000 0.000 ↓ 0.0

Sort (cost=80,879,960.24..81,281,421.50 rows=160,584,502 width=49) (actual rows= loops=)

  • Sort Key: i.provider_id, p.name
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=28,885.78..52,720,454.31 rows=160,584,502 width=49) (actual rows= loops=)

  • Hash Cond: (i.provider_id = p.id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on item i (cost=0.00..50,664,207.04 rows=160,584,502 width=21) (actual rows= loops=)

  • Filter: (storage_id IS NOT NULL)
6. 0.000 0.000 ↓ 0.0

Hash (cost=27,887.57..27,887.57 rows=79,857 width=32) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on provider p (cost=0.00..27,887.57 rows=79,857 width=32) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=21,186,612.59..21,354,653.57 rows=8,402,049 width=40) (actual rows= loops=)

  • Group Key: it.provider_id, pp.name
9. 0.000 0.000 ↓ 0.0

Sort (cost=21,186,612.59..21,207,617.71 rows=8,402,049 width=36) (actual rows= loops=)

  • Sort Key: it.provider_id, pp.name
10. 0.000 0.000 ↓ 0.0

Gather (cost=29,886.35..20,088,995.92 rows=8,402,049 width=36) (actual rows= loops=)

  • Workers Planned: 2
11. 0.000 0.000 ↓ 0.0

Hash Join (cost=28,886.35..19,247,791.02 rows=3,500,854 width=36) (actual rows= loops=)

  • Hash Cond: (it.provider_id = pp.id)
12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..19,174,707.35 rows=3,500,854 width=8) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on historical_item_storage_id h (cost=0.00..219,671.02 rows=7,666,102 width=4) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Index Scan using item_pkey on item it (cost=0.57..2.47 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = h.item_id)
  • Filter: (storage_id IS NULL)
15. 0.000 0.000 ↓ 0.0

Hash (cost=27,887.57..27,887.57 rows=79,857 width=32) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on provider pp (cost=0.00..27,887.57 rows=79,857 width=32) (actual rows= loops=)