explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fjJj

Settings
# exclusive inclusive rows x rows loops node
1. 10,280.407 303,784.479 ↑ 1.0 1 1

Aggregate (cost=5,595,324.63..5,595,324.64 rows=1 width=8) (actual time=303,784.478..303,784.479 rows=1 loops=1)

  • Buffers: shared hit=1259040 read=476247 dirtied=352870, temp read=70242 written=70242
2. 289,018.159 293,504.072 ↑ 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=4,494.809..293,504.072 rows=18,717,646 loops=1)

  • Heap Blocks: exact=21779 lossy=1474506
  • Buffers: shared hit=1259040 read=476247 dirtied=352870
3. 4,485.913 4,485.913 ↑ 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=4,485.913..4,485.913 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=120821 read=118181
Planning time : 0.2 ms
Execution time : 303,784.575 ms