explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2Het

Settings
# exclusive inclusive rows x rows loops node
1. 0.298 355.766 ↑ 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=355.474..355.766 rows=1 loops=1)

  • Buffers: shared hit=26,257
2.          

Initplan (for Bitmap Heap Scan)

3. 0.028 0.028 ↑ 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=0.027..0.028 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=4
4. 4.017 355.440 ↓ 0.0 0 1

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

  • Buffers: shared hit=26,122
5. 0.103 0.103 ↑ 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=0.103..0.103 rows=153 loops=1)

  • Index Cond: (namespaces.traversal_ids <@ $0)
  • Buffers: shared hit=12
6. 351.320 351.320 ↓ 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=351.320..351.320 rows=3,020,698 loops=1)

  • Index Cond: ((namespaces.type)::text = 'Group'::text)
  • Buffers: shared hit=26,110