Some queries take 7s!

[vikiival]

duration: 6440.601 ms execute <unnamed>:

  SELECT DISTINCT ne.id AS id,
                ne.name AS name,
                ne.issuer AS issuer,
                ne.metadata AS metadata,
                e.current_owner,
                me.image AS image,
                me.animation_url,
                MAX(e.timestamp) AS timestamp,
                MAX(e.meta::decimal) AS value,
                ne.collection_id AS collection_id,
                ce.name AS collection_name
  FROM event e
  JOIN nft_entity ne ON e.nft_id = ne.id
  LEFT JOIN metadata_entity me ON me.id = ne.metadata
  LEFT JOIN collection_entity ce ON ne.collection_id = ce.id
  WHERE e.interaction = $1
    AND ne.burned = FALSE

  GROUP BY ne.id,
          me.id,
          e.current_owner,
          me.image,
          ce.name
  ORDER BY MAX(e.timestamp) DESC
  LIMIT $2
  OFFSET $3

 {"detail":"parameters: $1 = 'LIST', $2 = '8', $3 = '0'"}

[vikiival]

cc @Matehoo

[vikiival]

So refactoring async lastEvent resolver:

Query should be:

Return last n events where interaction = ineraction
and NFT cannot be burned

Ideally check lastNftListByEvent on kodadot/nft-gallery for usage

[roiLeo]

maybe check if e.interaction is indexed (timestamp too?)