explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HoKr

Settings
# exclusive inclusive rows x rows loops node
1. 2,982.843 38,743.888 ↑ 103.0 23,535 1

Unique (cost=1,022,834.81..1,053,127.69 rows=2,423,430 width=228) (actual time=29,570.256..38,743.888 rows=23,535 loops=1)

  • Output: catalog_image_docker.repo, catalog_image_docker.tag, image_package_vulnerabilities.pkg_name, image_package_vulnerabilities.pkg_version, feed_data_vulnerabilities.id, feed_data_vulnerabilities.link, feed_data_vulnerabilities.severity, feed_data_vulnerabilities_f
2. 30,384.918 35,761.045 ↓ 3.3 7,937,412 1

Sort (cost=1,022,834.81..1,028,893.39 rows=2,423,430 width=228) (actual time=29,570.254..35,761.045 rows=7,937,412 loops=1)

  • Output: catalog_image_docker.repo, catalog_image_docker.tag, image_package_vulnerabilities.pkg_name, image_package_vulnerabilities.pkg_version, feed_data_vulnerabilities.id, feed_data_vulnerabilities.link, feed_data_vulnerabilities.severity, feed_data_vulnerabil$
  • Sort Key: catalog_image_docker.repo, catalog_image_docker.tag, image_package_vulnerabilities.pkg_name, image_package_vulnerabilities.pkg_version
  • Sort Method: external merge Disk: 1323544kB
3. 3,506.103 5,376.127 ↓ 3.3 7,937,412 1

Nested Loop (cost=204,873.12..235,715.79 rows=2,423,430 width=228) (actual time=226.799..5,376.127 rows=7,937,412 loops=1)

  • Output: catalog_image_docker.repo, catalog_image_docker.tag, image_package_vulnerabilities.pkg_name, image_package_vulnerabilities.pkg_version, feed_data_vulnerabilities.id, feed_data_vulnerabilities.link, feed_data_vulnerabilities.severity, feed_data_vuln$
4. 32.427 277.142 ↓ 1.0 26,998 1

Merge Join (cost=204,864.97..205,338.95 rows=26,927 width=83) (actual time=226.755..277.142 rows=26,998 loops=1)

  • Output: catalog_image_docker.repo, catalog_image_docker.tag, image_package_vulnerabilities.pkg_name, image_package_vulnerabilities.pkg_version, image_package_vulnerabilities.vulnerability_id
  • Merge Cond: ((catalog_image_docker."imageId")::text = (image_package_vulnerabilities.pkg_image_id)::text)
5. 44.683 56.105 ↑ 1.0 13,569 1

Sort (cost=6,322.26..6,357.30 rows=14,017 width=105) (actual time=50.159..56.105 rows=13,569 loops=1)

  • Output: catalog_image_docker.repo, catalog_image_docker.tag, catalog_image_docker."imageId
  • Sort Key: catalog_image_docker."imageId
  • Sort Method: quicksort Memory: 3730kB
6. 10.401 11.422 ↑ 1.0 13,569 1

Bitmap Heap Scan on public.catalog_image_docker (cost=428.63..5,356.84 rows=14,017 width=105) (actual time=1.337..11.422 rows=13,569 loops=1)

  • Output: catalog_image_docker.repo, catalog_image_docker.tag, catalog_image_docker."imageId
  • Recheck Cond: ((catalog_image_docker."userId")::text = 'tenant_1Apxl6Etq83ZT28DOrvTD5Ma45x'::text)
  • Heap Blocks: exact=2753
7. 1.021 1.021 ↑ 1.0 13,569 1

Bitmap Index Scan on catalog_image_docker_hash_userid (cost=0.00..425.13 rows=14,017 width=0) (actual time=1.021..1.021 rows=13,569 loops=1)

  • Index Cond: ((catalog_image_docker."userId")::text = 'tenant_1Apxl6Etq83ZT28DOrvTD5Ma45x'::text)
8. 145.443 188.610 ↓ 1.1 26,998 1

Sort (cost=198,542.71..198,603.32 rows=24,245 width=108) (actual time=176.587..188.610 rows=26,998 loops=1)

  • Output: image_package_vulnerabilities.pkg_name, image_package_vulnerabilities.pkg_version, image_package_vulnerabilities.pkg_image_id, image_package_vulnerabilities.vulnerability_id
  • Sort Key: image_package_vulnerabilities.pkg_image_id
  • Sort Method: external sort Disk: 3000kB
