Large database results in long data loading on frontend

SELECT 
  e.id, 
  e.name, 
  e.category,
  SUM(ed.totalRevenue) as totalRevenue,
  SUM(ed.totalTicketsSold) as totalTicketsSold,
  AVG(ed.avgTicketPrice) as avgTicketPrice
FROM 
  "Events" e
JOIN 
  "EventData" ed ON e.id = ed."eventId"
WHERE 
  ed.eventDate >= CURRENT_DATE - INTERVAL :daysAgo DAY
GROUP BY 
  e.id, e.name, e.category
HAVING 
  SUM(ed.totalRevenue) BETWEEN :minRevenue AND :maxRevenue
ORDER BY 
  SUM(ed.totalRevenue) DESC

SELECT 
  e.id, 
  e.name, 
  e.category,
  SUM(ed.totalRevenue) as totalRevenue,
  SUM(ed.totalTicketsSold) as totalTicketsSold,
  AVG(ed.avgTicketPrice) as avgTicketPrice
FROM 
  "Events" e
JOIN 
  "EventData" ed ON e.id = ed."eventId"
WHERE 
  ed.eventDate >= CURRENT_DATE - INTERVAL :daysAgo DAY
GROUP BY 
  e.id, e.name, e.category
HAVING 
  SUM(ed.totalRevenue) BETWEEN :minRevenue AND :maxRevenue
ORDER BY 
  SUM(ed.totalRevenue) DESC

prisma generate --sql

prisma generate --sql

import { PrismaClient } from '@prisma/client'
import { getEventMetrics } from '@prisma/client/sql'

const prisma = new PrismaClient()

const result = await prisma.$queryRawTyped(getEventMetrics({
  daysAgo: 30,
  minRevenue: 1000,
  maxRevenue: 5000
}))

console.log(result)

import { PrismaClient } from '@prisma/client'
import { getEventMetrics } from '@prisma/client/sql'

const prisma = new PrismaClient()

const result = await prisma.$queryRawTyped(getEventMetrics({
  daysAgo: 30,
  minRevenue: 1000,
  maxRevenue: 5000
}))

console.log(result)

job dataJob {
  executor: PgBoss,
  perform: {
    fn: import { dataJobfn } from "@src/workers/dataJob"
  },
  entities: [Data,Aggregates,Prods],

  schedule: {
    cron: "40 22 * * *",
  }
}

job dataJob {
  executor: PgBoss,
  perform: {
    fn: import { dataJobfn } from "@src/workers/dataJob"
  },
  entities: [Data,Aggregates,Prods],

  schedule: {
    cron: "40 22 * * *",
  }
}