explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XJh8 : Secret Detection

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

Result (cost=263.26..263.27 rows=1 width=4) (actual rows= loops=)

2.          

Initplan (for Result)

3. 0.000 0.000 ↓ 0.0

Limit (cost=0.57..263.26 rows=1 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using index_ci_builds_on_commit_id_and_stage_idx_and_created_at on ci_builds (cost=0.57..49,196,516.64 rows=187,281 width=4) (actual rows= loops=)

  • Index Cond: ((commit_id IS NOT NULL) 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))
  • Filter: (((NOT retried) OR (retried IS NULL)) AND ((artifacts_expire_at IS NULL) OR (artifacts_expire_at > '2018-08-27 16:32:37.511623'::timestamp without time zone)) AND ((type)::text = 'Ci::Build'::text) AND ((name)::text = ANY ('{sast,dependency_scanning,container_scanning,dast,secret_detection}'::text[])))