explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AU1p

Settings
# exclusive inclusive rows x rows loops node
1. 135.526 592.887 ↓ 0.0 0 1

Nested Loop Semi Join (cost=16,218.61..32,968.82 rows=1 width=4) (actual time=592.887..592.887 rows=0 loops=1)

  • Buffers: shared hit=112,176
2. 128.875 457.361 ↓ 4,461.6 249,851 1

Index Only Scan using i6 on public.ci_job_artifacts (cost=16,218.19..32,855.46 rows=56 width=8) (actual time=329.793..457.361 rows=249,851 loops=1)

  • Heap Fetches: 23,946
  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 1,000
  • Buffers: shared hit=112,176
3.          

SubPlan (for Index Only Scan)

4. 1.055 328.486 ↓ 1,000.0 1,000 1

Aggregate (cost=0.84..16,217.77 rows=1 width=8) (actual time=0.040..328.486 rows=1,000 loops=1)

  • Group Key: ci_job_artifacts_2.job_id
  • Buffers: shared hit=57,649
5. 197.354 327.431 ↓ 1,000.0 1,000 1

Nested Loop Semi Join (cost=0.84..16,217.75 rows=1 width=8) (actual time=0.030..327.431 rows=1,000 loops=1)

  • Buffers: shared hit=57,649
6. 130.077 130.077 ↓ 2,219.9 250,851 1

Index Only Scan using i6 on public.ci_job_artifacts ci_job_artifacts_2 (cost=0.42..15,998.24 rows=113 width=8) (actual time=0.020..130.077 rows=250,851 loops=1)

  • Heap Fetches: 23,946
  • Buffers: shared hit=54,527
7. 0.000 0.000 ↓ 0.0 0 250,851

Index Only Scan using i6 on public.ci_job_artifacts ci_job_artifacts_3 (cost=0.42..1.93 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=250,851)

  • Index Cond: ((ci_job_artifacts_3.job_id = ci_job_artifacts_2.job_id) AND (ci_job_artifacts_3.job_id >= 121,896,538) AND (ci_job_artifacts_3.job_id < 156158378))
  • Heap Fetches: 20
  • Buffers: shared hit=3,122
8. 0.000 0.000 ↓ 0.0 0 249,851

Index Only Scan using i6 on public.ci_job_artifacts ci_job_artifacts_1 (cost=0.42..2.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=249,851)

  • Index Cond: ((ci_job_artifacts_1.job_id = ci_job_artifacts.job_id) AND (ci_job_artifacts_1.job_id >= 121,896,538) AND (ci_job_artifacts_1.job_id < 156158378))
  • Heap Fetches: 0