explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ad5H

Settings
# exclusive inclusive rows x rows loops node
1. 13,132.720 15,080.982 ↑ 1.0 1 1

Bitmap Heap Scan on email_events "emailEvents" (cost=735,672.40..2,868,460.04 rows=1 width=1) (actual time=15,019.094..15,080.982 rows=1 loops=1)

  • Recheck Cond: ((tenant_key)::text = 'db936d2e445e2540d7fa9bde06cb89ecb6620b9073d7731fdbb04f7262394070'::text)
  • Rows Removed by Index Recheck: 33,467,858
  • Filter: ((batch_expiration > '2020-01-08 20:24:24.34'::timestamp without time zone) AND ((batch)::text = 'rNZpray84'::text))
  • Rows Removed by Filter: 9,717,526
  • Heap Blocks: exact=19,485 lossy=1,349,553
2. 1,948.262 1,948.262 ↑ 1.0 9,929,524 1

Bitmap Index Scan on ix_email_events_tenant_key_template_id (cost=0.00..735,672.39 rows=10,021,294 width=0) (actual time=1,948.262..1,948.262 rows=9,929,524 loops=1)

  • Index Cond: ((tenant_key)::text = 'db936d2e445e2540d7fa9bde06cb89ecb6620b9073d7731fdbb04f7262394070'::text)
Planning time : 0.087 ms
Execution time : 15,081.298 ms