explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PoW6

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 353.418 ↑ 1.0 1 1

Aggregate (cost=1,526.90..1,526.91 rows=1 width=8) (actual time=353.417..353.418 rows=1 loops=1)

  • Buffers: shared hit=18 read=222
  • I/O Timings: read=324.977
2. 0.265 353.409 ↑ 30.3 3 1

Bitmap Heap Scan on public.projects (cost=1,385.78..1,526.67 rows=91 width=4) (actual time=353.399..353.409 rows=3 loops=1)

  • Filter: projects.disable_overriding_approvers_per_merge_request
  • Rows Removed by Filter: 0
  • Buffers: shared hit=18 read=222
  • I/O Timings: read=324.977
3. 1.610 353.144 ↓ 0.0 0 1

BitmapAnd (cost=1,385.78..1,385.78 rows=91 width=0) (actual time=353.143..353.144 rows=0 loops=1)

  • Buffers: shared hit=15 read=222
  • I/O Timings: read=324.977
4. 26.978 26.978 ↓ 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=26.978..26.978 rows=21,330 loops=1)

  • Index Cond: (projects.disable_overriding_approvers_per_merge_request = true)
  • Buffers: shared read=61
  • I/O Timings: read=21.359
5. 324.556 324.556 ↑ 1.0 60,660 1

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

  • Index Cond: ((projects.id >= 0) AND (projects.id <= 99,999))
  • Buffers: shared hit=15 read=161
  • I/O Timings: read=303.618