explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rDcF

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

Bitmap Heap Scan on exchange_exchangerate (cost=19.48..23.50 rows=1 width=19) (actual rows= loops=)

  • Recheck Cond: ((source_id = 5) AND (target_id = 4))
2. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=19.48..19.48 rows=1 width=0) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on exchange_exchangerate_source_id (cost=0.00..9.62 rows=177 width=0) (actual rows= loops=)

  • Index Cond: (source_id = 5)
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on exchange_exchangerate_target_id (cost=0.00..9.62 rows=177 width=0) (actual rows= loops=)

  • Index Cond: (target_id = 4)