explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R1xe : Optimization for: plan #A1mu

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 4.388 38.735 ↓ 1.1 13,625 1

Sort (cost=79,236.83..79,269.11 rows=12,911 width=24) (actual time=37.697..38.735 rows=13,625 loops=1)

  • Sort Key: run
  • Sort Method: quicksort Memory: 1449kB
2. 28.587 34.347 ↓ 1.1 13,625 1

Bitmap Heap Scan on value (cost=1,687.23..78,355.25 rows=12,911 width=24) (actual time=9.700..34.347 rows=13,625 loops=1)

  • Recheck Cond: ((channel_id = ANY ('{1011030901,1011030902,1011030903,1011030904,1011030905,1011030921,1011030922,1011030923,1011030924,1011030925,1011030941,1011030942,1011030943,1011030944,1011030945,1011030961,1011030962,1011030963,1011030964,101 (...)
  • Filter: (dataset_id = ANY ('{1,203,242}'::bigint[]))
  • Rows Removed by Filter: 7500
  • Heap Blocks: exact=20826
3. 5.760 5.760 ↑ 1.0 21,125 1

Bitmap Index Scan on value_btree (cost=0.00..1,684.00 rows=21,156 width=0) (actual time=5.760..5.760 rows=21,125 loops=1)

  • Index Cond: ((channel_id = ANY ('{1011030901,1011030902,1011030903,1011030904,1011030905,1011030921,1011030922,1011030923,1011030924,1011030925,1011030941,1011030942,1011030943,1011030944,1011030945,1011030961,1011030962,1011030963,1011030964 (...)