explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3eTD

Settings
# exclusive inclusive rows x rows loops node
1. 1.070 32,158.137 ↓ 1,000.0 10,000 1

Limit (cost=1,055.95..9,265.17 rows=10 width=162) (actual time=1,707.396..32,158.137 rows=10,000 loops=1)

2. 287.193 32,157.067 ↓ 1,000.0 10,000 1

Gather (cost=1,055.95..9,265.17 rows=10 width=162) (actual time=1,707.394..32,157.067 rows=10,000 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 5.331 31,869.874 ↓ 835.3 5,012 2 / 2

Nested Loop (cost=55.95..8,264.17 rows=6 width=162) (actual time=1,635.463..31,869.874 rows=5,012 loops=2)

4. 1.566 31,794.382 ↓ 835.3 5,012 2 / 2

Nested Loop (cost=55.67..8,261.99 rows=6 width=118) (actual time=1,635.397..31,794.382 rows=5,012 loops=2)

5. 5.484 31,753.453 ↓ 36.9 6,560 2 / 2

Nested Loop (cost=55.38..8,181.90 rows=178 width=131) (actual time=1,628.718..31,753.453 rows=6,560 loops=2)

6. 12.137 31,684.141 ↓ 39.0 3,546 2 / 2

Nested Loop (cost=55.09..8,118.44 rows=91 width=92) (actual time=398.843..31,684.141 rows=3,546 loops=2)

7. 15.209 31,590.446 ↓ 15.3 3,546 2 / 2

Nested Loop (cost=54.81..8,048.06 rows=232 width=124) (actual time=398.762..31,590.446 rows=3,546 loops=2)

8. 18.478 22.486 ↓ 10.9 6,491 2 / 2

Hash Join (cost=54.25..4,319.54 rows=594 width=74) (actual time=1.106..22.486 rows=6,491 loops=2)

  • Hash Cond: (((dp.dist_ga)::text = (ddm.dist_ga)::text) AND ((dp.dist_version)::text = (ddm.dist_version)::text))
9. 3.084 3.084 ↑ 5.2 9,718 2 / 2

Parallel Seq Scan on distribution_package dp (cost=0.00..1,865.06 rows=50,406 width=95) (actual time=0.039..3.084 rows=9,718 loops=2)

10. 0.583 0.924 ↓ 1.0 1,337 2 / 2

Hash (cost=34.30..34.30 rows=1,330 width=86) (actual time=0.924..0.924 rows=1,337 loops=2)

  • Buckets: 2,048 Batches: 1 Memory Usage: 171kB
11. 0.341 0.341 ↓ 1.0 1,337 2 / 2

Seq Scan on dist_deployment_map ddm (cost=0.00..34.30 rows=1,330 width=86) (actual time=0.018..0.341 rows=1,337 loops=2)

12. 31,552.751 31,552.751 ↑ 1.0 1 12,982 / 2

Index Scan using nexus_artifact_unq on nexus_artifact na (cost=0.56..6.27 rows=1 width=58) (actual time=2.508..4.861 rows=1 loops=12,982)

  • Index Cond: (((ga)::text = (dp.lib_ga)::text) AND ((version)::text = (dp.lib_version)::text))
  • Filter: ((NOT snapshot) AND from_sources)
  • Rows Removed by Filter: 484
13. 81.558 81.558 ↑ 1.0 1 7,092 / 2

Index Scan using artifact_namespace_code_key on artifact_namespace an (cost=0.29..0.30 rows=1 width=46) (actual time=0.023..0.023 rows=1 loops=7,092)

  • Index Cond: ((code)::text = (na.ga)::text)
14. 63.828 63.828 ↑ 4.0 2 7,092 / 2

Index Scan using api_qname_artifact_id_index on api_qname aq (cost=0.29..0.62 rows=8 width=47) (actual time=0.008..0.018 rows=2 loops=7,092)

  • Index Cond: (artifact_id = an.id)
15. 39.363 39.363 ↑ 1.0 1 13,121 / 2

Index Only Scan using api_version_unq on api_version av (cost=0.29..0.45 rows=1 width=13) (actual time=0.006..0.006 rows=1 loops=13,121)

  • Index Cond: ((api_id = aq.id) AND (major_version = na.major_version) AND (minor_version = na.minor_version) AND (snapshot = na.snapshot))
  • Heap Fetches: 10,023
16. 70.161 70.161 ↑ 1.0 1 10,023 / 2

Index Scan using deployment_env_pkey on deployment_env de (cost=0.28..0.36 rows=1 width=34) (actual time=0.014..0.014 rows=1 loops=10,023)

  • Index Cond: ((code)::text = (ddm.deployment_env_code)::text)
Planning time : 12.531 ms
Execution time : 32,159.036 ms