explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7q5L9

Settings
# exclusive inclusive rows x rows loops node
1. 10.930 7,021.975 ↑ 74.2 2,223 1

Gather (cost=3,060.48..3,781.66 rows=164,840 width=70) (actual time=7,016.673..7,021.975 rows=2,223 loops=1)

  • Workers Planned: 4
  • Workers Launched: 2
  • Buffers: shared hit=336 read=173,722
  • I/O Timings: read=3,006.455
2. 78.307 7,011.045 ↑ 55.6 741 3 / 3

Partial HashAggregate (cost=2,060.48..2,781.66 rows=41,210 width=70) (actual time=7,010.131..7,011.045 rows=741 loops=3)

  • Group Key: txdetails.account_id, txdetails.account_type_id, (to_char((txdetails.txn_date)::timestamp with time zone, 'MM/YYYY'::text))
  • Buffers: shared hit=336 read=173,722
  • I/O Timings: read=3,006.455
3. 20.092 6,932.738 ↓ 1.4 145,199 3 / 3

Parallel Append (cost=0.00..1,030.24 rows=103,024 width=44) (actual time=3,233.697..6,932.738 rows=145,199 loops=3)

  • Buffers: shared hit=336 read=173,722
  • I/O Timings: read=3,006.455
4. 5,854.612 6,912.646 ↓ 1.4 145,199 3 / 3

Parallel Bitmap Heap Scan on transaction_detail_p12 txdetails (cost=0.00..515.12 rows=103,024 width=44) (actual time=3,233.696..6,912.646 rows=145,199 loops=3)

  • Recheck Cond: ((company_id = '123146166221724'::numeric) AND (txn_date < '2020-12-31'::date))
  • Filter: ((is_non_posting IS NULL) AND (account_id IS NOT NULL))
  • Heap Blocks: exact=56,973
  • Buffers: shared hit=336 read=173,722
  • I/O Timings: read=3,006.455
5. 1,058.034 1,058.034 ↓ 1.0 435,597 1 / 3

Bitmap Index Scan on txnd_cid_tdate_isale_seq_i3_p12 (cost=0.00..6,709.19 rows=426,663 width=0) (actual time=3,174.102..3,174.102 rows=435,597 loops=1)

  • Index Cond: ((company_id = '123146166221724'::numeric) AND (txn_date < '2020-12-31'::date))
  • Buffers: shared hit=2 read=2,333
  • I/O Timings: read=3,006.455