explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T83b

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

Bitmap Heap Scan on ci_job_artifacts (cost=11,986.51..1,834,166.03 rows=855,289 width=131) (actual rows= loops=)

  • Recheck Cond: ((file_store = 1) OR (file_store IS NULL))
2. 0.000 0.000 ↓ 0.0

BitmapOr (cost=11,986.51..11,986.51 rows=855,289 width=0) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on index_ci_job_artifacts_on_file_store (cost=0.00..11,557.24 rows=855,289 width=0) (actual rows= loops=)

  • Index Cond: (file_store = 1)
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on index_ci_job_artifacts_file_store_is_null (cost=0.00..1.63 rows=1 width=0) (actual rows= loops=)