explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MU0T

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

Bitmap Heap Scan on azure_mailboxes (cost=2.86..3.88 rows=1 width=487) (actual time=0.022..0.022 rows=0 loops=1)

  • Recheck Cond: ((((tenant_id)::text = '68e22466-6d0d-462e-a581-b9649ec2111f'::text) AND (subscription_expires_at IS NULL)) OR (((tenant_id)::text = '68e22466-6d0d-462e-a581-b9649ec2111f'::text) AND (subscription_expires_at < (timezone('UTC'::text, CURRENT_TIMESTAMP) + '00:15:00'::interval))))
  • Filter: (((rule_id)::text <> ALL ('{ignore,off,unknown}'::text[])) AND ((subscription_expires_at IS NULL) OR (subscription_expires_at < (timezone('UTC'::text, CURRENT_TIMESTAMP) + '00:15:00'::interval))))
2. 0.001 0.021 ↓ 0.0 0 1

BitmapOr (cost=2.86..2.86 rows=1 width=0) (actual time=0.021..0.021 rows=0 loops=1)

3. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on idx_subscription_expiration (cost=0.00..1.43 rows=1 width=0) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (((tenant_id)::text = '68e22466-6d0d-462e-a581-b9649ec2111f'::text) AND (subscription_expires_at IS NULL))
4. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on idx_subscription_expiration (cost=0.00..1.43 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (((tenant_id)::text = '68e22466-6d0d-462e-a581-b9649ec2111f'::text) AND (subscription_expires_at < (timezone('UTC'::text, CURRENT_TIMESTAMP) + '00:15:00'::interval)))
Planning time : 0.252 ms
Execution time : 0.058 ms