explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BZXc

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

Aggregate (cost=196,936.35..196,936.36 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ci_builds (cost=141,163.21..196,848.20 rows=35,259 width=4) (actual rows= loops=)

  • Recheck Cond: (((name)::text = ANY ('{container_scanning,dast,dependency_scanning,license_management,sast,secret_detection,license_scanning}'::text[])) AND ((type)::text = 'Ci::Build'::text) AND (user_id >= 0) AND (user_id <= 9,999))
3. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=141,163.21..141,163.21 rows=35,259 width=0) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on index_security_ci_builds_on_name_and_id (cost=0.00..64,885.05 rows=4,685,823 width=0) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on index_ci_builds_on_user_id (cost=0.00..76,260.28 rows=4,340,071 width=0) (actual rows= loops=)

  • Index Cond: ((user_id >= 0) AND (user_id <= 9,999))