explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ntdV : Secret Detection

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

Result (cost=185.45..185.46 rows=1 width=4) (actual rows= loops=)

2.          

Initplan (for Result)

3. 0.000 0.000 ↓ 0.0

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

4. 0.000 0.000 ↓ 0.0

Index Scan using index_ci_builds_on_commit_id_and_status_and_type on ci_builds (cost=0.57..615,053,307.17 rows=3,326,737 width=4) (actual rows= loops=)

  • Index Cond: ((commit_id IS NOT NULL) AND ((type)::text = 'Ci::Build'::text))
  • 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 ((name)::text = ANY ('{sast,dependency_scanning,container_scanning,dast,secret_detection}'::text[])))