explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zK8q

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 16.125 ↑ 1.2 14 1

Finalize GroupAggregate (cost=46,332.13..46,336.57 rows=17 width=36) (actual time=16.075..16.125 rows=14 loops=1)

  • Group Key: currency
2. 5.722 17.590 ↓ 1.1 36 1

Gather Merge (cost=46,332.13..46,336.10 rows=34 width=36) (actual time=16.063..17.590 rows=36 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.023 11.868 ↑ 1.4 12 3 / 3

Sort (cost=45,332.11..45,332.15 rows=17 width=36) (actual time=11.867..11.868 rows=12 loops=3)

  • Sort Key: currency
  • Sort Method: quicksort Memory: 26kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 26kB
4. 6.350 11.845 ↑ 1.4 12 3 / 3

Partial HashAggregate (cost=45,331.55..45,331.76 rows=17 width=36) (actual time=11.837..11.845 rows=12 loops=3)

  • Group Key: currency
5. 4.666 5.495 ↑ 1.5 10,773 3 / 3

Parallel Bitmap Heap Scan on ledger_entry (cost=787.65..45,045.16 rows=16,365 width=10) (actual time=1.101..5.495 rows=10,773 loops=3)

  • 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=1,350
6. 0.829 0.829 ↑ 1.2 32,319 1 / 3

Bitmap Index Scan on ix_ledger_entry_account_id (cost=0.00..777.83 rows=39,277 width=0) (actual time=2.487..2.487 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.232 ms
Execution time : 17.694 ms