explain.depesz.com

PostgreSQL's explain analyze made readable

Result: InKO

Settings
# exclusive inclusive rows x rows loops node
1. 8.009 17.350 ↑ 1.2 14 1

HashAggregate (cost=46,055.72..46,055.94 rows=17 width=36) (actual time=17.345..17.350 rows=14 loops=1)

  • Group Key: currency
2. 7.718 9.341 ↑ 1.2 32,319 1

Bitmap Heap Scan on ledger_entry (cost=787.65..45,761.15 rows=39,277 width=10) (actual time=2.063..9.341 rows=32,319 loops=1)

  • Recheck Cond: (account_id = ANY ('{14,541,6786,7480,48,50,52,54,56,58,2659,4107,12502,13860,13862,13864,10634}'::bigint[]))
  • Heap Blocks: exact=3,735
3. 1.623 1.623 ↑ 1.2 32,319 1

Bitmap Index Scan on ix_ledger_entry_account_id (cost=0.00..777.83 rows=39,277 width=0) (actual time=1.623..1.623 rows=32,319 loops=1)

  • Index Cond: (account_id = ANY ('{14,541,6786,7480,48,50,52,54,56,58,2659,4107,12502,13860,13862,13864,10634}'::bigint[]))
Planning time : 0.129 ms
Execution time : 17.394 ms