explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NgxF

Settings
# exclusive inclusive rows x rows loops node
1. 11,888.629 13,931.371 ↑ 1.0 1 1

Bitmap Heap Scan on email_events "emailEvents" (cost=742,612.40..2,875,400.04 rows=1 width=1) (actual time=13,829.019..13,931.371 rows=1 loops=1)

  • Recheck Cond: ((tenant_key)::text = 'db936d2e445e2540d7fa9bde06cb89ecb6620b9073d7731fdbb04f7262394070'::text)
  • Rows Removed by Index Recheck: 33439988
  • Filter: ((batch_expiration > '2020-01-08 20:24:24.34'::timestamp without time zone) AND ((batch)::text = 'rNZpray84'::text))
  • Rows Removed by Filter: 9739053
  • Heap Blocks: exact=25653 lossy=1349577
2. 2,042.742 2,042.742 ↑ 1.0 9,997,679 1

Bitmap Index Scan on ix_email_events_tenant_key_template_id (cost=0.00..742,612.39 rows=10,021,294 width=0) (actual time=2,042.742..2,042.742 rows=9,997,679 loops=1)

  • Index Cond: ((tenant_key)::text = 'db936d2e445e2540d7fa9bde06cb89ecb6620b9073d7731fdbb04f7262394070'::text)
Planning time : 0.139 ms
Execution time : 13,931.667 ms