explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uKjs

Settings
# exclusive inclusive rows x rows loops node
1. 0.502 0.628 ↑ 38,978.0 1 1

Bitmap Heap Scan on public.namespaces (cost=335.53..88,025.69 rows=38,978 width=347) (actual time=0.126..0.628 rows=1 loops=1)

  • Buffers: shared hit=147
2.          

Initplan (for Bitmap Heap Scan)

3. 0.029 0.029 ↑ 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.028..0.029 rows=1 loops=1)

  • Index Cond: (namespaces_1.id = 9,970)
  • Buffers: shared hit=4
4. 0.097 0.097 ↑ 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.097..0.097 rows=153 loops=1)

  • Index Cond: (namespaces.traversal_ids <@ $0)
  • Buffers: shared hit=12