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’)
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