explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I5NH

Settings
# exclusive inclusive rows x rows loops node
1. 0.258 16.351 ↓ 32.0 32 1

Result (cost=107.28..1,746.06 rows=1 width=2,364) (actual time=15.825..16.351 rows=32 loops=1)

2. 0.013 16.093 ↓ 32.0 32 1

Append (cost=107.28..1,745.93 rows=1 width=1,854) (actual time=15.804..16.093 rows=32 loops=1)

3. 15.376 16.080 ↓ 32.0 32 1

Bitmap Heap Scan on fact_transaction_header_jun_2016 ft (cost=107.28..1,745.93 rows=1 width=1,854) (actual time=15.803..16.080 rows=32 loops=1)

  • Recheck Cond: ((mp_payer_subpayment_instrument)::text = 'Normal'::text)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND (transfer_date >= '2016-06-01 00:00:00'::timestamp without time zone) AND (transfer_date < '2016-06-30 00:00:00'::timestamp without time zone) AND ((payer_status I (...)
  • Rows Removed by Filter: 4481
  • Heap Blocks: exact=727
4. 0.704 0.704 ↑ 1.0 4,513 1

Bitmap Index Scan on idx_payerpaymentinst_jun_2016 (cost=0.00..107.28 rows=4,666 width=0) (actual time=0.704..0.704 rows=4,513 loops=1)

  • Index Cond: ((mp_payer_subpayment_instrument)::text = 'Normal'::text)