explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ly7I

Settings
# exclusive inclusive rows x rows loops node
1. 224.289 5,711.430 ↑ 18.4 2,471 1

HashAggregate (cost=418,539.46..419,337.01 rows=45,574 width=70) (actual time=5,709.662..5,711.430 rows=2,471 loops=1)

  • Group Key: txdetails.account_id, txdetails.account_type_id, (to_char((txdetails.txn_date)::timestamp with time zone, 'MM/YYYY'::text))
  • Buffers: shared hit=1 read=125,108
  • I/O Timings: read=2,661.329
2. 62.698 5,487.141 ↓ 1.1 497,666 1

Append (cost=7,562.99..413,982.09 rows=455,737 width=44) (actual time=2,858.014..5,487.141 rows=497,666 loops=1)

  • Buffers: shared hit=1 read=125,108
  • I/O Timings: read=2,661.329
3. 2,601.172 5,424.443 ↓ 1.1 497,666 1

Bitmap Heap Scan on transaction_detail_p3 txdetails (cost=7,562.99..411,703.41 rows=455,737 width=44) (actual time=2,858.012..5,424.443 rows=497,666 loops=1)

  • Recheck Cond: ((company_id = '123145756551122'::numeric) AND (txn_date < '2020-12-31'::date))
  • Filter: ((is_non_posting IS NULL) AND (account_id IS NOT NULL))
  • Heap Blocks: exact=122,505
  • Buffers: shared hit=1 read=125,108
  • I/O Timings: read=2,661.329
4. 2,823.271 2,823.271 ↓ 1.0 497,666 1

Bitmap Index Scan on txnd_cid_tdate_isale_seq_i3_p3 (cost=0.00..7,449.05 rows=474,649 width=0) (actual time=2,823.271..2,823.271 rows=497,666 loops=1)

  • Index Cond: ((company_id = '123145756551122'::numeric) AND (txn_date < '2020-12-31'::date))
  • Buffers: shared hit=1 read=2,646
  • I/O Timings: read=2,661.329