explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yhLb

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

Nested Loop Left Join (cost=62,766,960.94..62,771,623.19 rows=1 width=885) (actual rows= loops=)

2.          

CTE imports

3. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=60,602,072.33..62,766,943.05 rows=195,967 width=12) (actual rows= loops=)

  • Group Key: package_imports.path_id
4. 0.000 0.000 ↓ 0.0

Gather Merge (cost=60,602,072.33..62,763,023.71 rows=391,934 width=12) (actual rows= loops=)

  • Workers Planned: 2
5. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=60,601,072.31..62,716,784.78 rows=195,967 width=12) (actual rows= loops=)

  • Group Key: package_imports.path_id
6. 0.000 0.000 ↓ 0.0

Sort (cost=60,601,072.31..61,305,656.57 rows=281,833,707 width=4) (actual rows= loops=)

  • Sort Key: package_imports.path_id
7. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on package_imports (cost=0.00..9,485,746.07 rows=281,833,707 width=4) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=17.32..4,671.55 rows=1 width=392) (actual rows= loops=)

  • Hash Cond: (i.path_id = p.id)
9. 0.000 0.000 ↓ 0.0

CTE Scan on imports i (cost=0.00..3,919.34 rows=195,967 width=12) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=17.31..17.31 rows=1 width=384) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.25..17.31 rows=1 width=384) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Index Scan using modules_pkey on modules m (cost=0.55..8.57 rows=1 width=190) (actual rows= loops=)

  • Index Cond: ((module_path = 'github.com/aws/aws-sdk-go'::text) AND (version = 'v1.34.8'::text
13. 0.000 0.000 ↓ 0.0

Index Scan using paths_path_module_id_key on paths p (cost=0.69..8.71 rows=1 width=202) (actual rows= loops=)

  • Index Cond: ((path = 'github.com/aws/aws-sdk-go'::text) AND (module_id = m.id))
14. 0.000 0.000 ↓ 0.0

Index Scan using documentation_pkey on documentation d (cost=0.56..8.58 rows=1 width=497) (actual rows= loops=)

  • Index Cond: (path_id = p.id)