explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yrh6

Settings
# exclusive inclusive rows x rows loops node
1. 6.328 1,592.969 ↑ 1.7 803 1

Sort (cost=1,468.71..1,472.06 rows=1,342 width=1,534) (actual time=1,592.901..1,592.969 rows=803 loops=1)

  • Sort Key: ci_builds.stage_idx, ci_builds.stage
  • Sort Method: quicksort Memory: 1,157kB
  • Buffers: shared hit=66 read=682 dirtied=16
  • I/O Timings: read=1,569.921
2. 1,586.641 1,586.641 ↑ 1.7 803 1

Index Scan using index_ci_builds_on_commit_id_and_stage_idx_and_created_at on public.ci_builds (cost=0.57..1,398.99 rows=1,342 width=1,534) (actual time=14.884..1,586.641 rows=803 loops=1)

  • Index Cond: (ci_builds.commit_id = ANY ('{187160677,186900369,186896610,186857588,185854902,185851760,185817295,185816206,185755031,185352594}'::integer[]))
  • Filter: ((NOT ci_builds.retried) OR (ci_builds.retried IS NULL))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=60 read=682 dirtied=16
  • I/O Timings: read=1,569.921