Slow query with limit & offset

N1QL
1

I have a backet with 30 000 + records

I try to

Blockquote SELECT tb.*
FROM task_bot AS tb
WHERE tb.task_id NOT IN (
SELECT RAW tbb.task_id
FROM task_bot AS tbb
WHERE tbb._type= ‘BotTask’ AND tbb.bot_token = ‘11111’ )
AND tb.type = ‘follower’
AND tb.network= ‘instagram’
AND tb._type = ‘Task’
AND tb.status = 0 limit 1 OFFSET 19117

And time is elapsed: 756.8ms execution: 756.7ms
This is a very long time

Indexes Currently Used

CREATE INDEX adv_network_type_task_id_type_status ON task_bot(network,type,task_id) WHERE ((_type = ‘Task’) and (status = 0))

CREATE INDEX adv_status_network_type_task_id_type ON task_bot(status,network,type,task_id) WHERE (_type = ‘Task’)

How can I reduce request time , please help.

2 
WITH taskids AS (SELECT RAW tbb.task_id FROM task_bot AS tbb WHERE tbb._type= "BotTask" AND tbb.bot_token = "11111" )
SELECT tb.*
FROM task_bot AS tb
WHERE tb.task_id NOT IN taskids AND tb.type = "follower" AND tb.network= "instagram" AND tb._type = "Task" AND tb.status = 0
LIMIT 1 OFFSET 19117

CREATE INDEX adv_network_type_task_id_type_status ON task_bot(network,type,task_id) WHERE ((_type = "Task") and (status = 0))
CREATE INDEX ix1 ON task_bot(bot_token,task_id) WHERE _type = "BotTask";

checkout Subquery handling and potential query rewrite

3

Unfortunately problem is not in Inner join I tink problem is in big OFFSET
I try simple query

SELECT tb.*
FROM task_bot AS tb
WHERE tb.type = “follower”
AND tb.network= “instagram”
AND tb._type = “Task”
AND tb.status = 0
LIMIT 1
OFFSET 190117

And elapsed: 788.8ms execution: 788.8ms

4

As you have all equality, checkout keyset pagination link

5

Sorry, I do not undestand I do not select by page, I need to get a random record in this query