explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MLqn

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 7.264 ↑ 166.7 3 1

Limit (cost=131,051.03..131,052.28 rows=500 width=569) (actual time=7.263..7.264 rows=3 loops=1)

2. 0.010 7.264 ↑ 8,735.7 3 1

Sort (cost=131,051.03..131,116.55 rows=26,207 width=569) (actual time=7.262..7.264 rows=3 loops=1)

  • Sort Key: created_at
  • Sort Method: quicksort Memory: 26kB
3. 0.019 7.254 ↑ 8,735.7 3 1

Bitmap Heap Scan on email_events "emailEvents" (cost=8,337.98..129,745.17 rows=26,207 width=569) (actual time=7.248..7.254 rows=3 loops=1)

  • Recheck Cond: (((tenant_key)::text = 'f39bb1d3c69e2ae9217182ab3f3a0311f5c469311c66ceedcde9547def8076f9'::text) AND (NOT fetched))
  • Filter: ((batch IS NULL) OR (batch_expiration <= '2020-02-02 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=8
4. 7.235 7.235 ↑ 2,600.2 13 1

Bitmap Index Scan on ix_email_events_for_get_request (cost=0.00..8,331.43 rows=33,803 width=0) (actual time=7.235..7.235 rows=13 loops=1)

  • Index Cond: ((tenant_key)::text = 'f39bb1d3c69e2ae9217182ab3f3a0311f5c469311c66ceedcde9547def8076f9'::text)
Planning time : 0.229 ms
Execution time : 7.291 ms