explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dGAi : Secret Detection

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

Result (cost=270,956.39..270,956.40 rows=1 width=4) (actual rows= loops=)

2.          

Initplan (for Result)

3. 0.000 0.000 ↓ 0.0

Limit (cost=0.57..270,956.39 rows=1 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan Backward using index_ci_builds_on_user_id on ci_builds (cost=0.57..831,563,396.81 rows=3,069 width=4) (actual rows= loops=)

  • Index Cond: (user_id IS NOT NULL)
  • Filter: (((type)::text = 'Ci::Build'::text) AND ((name)::text = 'secret_detection'::text))