explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i43J

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

Unique (cost=858.08..870.90 rows=881 width=23) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=858.08..862.35 rows=1,709 width=23) (actual rows= loops=)

  • Sort Key: src_currency, dst_currency, date DESC
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on currency_exchange_rate (cost=127.86..766.32 rows=1,709 width=23) (actual rows= loops=)

  • Recheck Cond: ((src_currency = ANY ('{USD,EUR,GBP,CNY,RUB}'::bpchar[])) AND (dst_currency = ANY ('{USD,EUR,GBP,CNY,RUB}'::bpchar[])))
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on currency_exchange_rate_pkey (cost=0.00..127.44 rows=1,709 width=0) (actual rows= loops=)

  • Index Cond: ((src_currency = ANY ('{USD,EUR,GBP,CNY,RUB}'::bpchar[])) AND (dst_currency = ANY ('{USD,EUR,GBP,CNY,RUB}'::bpchar[])))