explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qeml

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

Limit (cost=419,777.20..419,777.25 rows=20 width=55) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=419,777.20..419,777.26 rows=25 width=55) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on person (cost=17,342.15..419,776.62 rows=25 width=55) (actual rows= loops=)

  • Recheck Cond: ((country_id = '1'::smallint) AND (created_at >= (now() - '6 mons'::interval)))
  • Filter: (created_by = ANY ('{57000094,57000094}'::text[]))
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on person_i3 (cost=0.00..17,342.15 rows=334,158 width=0) (actual rows= loops=)

  • Index Cond: ((country_id = '1'::smallint) AND (created_at >= (now() - '6 mons'::interval)))