explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GunB

Settings
# exclusive inclusive rows x rows loops node
1. 254.430 247,079.134 ↓ 294.2 206,560 1

Sort (cost=7,901.51..7,903.26 rows=702 width=40) (actual time=247,027.281..247,079.134 rows=206,560 loops=1)

  • Sort Key: score_time
  • Sort Method: external merge Disk: 8,504kB
2. 246,618.608 246,824.704 ↓ 294.2 206,560 1

Bitmap Heap Scan on feature_data f (cost=508.88..7,868.32 rows=702 width=40) (actual time=147,010.770..246,824.704 rows=206,560 loops=1)

  • Recheck Cond: (data ? 'd6f87aa1-407b-4acd-9bac-863216915473'::text)
  • Filter: ((score_time >= '2020-03-01 00:00:00'::timestamp without time zone) AND (score_time <= '2020-04-27 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 974,699
  • Heap Blocks: exact=27,463
3. 206.096 206.096 ↓ 530.4 1,181,259 1

Bitmap Index Scan on idxgin (cost=0.00..508.70 rows=2,227 width=0) (actual time=206.096..206.096 rows=1,181,259 loops=1)

  • Index Cond: (data ? 'd6f87aa1-407b-4acd-9bac-863216915473'::text)