explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8a1s

Settings
# exclusive inclusive rows x rows loops node
1. 0.071 60.280 ↑ 1.0 1 1

Limit (cost=63.46..63.52 rows=1 width=4) (actual time=60.279..60.280 rows=1 loops=1)

  • Buffers: shared hit=103 read=21 dirtied=14
  • I/O Timings: read=58.854
2. 60.209 60.209 ↑ 178.7 1,001 1

Index Only Scan using i1 on public.ci_job_artifacts (cost=0.42..11,275.38 rows=178,864 width=4) (actual time=0.105..60.209 rows=1,001 loops=1)

  • Index Cond: (ci_job_artifacts.job_id >= 121,896,538)
  • Heap Fetches: 19
  • Buffers: shared hit=103 read=21 dirtied=14
  • I/O Timings: read=58.854