explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cYyu

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

Limit (cost=36.17..93.04 rows=1 width=307) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on activity_logs (cost=36.17..5,779.24 rows=101 width=307) (actual rows= loops=)

  • Recheck Cond: ((data -> 'emails'::text) ? 'fd5b01b263df4951babd413c07f4e13e'::text)
  • Filter: ((activity_type)::text = 'email'::text)
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on activity_logs_data_emails (cost=0.00..36.15 rows=1,620 width=0) (actual rows= loops=)

  • Index Cond: ((data -> 'emails'::text) ? 'fd5b01b263df4951babd413c07f4e13e'::text)