explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 98Wg : Optimization for: plan #7Jm1

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on messages (cost=4.31..15.22 rows=1 width=764) (actual rows= loops=)

  • Recheck Cond: (invoice_id = 2534147)
  • Filter: (((NOT disabled) OR (disabled IS NULL)) AND (channel_type = 1) AND ((recipient)::text = 'vinnie_stoltenberg330@dibbertgaylord.biz'::text) AND (message_type = ANY ('{12,11,17,18}'::integer[])))
2. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on index_messages_on_invoice_id (cost=0.00..4.30 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (invoice_id = 2534147)