explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xjk9 : DEVELOPMENT w.o index

Settings
# exclusive inclusive rows x rows loops node
1. 0.166 23.397 ↓ 296.0 296 1

Sort (cost=2,788.68..2,788.68 rows=1 width=871) (actual time=23.373..23.397 rows=296 loops=1)

  • Sort Key: devices.created_at
  • Sort Method: quicksort Memory: 172kB
2. 23.231 23.231 ↓ 296.0 296 1

Seq Scan on devices (cost=0.00..2,788.67 rows=1 width=871) (actual time=0.662..23.231 rows=296 loops=1)

  • Filter: (((device_type)::text = 'android'::text) AND (to_tsvector((device_token)::text) @@ to_tsquery('0000-0000611e4061'::text)))
  • Rows Removed by Filter: 4693
Planning time : 0.156 ms
Execution time : 23.433 ms