explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZCXV

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=67.25..35,690.70 rows=195 width=4) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on account_entry (cost=66.83..12,649.21 rows=3,212 width=8) (actual rows= loops=)

  • Recheck Cond: ((debet_account_id = 259412) OR (credit_account_id = 259412))
3. 0.000 0.000 ↓ 0.0

BitmapOr (cost=66.83..66.83 rows=3,212 width=0) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on account_entry_debet_account_id (cost=0.00..33.07 rows=1,668 width=0) (actual rows= loops=)

  • Index Cond: (debet_account_id = 259412)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on account_entry_credit_account_id (cost=0.00..32.14 rows=1,544 width=0) (actual rows= loops=)

  • Index Cond: (credit_account_id = 259412)
6. 0.000 0.000 ↓ 0.0

Index Scan using document_types_pkey on document_types (cost=0.43..7.16 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = account_entry.document_type_id)
  • Filter: ((document_code)::text = 'pay_docs_in_document'::text)