explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CrOW

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 238.541 ↑ 1.0 1 1

Aggregate (cost=12,508.50..12,508.51 rows=1 width=8) (actual time=238.540..238.541 rows=1 loops=1)

  • Buffers: shared hit=177 read=1,715
  • I/O Timings: read=30.009
2. 0.458 238.535 ↓ 0.0 0 1

Bitmap Heap Scan on public.projects (cost=9,249.60..12,503.63 rows=1,950 width=4) (actual time=238.535..238.535 rows=0 loops=1)

  • Filter: ((NOT projects.disable_overriding_approvers_per_merge_request) OR (projects.disable_overriding_approvers_per_merge_request IS NULL))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=177 read=1,715
  • I/O Timings: read=30.009
3. 8.492 238.077 ↓ 0.0 0 1

BitmapAnd (cost=9,249.60..9,249.60 rows=1,947 width=0) (actual time=238.077..238.077 rows=0 loops=1)

  • Buffers: shared hit=177 read=1,715
  • I/O Timings: read=30.009
4. 10.796 10.796 ↑ 1.0 60,660 1

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

  • Index Cond: ((projects.id >= 0) AND (projects.id <= 99,999))
  • Buffers: shared hit=176
5. 0.004 218.789 ↓ 0.0 0 1

BitmapOr (cost=8,107.10..8,107.10 rows=443,439 width=0) (actual time=218.789..218.789 rows=0 loops=1)

  • Buffers: shared hit=1 read=1,715
  • I/O Timings: read=30.009
6. 0.709 0.709 ↑ 2.4 1,068 1

Bitmap Index Scan using idx_projects_disable_overriding_approvers_and_create_at (cost=0.00..47.26 rows=2,536 width=0) (actual time=0.708..0.709 rows=1,068 loops=1)

  • Index Cond: ((projects.disable_overriding_approvers_per_merge_request = false) AND (projects.created_at >= '2020-05-28 10:49:45.958485+00'::timestamp with time zone) AND (projects.created_at <= '2020-06-25 10:49:45.95858+00'::timestamp with time zone))
  • Buffers: shared read=8
  • I/O Timings: read=0.383
7. 218.076 218.076 ↓ 1.0 444,609 1

Bitmap Index Scan using idx_projects_disable_overriding_approvers_and_create_at (cost=0.00..8,058.86 rows=440,904 width=0) (actual time=218.076..218.076 rows=444,609 loops=1)

  • Index Cond: ((projects.disable_overriding_approvers_per_merge_request IS NULL) AND (projects.created_at >= '2020-05-28 10:49:45.958485+00'::timestamp with time zone) AND (projects.created_at <= '2020-06-25 10:49:45.95858+00'::timestamp with time zone))
  • Buffers: shared hit=1 read=1,707
  • I/O Timings: read=29.627