Function cases

scripts/verify-index-impact.ts:181–219

(samplePubkey: Buffer)

}

function cases(samplePubkey: Buffer): BenchmarkCase[] {
  const now = Math.floor(Date.now() / 1000)
  const sevenDaysAgo = now - 7 * 86400
  return [
    {
      // Shape matches EventRepository.findByFilters exactly.
      name: 'REQ authors+kind ORDER BY created_at DESC LIMIT 500',
      sql: `SELECT event_id FROM events
            WHERE event_pubkey = $1 AND event_kind = ANY($2::int[])
            ORDER BY event_created_at DESC, event_id ASC LIMIT 500`,
      params: [samplePubkey, [1]],
    },
    {
      // This is the only hot path that filters on deleted_at in production.
      name: 'hasActiveRequestToVanish (pubkey + kind=62)',
      sql: `SELECT event_id FROM events
            WHERE event_pubkey = $1 AND event_kind = 62 AND deleted_at IS NULL LIMIT 1`,
      params: [samplePubkey],
    },
    {
      name: 'Purge scan: soft-deleted rows',
      sql: `SELECT event_id FROM events WHERE deleted_at IS NOT NULL LIMIT 500`,
      params: [],
    },
    {
      // Shape matches InvoiceRepository.findPendingInvoices exactly.
      name: 'findPendingInvoices ORDER BY created_at',
      sql: `SELECT id FROM invoices WHERE status = 'pending' ORDER BY created_at ASC OFFSET 0 LIMIT 500`,
      params: [],
    },
    {
      name: 'REQ kind + time range ORDER BY created_at DESC LIMIT 500',
      sql: `SELECT event_id FROM events
            WHERE event_kind = 1 AND event_created_at BETWEEN $1 AND $2
            ORDER BY event_created_at DESC, event_id ASC LIMIT 500`,
      params: [sevenDaysAgo, now],
    },
  ]
}

async function explain(sql: string, params: unknown[]): Promise<ExplainResult> {
  const { rows } = await client.query<{ 'QUERY PLAN': ExplainResult[] }>(