explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w3GO

Settings
# exclusive inclusive rows x rows loops node
1. 0.053 0.754 ↓ 0.0 0 1

Sort (cost=99.66..99.67 rows=1 width=3,845) (actual time=0.754..0.754 rows=0 loops=1)

  • Sort Key: package_package.name, ((package_package.version_parsed_id IS NOT NULL)) DESC, ((package_version.parsed_type <> 0)) DESC, package_version.epoch DESC, (COALESCE(package_version.major, '0'::bigint)) DESC, (COALESCE(package_version.minor, '0'::bigint)) DESC, (COALESCE(package_version.patch, '0'::bigint)) DESC, (COALESCE(package_version.revision, '0'::bigint)) DESC, (COALESCE(package_version.revision_2, '0'::bigint)) DESC, (COALESCE(package_version.revision_3, '0'::bigint)) DESC, package_version.prerelease, (COALESCE(package_version.prerelease_str)) DESC, (COALESCE(package_version.prerelease_num, '0'::bigint)) DESC, package_version.postrelease_num DESC, ((package_version.devrelease_num IS NOT NULL)), package_version.devrelease_num DESC, package_version.prerelease_tag DESC, package_version.raw DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.000 0.701 ↓ 0.0 0 1

Nested Loop Left Join (cost=56.98..99.65 rows=1 width=3,845) (actual time=0.701..0.701 rows=0 loops=1)

3. 0.001 0.701 ↓ 0.0 0 1

Nested Loop Left Join (cost=56.70..99.33 rows=1 width=3,681) (actual time=0.701..0.701 rows=0 loops=1)

4. 0.000 0.700 ↓ 0.0 0 1

Nested Loop Left Join (cost=56.42..97.89 rows=1 width=3,386) (actual time=0.700..0.700 rows=0 loops=1)

5. 0.000 0.700 ↓ 0.0 0 1

Nested Loop Left Join (cost=56.28..97.72 rows=1 width=3,327) (actual time=0.700..0.700 rows=0 loops=1)

6. 0.000 0.700 ↓ 0.0 0 1

Nested Loop Left Join (cost=56.14..97.50 rows=1 width=3,301) (actual time=0.700..0.700 rows=0 loops=1)

7. 0.000 0.700 ↓ 0.0 0 1

Nested Loop (cost=55.71..95.07 rows=1 width=3,165) (actual time=0.700..0.700 rows=0 loops=1)

8. 0.000 0.700 ↓ 0.0 0 1

Nested Loop (cost=55.43..92.76 rows=1 width=3,074) (actual time=0.700..0.700 rows=0 loops=1)

9. 0.025 0.700 ↓ 0.0 0 1

Hash Join (cost=55.15..90.46 rows=1 width=2,323) (actual time=0.699..0.700 rows=0 loops=1)

  • Hash Cond: (package_helm_package.package_ptr_id = package_package.id)
10. 0.667 0.667 ↑ 2,004.0 1 1

Seq Scan on package_helm_package (cost=0.00..30.04 rows=2,004 width=4) (actual time=0.667..0.667 rows=1 loops=1)

11. 0.000 0.008 ↓ 0.0 0 1

Hash (cost=54.22..54.22 rows=75 width=2,319) (actual time=0.008..0.008 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
12. 0.008 0.008 ↓ 0.0 0 1

Index Scan using package_package_repository_id_ba6561dd on package_package (cost=0.42..54.22 rows=75 width=2,319) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (repository_id = 1)
  • Filter: (status = 4)
13. 0.000 0.000 ↓ 0.0 0

Index Scan using package_repository_namespace_id_4968dc6f on package_repository (cost=0.28..2.30 rows=1 width=751) (never executed)

  • Index Cond: (namespace_id = 4)
  • Filter: (id = 1)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using namespaces_pkey on namespaces (cost=0.28..2.30 rows=1 width=91) (never executed)

  • Index Cond: (id = 4)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using package_version_pkey on package_version (cost=0.42..2.43 rows=1 width=140) (never executed)

  • Index Cond: (package_package.version_parsed_id = id)
16. 0.000 0.000 ↓ 0.0 0

Index Scan using package_distribution_version_id_e607315c_uniq on package_distribution_version (cost=0.14..0.22 rows=1 width=26) (never executed)

  • Index Cond: (package_package.distro_version_id = id)
17. 0.000 0.000 ↓ 0.0 0

Index Scan using package_distribution_id_646b6363_uniq on package_distribution (cost=0.14..0.17 rows=1 width=59) (never executed)

  • Index Cond: (package_distribution_version.distribution_id = id)
18. 0.000 0.000 ↓ 0.0 0

Index Scan using auth_user_pkey on auth_user (cost=0.28..1.44 rows=1 width=295) (never executed)

  • Index Cond: (package_package.uploader_id = id)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using namespaces_pkey on namespaces t9 (cost=0.28..0.32 rows=1 width=91) (never executed)

  • Index Cond: (auth_user.namespace_id = id)