explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yXKK

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 60.437 ↓ 0.0 0 1

HashAggregate (cost=15,601.03..15,601.04 rows=1 width=20) (actual time=60.437..60.437 rows=0 loops=1)

  • Group Key: gl.account_number, gl.account_type
2. 0.001 60.434 ↓ 0.0 0 1

Nested Loop (cost=1.15..15,601.02 rows=1 width=20) (actual time=60.434..60.434 rows=0 loops=1)

3. 0.002 60.433 ↓ 0.0 0 1

Nested Loop (cost=0.86..15,599.11 rows=6 width=18) (actual time=60.433..60.433 rows=0 loops=1)

4. 60.431 60.431 ↓ 0.0 0 1

Index Scan using posted_transaction_company_source_transaction_date_referenc_key on posted_transaction pt (cost=0.43..15,440.88 rows=1 width=8) (actual time=60.431..60.431 rows=0 loops=1)

  • Index Cond: ((company = 1) AND (transaction_date >= '2020-06-25'::date) AND (transaction_date <= '2020-06-25'::date))
  • Filter: ((source <> 'dsdfsda'::text) AND (source <> '020202'::text))
5. 0.000 0.000 ↓ 0.0 0

Index Scan using idx__posted_transaction_item__transaction_id on posted_transaction_item pti (cost=0.43..157.70 rows=53 width=24) (never executed)

  • Index Cond: (transaction_id = pt.id)
6. 0.000 0.000 ↓ 0.0 0

Index Scan using idx__gl__cobol_key on gl (cost=0.28..0.31 rows=1 width=18) (never executed)

  • Index Cond: ((company_number = 1) AND (cobol_key = pti.cobol_key))
  • Filter: (account_number = '8'::text)