explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AIHL

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.012 ↓ 30.0 30 1

Bitmap Heap Scan on public.wallets (cost=4.16..9.50 rows=1 width=164) (actual time=0.008..0.012 rows=30 loops=1)

  • Output: id, canonical_id, client_id, wallet_type, base_currency, created_at, updated_at, deleted_at
  • Recheck Cond: (wallets.deleted_at IS NULL)
  • Filter: ((wallets.base_currency)::text = 'USD'::text)
  • Heap Blocks: exact=1
  • Buffers: shared hit=2
2. 0.003 0.003 ↓ 16.0 32 1

Bitmap Index Scan on index_wallets_on_deleted_at (cost=0.00..4.16 rows=2 width=0) (actual time=0.003..0.003 rows=32 loops=1)

  • Index Cond: (wallets.deleted_at IS NULL)
  • Buffers: shared hit=1
Planning time : 0.041 ms
Execution time : 0.026 ms