explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dH0

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

HashAggregate (cost=37,702.65..37,704.60 rows=195 width=4) (actual rows= loops=)

  • Group Key: account_entry.document_id
2. 0.000 0.000 ↓ 0.0

Append (cost=0.99..37,702.16 rows=195 width=4) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.99..19,539.44 rows=101 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using account_entry_debet_account_id on account_entry (cost=0.56..6,672.33 rows=1,668 width=8) (actual rows= loops=)

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

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

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

Nested Loop (cost=0.99..18,160.77 rows=94 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using account_entry_credit_account_id on account_entry account_entry_1 (cost=0.56..6,174.39 rows=1,544 width=8) (actual rows= loops=)

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

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

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