explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tQxO

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

Aggregate (cost=229,670.21..229,670.22 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on analytic (cost=54,620.14..229,667.58 rows=1,053 width=0) (actual rows= loops=)

  • Recheck Cond: ((settings_id)::text = 'qvvJj3x8zLJjSeMZVg9I'::text)
  • Filter: (((event_id)::text = 'BOT_USAGE'::text) AND ((creation)::date >= ((now() + '-30 days'::interval))::date) AND ((creation)::date <= ((now() + '-1 days'::interval))::date))
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on analytic_gist_idx (cost=0.00..54,619.87 rows=840,461 width=0) (actual rows= loops=)

  • Index Cond: ((settings_id)::text = 'qvvJj3x8zLJjSeMZVg9I'::text)