explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V9FC

Settings
# exclusive inclusive rows x rows loops node
1. 10,004.823 40,617.525 ↑ 1.0 1 1

Aggregate (cost=5,595,324.63..5,595,324.64 rows=1 width=8) (actual time=40,617.525..40,617.525 rows=1 loops=1)

  • Buffers: shared hit=1735287, temp read=70242 written=70242
2. 27,353.092 30,612.702 ↑ 1.3 18,717,646 1

Bitmap Heap Scan on profiles_email_consents profiles_email_consents (cost=1,262,554.31..5,536,319.8 rows=23,601,930 width=8) (actual time=3,268.422..30,612.702 rows=18,717,646 loops=1)

  • Buffers: shared hit=1735287
3. 3,259.610 3,259.610 ↑ 1.3 18,717,646 1

Bitmap Index Scan on pec_consent_idx (cost=0..1,256,653.83 rows=23,601,930 width=0) (actual time=3,259.61..3,259.61 rows=18,717,646 loops=1)

  • Index Cond: ((profiles_email_consents.email_consent_id = ANY ('{8,22,24,27,80,12,107,20,84,108,16,19,25}'::integer[])) AND (profiles_email_consents.status = 'sub'::matrix__email.consent_status))
  • Buffers: shared hit=239002