explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IBKR : Secret Detection

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

Result (cost=362,945.41..362,945.42 rows=1 width=4) (actual rows= loops=)

2.          

Initplan (for Result)

3. 0.000 0.000 ↓ 0.0

Limit (cost=0.57..362,945.41 rows=1 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan Backward using index_ci_builds_on_user_id_and_created_at_and_type_eq_ci_build on ci_builds (cost=0.57..49,723,442.94 rows=137 width=4) (actual rows= loops=)

  • Index Cond: ((user_id IS NOT NULL) 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)