explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KEOI

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=1,506,288.01..1,506,288.02 rows=1 width=8) (actual rows= loops=)

  • Output: count(*)
2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ihub_owner.ihub_check_clear (cost=20,859.57..1,503,954.09 rows=933,566 width=0) (actual rows= loops=)

  • Output: id, ihub_batch_id, ihub_merchant_id, account_number, batch_date, batch_clear_date, transmit_clear_date, is_business, std_entry_class_id, is_recurring, category_type_id, ref_type_id, orig_account_name, orig_id_nbr, orig_route_number, description, routing_number, from_account_type_id, from_account_name, to_route_number, to_account_type_id, to_account_name, bpt_transfer_id, payor_first_name, payor_last_name, check_number, amount, hk_src_nk, hk_src_id, hk_modified, row_number, change_id, client_transaction_id, request_id, state_id, version, std_entry_class_code, hk_created, ihub_dsp_posted, retry_count, account_number_sha512, to_account_number_sha512, ledger_id
  • Recheck Cond: (ihub_check_clear.hk_modified >= '2018-12-01 00:00:00'::timestamp without time zone)
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ihub_check_clear_hk_modified (cost=0.00..20,626.18 rows=933,566 width=0) (actual rows= loops=)

  • Index Cond: (ihub_check_clear.hk_modified >= '2018-12-01 00:00:00'::timestamp without time zone)