explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bLaC

Settings
# exclusive inclusive rows x rows loops node
1. 1.395 1.395 ↑ 1.9 380 1

Index Scan using ci_job_artifacts_pkey on ci_job_artifacts (cost=0.43..49.90 rows=736 width=4) (actual time=0.010..1.395 rows=380 loops=1)

  • Index Cond: ((id >= 1) AND (id <= 1,000))
  • Filter: ((expire_at IS NULL) OR (expire_at > '2020-06-22 23:18:12.809445+00'::timestamp with time zone))
  • Buffers: shared hit=144
Planning time : 7.501 ms
Execution time : 1.450 ms