explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GnCD

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 199.959 ↑ 1.0 1 1

Bitmap Heap Scan on projects p (cost=16,688.40..17,041.03 rows=1 width=2,005) (actual time=199.956..199.959 rows=1 loops=1)

  • Recheck Cond: (((organization_uuid)::text = 'AW_VMe2gAKpOjU20DGH_'::text) AND ((qualifier)::text = 'TRK'::text))
  • Filter: ((main_branch_project_uuid IS NULL) AND ((scope)::text = 'PRJ'::text))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=2
2. 3.298 199.938 ↓ 0.0 0 1

BitmapAnd (cost=16,688.40..16,688.40 rows=88 width=0) (actual time=199.938..199.938 rows=0 loops=1)

3. 0.026 0.026 ↑ 231.9 43 1

Bitmap Index Scan on projects_organization (cost=0.00..275.34 rows=9,970 width=0) (actual time=0.026..0.026 rows=43 loops=1)

  • Index Cond: ((organization_uuid)::text = 'AW_VMe2gAKpOjU20DGH_'::text)
4. 196.614 196.614 ↓ 1.1 948,923 1

Bitmap Index Scan on projects_qualifier (cost=0.00..16,412.81 rows=888,565 width=0) (actual time=196.614..196.614 rows=948,923 loops=1)

  • Index Cond: ((qualifier)::text = 'TRK'::text)
Planning time : 0.143 ms
Execution time : 199.995 ms