explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MerH

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 9,456.744 ↓ 0.0 0 1

Limit (cost=611,937.49..611,937.54 rows=20 width=55) (actual time=9,456.743..9,456.744 rows=0 loops=1)

2. 0.008 9,456.741 ↓ 0.0 0 1

Sort (cost=611,937.49..611,938.22 rows=291 width=55) (actual time=9,456.741..9,456.741 rows=0 loops=1)

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

Seq Scan on person (cost=0.00..611,929.75 rows=291 width=55) (actual time=9,456.733..9,456.733 rows=0 loops=1)

  • Filter: ((created_by = ANY ('{57000094,57000094}'::text[])) AND (created_at >= '2017-05-11 00:00:00+00'::timestamp with time zone) AND (country_id = '1'::smallint))
  • Rows Removed by Filter: 12484877
Planning time : 0.170 ms
Execution time : 9,456.765 ms