explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pjdP

Settings
# exclusive inclusive rows x rows loops node
1. 330.697 519.994 ↓ 6.8 736,480 1

Nested Loop (cost=1,104.39..36,531.20 rows=108,540 width=228) (actual time=1.422..519.994 rows=736,480 loops=1)

  • Buffers: shared hit=73375
2. 0.000 32.795 ↓ 7.6 9,206 1

Gather (cost=1,096.25..35,090.48 rows=1,206 width=83) (actual time=1.348..32.795 rows=9,206 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Buffers: shared hit=73352
3. 132.112 134.999 ↓ 6.5 4,603 2

Nested Loop (cost=96.25..33,969.88 rows=709 width=83) (actual time=0.536..134.999 rows=4,603 loops=2)

  • Buffers: shared hit=73352
4. 2.148 2.807 ↑ 1.1 1,580 2

Parallel Bitmap Heap Scan on catalog_image_docker (cost=95.56..4,521.52 rows=1,788 width=105) (actual time=0.492..2.807 rows=1,580 loops=2)

  • Recheck Cond: (("userId")::text = 'tenant_1CjgdxSBB14nDMj5sEWWNeovSI0'::text)
  • Heap Blocks: exact=5
  • Buffers: shared hit=1975
5. 0.659 0.659 ↓ 1.0 3,159 1

Bitmap Index Scan on catalog_image_docker_hash_userid (cost=0.00..94.80 rows=3,040 width=0) (actual time=0.659..0.659 rows=3,159 loops=1)

  • Index Cond: (("userId")::text = 'tenant_1CjgdxSBB14nDMj5sEWWNeovSI0'::text)
  • Buffers: shared hit=9
6. 0.080 0.080 ↓ 3.0 3 3,159

Index Only Scan using image_package_vulnerabilities_pkey on image_package_vulnerabilities (cost=0.69..16.46 rows=1 width=108) (actual time=0.031..0.080 rows=3 loops=3,159)

  • Index Cond: ((pkg_user_id = 'tenant_1CjgdxSBB14nDMj5sEWWNeovSI0'::text) AND (pkg_image_id = (catalog_image_docker."imageId")::text) AND (vulnerability_id = 'CVE-2016-10739'::text))
  • Heap Fetches: 11
  • Buffers: shared hit=71377
7. 156.347 156.502 ↑ 1.1 80 9,206

Materialize (cost=8.15..84.19 rows=90 width=159) (actual time=0.000..0.017 rows=80 loops=9,206)

  • Buffers: shared hit=23
8. 0.044 0.155 ↑ 1.1 80 1

Nested Loop (cost=8.15..83.74 rows=90 width=159) (actual time=0.068..0.155 rows=80 loops=1)

  • Buffers: shared hit=23
9. 0.014 0.031 ↑ 1.2 8 1

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

  • Recheck Cond: ((vulnerability_id)::text = 'CVE-2016-10739'::text)
  • Heap Blocks: exact=8
  • Buffers: shared hit=11
10. 0.017 0.017 ↑ 1.2 8 1

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

  • Index Cond: ((vulnerability_id)::text = 'CVE-2016-10739'::text)
  • Buffers: shared hit=3
11. 0.026 0.080 ↓ 1.1 10 8

Materialize (cost=4.07..39.52 rows=9 width=76) (actual time=0.006..0.010 rows=10 loops=8)

  • Buffers: shared hit=12
12. 0.019 0.054 ↓ 1.1 10 1

Bitmap Heap Scan on feed_data_vulnerabilities (cost=4.07..39.48 rows=9 width=76) (actual time=0.041..0.054 rows=10 loops=1)

  • Recheck Cond: ((id)::text = 'CVE-2016-10739'::text)
  • Heap Blocks: exact=10
  • Buffers: shared hit=12
13. 0.035 0.035 ↓ 1.1 10 1

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

  • Index Cond: ((id)::text = 'CVE-2016-10739'::text)
  • Buffers: shared hit=2
Planning time : 1.435 ms
Execution time : 661.250 ms