explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ccTP

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

GroupAggregate (cost=1,203.17..1,203.20 rows=1 width=50) (actual time=8.170..8.170 rows=0 loops=1)

  • Group Key: gl.account_number, gl.account_type
  • Buffers: shared hit=8 read=7
2. 0.032 8.167 ↓ 0.0 0 1

Sort (cost=1,203.17..1,203.17 rows=1 width=20) (actual time=8.167..8.167 rows=0 loops=1)

  • Sort Key: gl.account_number, gl.account_type
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=8 read=7
3. 0.004 8.135 ↓ 0.0 0 1

Nested Loop (cost=1.41..1,203.16 rows=1 width=20) (actual time=8.135..8.135 rows=0 loops=1)

  • Join Filter: (pti.cobol_key = gl.cobol_key)
  • Buffers: shared hit=5 read=7
4. 1.475 1.475 ↑ 1.0 1 1

Index Scan using idx__gl__account_number on gl (cost=0.29..12.61 rows=1 width=18) (actual time=1.474..1.475 rows=1 loops=1)

  • Index Cond: ((company_number = 1) AND (account_number = ANY ('{9999,99999}'::text[])))
  • Buffers: shared hit=5 read=3
5. 0.000 6.656 ↓ 0.0 0 1

Nested Loop (cost=1.12..1,190.45 rows=8 width=18) (actual time=6.656..6.656 rows=0 loops=1)

  • Buffers: shared read=4
6. 6.656 6.656 ↓ 0.0 0 1

Index Scan using posted_transaction_company_source_transaction_date_referenc_key on posted_transaction pt (cost=0.56..8.58 rows=1 width=8) (actual time=6.656..6.656 rows=0 loops=1)

  • Index Cond: ((company = 1) AND (source = ''::text) AND (transaction_date >= '2020-06-01'::date) AND (transaction_date <= '2020-06-29'::date))
  • Buffers: shared read=4
7. 0.000 0.000 ↓ 0.0 0

Index Scan using idx__posted_transaction_item__transaction_id on posted_transaction_item pti (cost=0.56..1,178.13 rows=374 width=24) (never executed)

  • Index Cond: (transaction_id = pt.id)