query timeout,need to optimize sql

[coderbradlee]

query {
 action{
    byType(type: "execution"){
  exist
    actions(pagination: {skip: 0,first:2}){
      actHash
    blkHash
    timeStamp
    actType
    sender
    recipient
    amount
    gasFee
    }
    count
  }
}
}

need to optimize this sql probably: SELECT action_hash, block_hash, timestamp, action_type, from, to, amount, gas_price*gas_consumed FROM action_history AS t1 LEFT JOIN (SELECT block_height,block_hash,timestampFROM block_history) t2 ON t1.block_height=t2.block_height WHERE action_type ='execution' ORDER BYtimestamp DESC limit 0,2