explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Jx

Settings
# exclusive inclusive rows x rows loops node
1. 304.144 33,444.791 ↑ 7,695.0 1 1

Bitmap Heap Scan on public.namespaces (cost=43,932.52..58,515.20 rows=7,695 width=347) (actual time=33,130.943..33,444.791 rows=1 loops=1)

  • Buffers: shared hit=33 read=26,227
  • I/O Timings: read=32,050.138
2.          

Initplan (for Bitmap Heap Scan)

3. 9.864 9.864 ↑ 1.0 1 1

Index Scan using namespaces_pkey on public.namespaces namespaces_1 (cost=0.43..3.45 rows=1 width=15) (actual time=9.861..9.864 rows=1 loops=1)

  • Index Cond: (namespaces_1.id = 9,970)
  • Filter: ((namespaces_1.type)::text = 'Group'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=1 read=3
  • I/O Timings: read=9.747
4. 2.712 33,130.783 ↓ 0.0 0 1

BitmapAnd (cost=43,929.07..43,929.07 rows=7,695 width=0) (actual time=33,130.783..33,130.783 rows=0 loops=1)

  • Buffers: shared hit=23 read=26,099
  • I/O Timings: read=31,742.036
5. 10.031 10.031 ↑ 254.8 153 1

Bitmap Index Scan using index_namespaces_on_traversal_ids (cost=0.00..322.33 rows=38,978 width=0) (actual time=10.031..10.031 rows=153 loops=1)

  • Index Cond: (namespaces.traversal_ids <@ $0)
  • Buffers: shared hit=9 read=3
  • I/O Timings: read=9.747
6. 33,118.040 33,118.040 ↓ 2.0 3,020,698 1

Bitmap Index Scan using index_namespaces_on_type_partial (cost=0.00..43,602.64 rows=1,539,028 width=0) (actual time=33,118.040..33,118.040 rows=3,020,698 loops=1)

  • Index Cond: ((namespaces.type)::text = 'Group'::text)
  • Buffers: shared hit=14 read=26,096
  • I/O Timings: read=31,732.290