Anand Kr Shaw
03/19/2025, 12:58 PMBROKER_REDUCE(limit:10) 1 0
COMBINE_SELECT 2 1
PLAN_START(numSegmentsForThisPlan:27) -1 -1
SELECT(selectList:symbolName, ingestionTime) 3 2
PROJECT(ingestionTime, symbolName) 4 3
DOC_ID_SET 5 4
FILTER_AND 6 5
FILTER_FULL_SCAN(operator:IN,predicate:exchSeg IN ('nse','bse')) 7 6
FILTER_FULL_SCAN(operator:EQ,predicate:ordStatus = 'complete') 8 6
FILTER_INVERTED_INDEX(indexLookUp:inverted_index,operator:EQ,predicate:userId = 'ABC') 9 6
PLAN_START(numSegmentsForThisPlan:12) -1 -1
ALL_SEGMENTS_PRUNED_ON_SERVER 3 2
PLAN_START(numSegmentsForThisPlan:79) -1 -1
SELECT(selectList:symbolName, ingestionTime) 3 2
PROJECT(ingestionTime, symbolName) 4 3
DOC_ID_SET 5 4
FILTER_EMPTY
SELECT symbolName, ingestionTime
FROM amxordersgpx_uf
WHERE userId = 'ABC'
AND exchSeg IN ('nse', 'bse')
AND ordStatus = 'complete'
AND ingestionTime < 1741631400000
Assuming it as a query plan issue and not execution.Anand Kr Shaw
03/19/2025, 12:58 PMAnand Kr Shaw
03/19/2025, 1:20 PMMayank
Anand Kr Shaw
03/19/2025, 2:56 PMGonzalo Ortiz
03/23/2025, 3:29 PMGonzalo Ortiz
03/23/2025, 3:30 PMGonzalo Ortiz
03/23/2025, 3:31 PMAnand Kr Shaw
03/23/2025, 3:31 PMAnand Kr Shaw
03/23/2025, 3:32 PMAnand Kr Shaw
03/23/2025, 3:33 PMMayank
userId if all queries are for a specific user (userId = 'ABC'). Use Timestamp index (store in second or hour, or day, whatever you will query on, not millis). This will give you 5k or moreXiang Fu
Xiang Fu
Xiang Fu
select count(*) query with the predicateXiang Fu
Anand Kr Shaw
04/07/2025, 4:16 AMXiang Fu
Xiang Fu