explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H2un : Optimization for: plan #SAUm

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=461.96..461.97 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on credit_cards (cost=5.33..461.68 rows=115 width=8) (actual rows= loops=)

  • Recheck Cond: (card_id = '0000072e-67d4-44d9-9d5f-f2720bbab83b'::uuid)
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on credit_cards_card_id_index (cost=0.00..5.30 rows=115 width=0) (actual rows= loops=)

  • Index Cond: (card_id = '0000072e-67d4-44d9-9d5f-f2720bbab83b'::uuid)