explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L1yP : Secret Detection

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

Aggregate (cost=7,150,629.41..7,150,629.42 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Scan using index_ci_builds_on_user_id on ci_builds (cost=0.57..7,150,629.35 rows=25 width=4) (actual rows= loops=)

  • Index Cond: ((user_id >= 0) AND (user_id <= 9999))
  • Filter: (((type)::text = 'Ci::Build'::text) AND ((name)::text = 'secret_detection'::text))