explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iins

Settings
# exclusive inclusive rows x rows loops node
1. 0.150 0.421 ↓ 2.6 296 1

Sort (cost=267.73..268.02 rows=115 width=878) (actual time=0.393..0.421 rows=296 loops=1)

  • Sort Key: devices.created_at
  • Sort Method: quicksort Memory: 172kB
2. 0.197 0.271 ↓ 2.6 296 1

Bitmap Heap Scan on devices (cost=21.14..263.79 rows=115 width=878) (actual time=0.084..0.271 rows=296 loops=1)

  • Recheck Cond: (to_tsvector('english'::regconfig, (device_token)::text) @@ to_tsquery('0000-0000611e4061'::text))
  • Heap Blocks: exact=27
3. 0.074 0.074 ↓ 2.6 296 1

Bitmap Index Scan on index_devices_on_device_token_gin (cost=0.00..21.11 rows=115 width=0) (actual time=0.074..0.074 rows=296 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, (device_token)::text) @@ to_tsquery('0000-0000611e4061'::text))
Planning time : 0.206 ms
Execution time : 0.460 ms