explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fL7b : sast

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Result (cost=26.35..26.36 rows=1 width=4) (actual rows= loops=)

2.          

Initplan (for Result)

3. 0.000 0.000 ↓ 0.0

Limit (cost=0.43..26.35 rows=1 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using index_ci_builds_on_commit_id_and_artifacts_expireatandidpart2 on ci_builds (cost=0.43..4,851,274.75 rows=187,171 width=4) (actual rows= loops=)

  • Index Cond: (commit_id IS NOT NULL)
  • Filter: (((artifacts_expire_at IS NULL) OR (artifacts_expire_at > '2018-08-27 16:32:37.511623'::timestamp without time zone)) AND (created_at >= '2020-04-16 16:27:42.074504'::timestamp without time zone) AND (created_at <= '2020-05-14 16:27:42.074867'::timestamp without time zone) AND ((name)::text = ANY ('{sast,dependency_scanning,container_scanning,dast}'::text[])))