explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2jWH

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 10,700.206 ↓ 0.0 0 1

Limit (cost=576,017.51..576,017.56 rows=20 width=55) (actual time=10,700.205..10,700.206 rows=0 loops=1)

2. 0.007 10,700.203 ↓ 0.0 0 1

Sort (cost=576,017.51..576,017.96 rows=180 width=55) (actual time=10,700.203..10,700.203 rows=0 loops=1)

  • Sort Key: created_at DESC, full_name
  • Sort Method: quicksort Memory: 25kB
3. 9,575.821 10,700.196 ↓ 0.0 0 1

Bitmap Heap Scan on person (cost=127,345.26..576,012.72 rows=180 width=55) (actual time=10,700.196..10,700.196 rows=0 loops=1)

  • Recheck Cond: ((country_id = '1'::smallint) AND (created_at >= (now() - '1 year 6 mons'::interval)))
  • Rows Removed by Index Recheck: 6451563
  • Filter: (created_by = ANY ('{57000094,57000094}'::text[]))
  • Rows Removed by Filter: 2535884
  • Heap Blocks: exact=46464 lossy=238383
4. 1,124.375 1,124.375 ↓ 1.0 2,564,362 1

Bitmap Index Scan on person_i3 (cost=0.00..127,345.21 rows=2,454,065 width=0) (actual time=1,124.374..1,124.375 rows=2,564,362 loops=1)

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