explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pMoU

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 5.483 39.589 ↑ 1.0 1 1

Aggregate (cost=76,207.05..76,207.07 rows=1 width=32) (actual time=39.589..39.589 rows=1 loops=1)

2. 29.985 34.106 ↑ 1.1 36,623 1

Bitmap Heap Scan on ledger_entry (cost=854.64..76,009.49 rows=39,511 width=6) (actual time=7.543..34.106 rows=36,623 loops=1)

  • Recheck Cond: (account_id = 40,498)
  • Filter: (id > '-1'::integer)
  • Heap Blocks: exact=23,607
3. 4.121 4.121 ↑ 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.121..4.121 rows=36,623 loops=1)

  • Index Cond: (account_id = 40,498)
Planning time : 0.146 ms
Execution time : 39.720 ms