explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hr7L

Settings
# exclusive inclusive rows x rows loops node
1. 0.085 441.720 ↓ 2.0 2 1

Sort (cost=27,534.54..27,534.54 rows=1 width=104) (actual time=441.718..441.720 rows=2 loops=1)

  • Output: id, posted_date, journal_id, account_id, currency, value, is_credit, description, invoice_id, customer_rebate_id, product_id, corrected, correction_for_ledger_entry_id
  • Sort Key: ledger_entry.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=6426
2. 441.635 441.635 ↓ 2.0 2 1

Parallel Seq Scan on public.ledger_entry (cost=0.00..27,534.53 rows=1 width=104) (actual time=441.520..441.635 rows=2 loops=1)

  • Output: id, posted_date, journal_id, account_id, currency, value, is_credit, description, invoice_id, customer_rebate_id, product_id, corrected, correction_for_ledger_entry_id
  • Filter: (536459 = ledger_entry.journal_id)
  • Rows Removed by Filter: 376205
  • Buffers: shared hit=6397