explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W7H7

Settings
# exclusive inclusive rows x rows loops node
1. 0.458 284,603.541 ↓ 0.0 0 1

ModifyTable on public.ci_job_artifacts (cost=23,912.50..235,080.11 rows=138,518 width=6) (actual time=284,603.541..284,603.541 rows=0 loops=1)

  • Buffers: shared hit=156,019 read=194,803 dirtied=67,948
  • I/O Timings: read=277,372.725
2. 210,468.354 284,603.083 ↑ 13,851.8 10 1

Index Scan using lm_artifacts on public.ci_job_artifacts (cost=23,912.50..235,080.11 rows=138,518 width=6) (actual time=150,976.716..284,603.083 rows=10 loops=1)

  • Filter: ((ci_job_artifacts.file_type = ANY ('{10,101}'::integer[])) AND (NOT (hashed SubPlan 1)))
  • Rows Removed by Filter: 238,863
  • Buffers: shared hit=156,002 read=194,803 dirtied=67,938
  • I/O Timings: read=277,372.725
3.          

SubPlan (for Index Scan)

4. 539.415 74,134.729 ↑ 1.2 238,863 1

Aggregate (cost=0.42..23,220.72 rows=276,544 width=8) (actual time=0.250..74,134.729 rows=238,863 loops=1)

  • Group Key: ci_job_artifacts_1.job_id
  • Buffers: shared hit=68,983 read=43,224 dirtied=67,377
  • I/O Timings: read=70,886.897
5. 73,595.314 73,595.314 ↑ 1.2 238,873 1

Index Only Scan using lm_artifacts on public.ci_job_artifacts ci_job_artifacts_1 (cost=0.42..19,070.10 rows=277,035 width=8) (actual time=0.236..73,595.314 rows=238,873 loops=1)

  • Heap Fetches: 82,756
  • Buffers: shared hit=68,983 read=43,224 dirtied=67,377
  • I/O Timings: read=70,886.897