explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2tuB

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 12,851.696 ↓ 0.0 0 1

Limit (cost=576,013.71..576,013.76 rows=20 width=55) (actual time=12,851.695..12,851.696 rows=0 loops=1)

2. 0.055 12,851.693 ↓ 0.0 0 1

Sort (cost=576,013.71..576,014.16 rows=180 width=55) (actual time=12,851.692..12,851.693 rows=0 loops=1)

  • Sort Key: created_at DESC, full_name
  • Sort Method: quicksort Memory: 25kB
3. 11,670.037 12,851.638 ↓ 0.0 0 1

Bitmap Heap Scan on person (cost=127,341.32..576,008.92 rows=180 width=55) (actual time=12,851.638..12,851.638 rows=0 loops=1)

  • Recheck Cond: ((country_id = '1'::smallint) AND (created_at >= (now() - '1 year 6 mons'::interval)))
  • Rows Removed by Index Recheck: 6451558
  • Filter: (created_by = ANY ('{57000094,57000094}'::text[]))
  • Rows Removed by Filter: 2535867
  • Heap Blocks: exact=46462 lossy=238383
4. 1,181.601 1,181.601 ↓ 1.0 2,563,934 1

Bitmap Index Scan on person_i3 (cost=0.00..127,341.27 rows=2,454,071 width=0) (actual time=1,181.601..1,181.601 rows=2,563,934 loops=1)

  • Index Cond: ((country_id = '1'::smallint) AND (created_at >= (now() - '1 year 6 mons'::interval)))
Planning time : 0.211 ms
Execution time : 12,852.149 ms