explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O8HC

Settings
# exclusive inclusive rows x rows loops node
1. 2.142 4.135 ↓ 264.3 1,586 1

Bitmap Heap Scan on application application_renewal (cost=76.76..459.61 rows=6 width=4) (actual time=2.082..4.135 rows=1,586 loops=1)

  • Recheck Cond: ((renewal_product IS NOT NULL) AND (status = 'FUNDED'::application_status_type) AND (client_id = 20))
  • Filter: ((application_type)::text = 'RENEWAL'::text)
  • Heap Blocks: exact=321
2. 1.993 1.993 ↓ 1.4 1,586 1

Bitmap Index Scan on application_renewal_product_application_type_status_client_id_i (cost=0.00..76.76 rows=1,149 width=0) (actual time=1.993..1.993 rows=1,586 loops=1)

  • Index Cond: ((renewal_product IS NOT NULL) AND (status = 'FUNDED'::application_status_type) AND (client_id = 20))