explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S3U2

Settings
# exclusive inclusive rows x rows loops node
1. 25,939.620 26,038.637 ↓ 1.8 15,722 1

Bitmap Heap Scan on devices (cost=530.36..35,661.71 rows=8,530 width=405) (actual time=100.902..26,038.637 rows=15,722 loops=1)

  • Recheck Cond: (to_tsvector('english'::regconfig, (device_token)::text) @@ to_tsquery('0000-0000611e4061'::text))
  • Heap Blocks: exact=11387
2. 99.017 99.017 ↓ 1.9 15,826 1

Bitmap Index Scan on index_devices_on_device_token_gin (cost=0.00..528.23 rows=8,530 width=0) (actual time=99.017..99.017 rows=15,826 loops=1)

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