explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l1QGd

Settings
# exclusive inclusive rows x rows loops node
1. 0.063 1,944.764 ↑ 1.0 1 1

Aggregate (cost=2,178.44..2,178.45 rows=1 width=8) (actual time=1,944.764..1,944.764 rows=1 loops=1)

  • Buffers: shared hit=173 read=2813 dirtied=1
  • I/O Timings: read=1905.531
2. 1,759.420 1,944.701 ↑ 1.3 12 1

Bitmap Heap Scan on public.services (cost=1,928.63..2,178.40 rows=16 width=4) (actual time=233.703..1,944.701 rows=12 loops=1)

  • Filter: (services.active AND (NOT services.template))
  • Rows Removed by Filter: 6205
  • Buffers: shared hit=173 read=2813 dirtied=1
  • I/O Timings: read=1905.531
3. 0.561 185.281 ↓ 0.0 0 1

BitmapAnd (cost=1,928.63..1,928.63 rows=121 width=0) (actual time=185.280..185.281 rows=0 loops=1)

  • Buffers: shared hit=26 read=276
  • I/O Timings: read=175.015
4. 70.690 70.690 ↑ 1.4 8,052 1

Bitmap Index Scan using index_services_on_type (cost=0.00..376.24 rows=11,158 width=0) (actual time=70.690..70.690 rows=8,052 loops=1)

  • Index Cond: ((services.type)::text = 'AssemblaService'::text)
  • Buffers: shared read=73
  • I/O Timings: read=68.346
5. 114.030 114.030 ↑ 1.4 39,545 1

Bitmap Index Scan using services_pkey (cost=0.00..1,552.13 rows=55,757 width=0) (actual time=114.030..114.030 rows=39,545 loops=1)

  • Index Cond: ((services.id >= 0) AND (services.id <= 99999))
  • Buffers: shared hit=26 read=203
  • I/O Timings: read=106.669