explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jBBdx : Secret Detection

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

Aggregate (cost=435,790.72..435,790.73 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Scan using index_ci_builds_on_user_id_and_created_at_and_type_eq_ci_build on ci_builds (cost=0.57..435,790.71 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((user_id >= 0) AND (user_id <= 9999) AND (created_at >= '2020-04-21 21:40:24.288642'::timestamp without time zone) AND (created_at <= '2020-05-19 21:40:24.288763'::timestamp without time zone))
  • Filter: ((name)::text = 'secret_detection'::text)