9. 37.641 43.167 ↓ 1.1 26,978 1

Bitmap Heap Scan on public.image_package_vulnerabilities (cost=2,170.38..196,777.02 rows=24,245 width=108) (actual time=8.214..43.167 rows=26,978 loops=1)

  • Output: image_package_vulnerabilities.pkg_name, image_package_vulnerabilities.pkg_version, image_package_vulnerabilities.pkg_image_id, image_package_vulnerabilities.vulnerability_id
  • Recheck Cond: ((image_package_vulnerabilities.vulnerability_id)::text = 'CVE-2019-12900'::text)
  • Filter: ((image_package_vulnerabilities.pkg_user_id)::text = 'tenant_1Apxl6Etq83ZT28DOrvTD5Ma45x'::text)
  • Rows Removed by Filter: 34177
  • Heap Blocks: exact=17780
10. 5.526 5.526 ↑ 1.1 61,155 1

Bitmap Index Scan on cve_idx_img_hash (cost=0.00..2,164.32 rows=67,243 width=0) (actual time=5.526..5.526 rows=61,155 loops=1)

  • Index Cond: ((image_package_vulnerabilities.vulnerability_id)::text = 'CVE-2019-12900'::text)
11. 1,592.600 1,592.882 ↓ 3.3 294 26,998

Materialize (cost=8.15..84.19 rows=90 width=159) (actual time=0.000..0.059 rows=294 loops=26,998)

  • Output: feed_data_vulnerabilities.id, feed_data_vulnerabilities.link, feed_data_vulnerabilities.severity, feed_data_vulnerabilities_fixed_artifacts.fix_metadata
12. 0.133 0.282 ↓ 3.3 294 1

Nested Loop (cost=8.15..83.74 rows=90 width=159) (actual time=0.039..0.282 rows=294 loops=1)

  • Output: feed_data_vulnerabilities.id, feed_data_vulnerabilities.link, feed_data_vulnerabilities.severity, feed_data_vulnerabilities_fixed_artifacts.fix_metadata
13. 0.029 0.044 ↓ 2.1 21 1

Bitmap Heap Scan on public.feed_data_vulnerabilities_fixed_artifacts (cost=4.08..43.12 rows=10 width=97) (actual time=0.022..0.044 rows=21 loops=1)

  • Output: feed_data_vulnerabilities_fixed_artifacts.vulnerability_id, feed_data_vulnerabilities_fixed_artifacts.namespace_name, feed_data_vulnerabilities_fixed_artifacts.name, feed_data_vulnerabilities_fixed_artifacts.version, feed_data_vul$
  • Recheck Cond: ((feed_data_vulnerabilities_fixed_artifacts.vulnerability_id)::text = 'CVE-2019-12900'::text)
  • Heap Blocks: exact=15
14. 0.015 0.015 ↓ 2.1 21 1

Bitmap Index Scan on cve_idx_fix_hash (cost=0.00..4.08 rows=10 width=0) (actual time=0.015..0.015 rows=21 loops=1)

  • Index Cond: ((feed_data_vulnerabilities_fixed_artifacts.vulnerability_id)::text = 'CVE-2019-12900'::text)
15. 0.073 0.105 ↓ 1.6 14 21

Materialize (cost=4.07..39.52 rows=9 width=76) (actual time=0.001..0.005 rows=14 loops=21)

  • Output: feed_data_vulnerabilities.id, feed_data_vulnerabilities.link, feed_data_vulnerabilities.severity
16. 0.024 0.032 ↓ 1.6 14 1

Bitmap Heap Scan on public.feed_data_vulnerabilities (cost=4.07..39.48 rows=9 width=76) (actual time=0.013..0.032 rows=14 loops=1)

  • Output: feed_data_vulnerabilities.id, feed_data_vulnerabilities.link, feed_data_vulnerabilities.severity
  • Recheck Cond: ((feed_data_vulnerabilities.id)::text = 'CVE-2019-12900'::text)
  • Heap Blocks: exact=14
17. 0.008 0.008 ↓ 1.6 14 1

Bitmap Index Scan on cve_idx_hash (cost=0.00..4.07 rows=9 width=0) (actual time=0.007..0.008 rows=14 loops=1)

  • Index Cond: ((feed_data_vulnerabilities.id)::text = 'CVE-2019-12900'::text)
Planning time : 1.591 ms
Execution time : 40,719.290 ms