explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3cq7

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 14.399 ↑ 1.0 1 1

Aggregate (cost=1,527.09..1,527.10 rows=1 width=8) (actual time=14.398..14.399 rows=1 loops=1)

  • Buffers: shared hit=240
2. 0.146 14.394 ↓ 0.0 0 1

Bitmap Heap Scan on public.projects (cost=1,385.74..1,527.09 rows=3 width=4) (actual time=14.394..14.394 rows=0 loops=1)

  • Filter: (projects.disable_overriding_approvers_per_merge_request AND (projects.created_at >= '2020-05-28 10:50:15.288686+00'::timestamp with time zone) AND (projects.created_at <= '2020-06-25 10:50:15.288758+00'::timestamp with time zone))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=240
3. 1.373 14.248 ↓ 0.0 0 1

BitmapAnd (cost=1,385.74..1,385.74 rows=91 width=0) (actual time=14.248..14.248 rows=0 loops=1)

  • Buffers: shared hit=237
4. 3.368 3.368 ↓ 1.0 21,330 1

Bitmap Index Scan using idx_projects_disable_overriding_approvers (cost=0.00..243.72 rows=20,838 width=0) (actual time=3.368..3.368 rows=21,330 loops=1)

  • Index Cond: (projects.disable_overriding_approvers_per_merge_request = true)
  • Buffers: shared hit=61
5. 9.507 9.507 ↑ 1.0 60,660 1

Bitmap Index Scan using projects_pkey (cost=0.00..1,141.76 rows=62,383 width=0) (actual time=9.507..9.507 rows=60,660 loops=1)

  • Index Cond: ((projects.id >= 0) AND (projects.id <= 99,999))
  • Buffers: shared hit=176