explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xipg

Settings
# exclusive inclusive rows x rows loops node
1. 26.132 26.132 ↑ 1.0 23,790 1

Seq Scan on bain.tbl_customer_details (cost=0.00..2,381.89 rows=24,903 width=164) (actual time=0.015..26.132 rows=23,790 loops=1)

  • Output: customer_details_id, record_type, barclays_customer_id, ip_reference, transaction_type, insurance_start_date, main_name_prefix, main_surname, main_date_of_birth, corres_address_line_1, corres_post_code, main_specific_occupation, staff_indicator, brid, previous_refused_cancelled, previous_criminal_convinctions, mortgage_related_indicator, mortgage_application_ref, mortgage_completion_activation, number_home_claims_5years, public_credit_check_req, prefered_channel, status, status_reason, rating_reference, quote_eligible_for_flood_receding, main_first_name, file_sequence, total_premium, old_premium, aviva_response_date, is_processed_by_output_processor
  • Filter: (tbl_customer_details.status = '1000'::numeric)
  • Rows Removed by Filter: 15241
Planning time : 0.375 ms
Execution time : 31.867 ms