explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LgOS

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 35.256 ↓ 0.0 0 1

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

  • Group Key: gl.account_number, gl.account_type
2. 0.002 35.254 ↓ 0.0 0 1

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

3. 0.001 35.252 ↓ 0.0 0 1

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

4. 35.251 35.251 ↓ 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=35.251..35.251 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 = '090A'::text)