explain.depesz.com

PostgreSQL's explain analyze made readable

Result: abwV

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.015 ↓ 0.0 0 1

Bitmap Heap Scan on email_events "emailEvents" (cost=24.54..2,996.24 rows=259 width=10) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: (((batch)::text = 'rNZpray84'::text) AND (batch_expiration > '2019-07-08 20:24:24.34'::timestamp without time zone))
  • Filter: ((tenant_key)::text = '37a99e196e8667eaee17849b9dd15babcb4b3fd1c13b80debeaf93685bbc532c'::text)
2. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on ix_email_events_for_update_request (cost=0.00..24.48 rows=805 width=0) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (((batch)::text = 'rNZpray84'::text) AND (batch_expiration > '2019-07-08 20:24:24.34'::timestamp without time zone))
Planning time : 0.197 ms
Execution time : 0.036 ms