explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 38Pp : Optimization for: plan #pMoU

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 6.247 40.773 ↑ 1.0 1 1

Aggregate (cost=76,108.27..76,108.29 rows=1 width=32) (actual time=40.773..40.773 rows=1 loops=1)

2. 29.954 34.526 ↑ 1.1 36,623 1

Bitmap Heap Scan on ledger_entry (cost=854.64..75,910.72 rows=39,511 width=6) (actual time=8.282..34.526 rows=36,623 loops=1)

  • Recheck Cond: (account_id = 40,498)
  • Heap Blocks: exact=23,607
3. 4.572 4.572 ↑ 1.1 36,623 1

Bitmap Index Scan on ix_ledger_entry_account_id (cost=0.00..844.76 rows=39,511 width=0) (actual time=4.572..4.572 rows=36,623 loops=1)

  • Index Cond: (account_id = 40,498)
Planning time : 0.083 ms
Execution time : 40.913 ms