explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QEGs

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 4,823.831 ↑ 112.4 249 1

Finalize HashAggregate (cost=4,289.19..4,779.07 rows=27,993 width=70) (actual time=4,823.363..4,823.831 rows=249 loops=1)

  • Group Key: txdetails.account_id, txdetails.account_type_id, (to_char((txdetails.txn_date)::timestamp with time zone, 'YYYY'::text))
  • Buffers: shared hit=3 read=120,178
  • I/O Timings: read=1,997.237
2. 14.194 4,825.356 ↑ 132.7 844 1

Gather (cost=2,399.66..2,889.54 rows=111,972 width=70) (actual time=4,816.083..4,825.356 rows=844 loops=1)

  • Workers Planned: 4
  • Workers Launched: 3
  • Buffers: shared hit=3 read=120,178
  • I/O Timings: read=1,997.237
3. 37.083 4,811.162 ↑ 132.7 211 4 / 4

Partial HashAggregate (cost=1,399.66..1,889.54 rows=27,993 width=70) (actual time=4,810.846..4,811.162 rows=211 loops=4)

  • Group Key: txdetails.account_id, txdetails.account_type_id, (to_char((txdetails.txn_date)::timestamp with time zone, 'YYYY'::text))
  • Buffers: shared hit=3 read=120,178
  • I/O Timings: read=1,997.237
4. 10.823 4,774.079 ↑ 1.0 69,466 4 / 4

Parallel Append (cost=0.00..699.83 rows=69,983 width=44) (actual time=2,141.077..4,774.079 rows=69,466 loops=4)

  • Buffers: shared hit=3 read=120,178
  • I/O Timings: read=1,997.237
5. 4,235.032 4,763.256 ↑ 1.0 69,466 4 / 4

Parallel Bitmap Heap Scan on transaction_detail_p42 txdetails (cost=0.00..349.92 rows=69,983 width=44) (actual time=2,141.076..4,763.256 rows=69,466 loops=4)

  • Recheck Cond: ((company_id = '123145707554222'::numeric) AND (txn_date < '2019-12-31'::date))
  • Filter: ((is_non_posting IS NULL) AND (account_id IS NOT NULL))
  • Rows Removed by Filter: 15
  • Heap Blocks: exact=28,747
  • Buffers: shared hit=3 read=120,178
  • I/O Timings: read=1,997.237
6. 528.225 528.225 ↑ 1.0 277,927 1 / 4

Bitmap Index Scan on txnd_cid_tdate_isale_seq_i3_p42 (cost=0.00..4,595.89 rows=291,233 width=0) (actual time=2,112.898..2,112.898 rows=277,927 loops=1)

  • Index Cond: ((company_id = '123145707554222'::numeric) AND (txn_date < '2019-12-31'::date))
  • Buffers: shared hit=1 read=1,666
  • I/O Timings: read=1,997.237