Collection: execution_logs
Fields:
  - userId: Ascending
  - executedAt: Descending
Query Scope: Collection

firebase firestore:indexes:create \
  --collection-group=execution_logs \
  --field-name=userId \
  --order-by=userId:ascending \
  --field-name=executedAt \
  --order-by=executedAt:descending

Collection: execution_logs
Fields:
  - marketId: Ascending
  - executedAt: Descending
Query Scope: Collection

Collection: execution_logs
Fields:
  - orderType: Ascending
  - success: Ascending
  - executedAt: Descending
Query Scope: Collection

{
  "indexes": [
    {
      "collectionGroup": "execution_logs",
      "queryScope": "COLLECTION",
      "fields": [
        {
          "fieldPath": "userId",
          "order": "ASCENDING"
        },
        {
          "fieldPath": "executedAt",
          "order": "DESCENDING"
        }
      ]
    },
    {
      "collectionGroup": "execution_logs",
      "queryScope": "COLLECTION",
      "fields": [
        {
          "fieldPath": "marketId",
          "order": "ASCENDING"
        },
        {
          "fieldPath": "executedAt",
          "order": "DESCENDING"
        }
      ]
    },
    {
      "collectionGroup": "execution_logs",
      "queryScope": "COLLECTION",
      "fields": [
        {
          "fieldPath": "orderType",
          "order": "ASCENDING"
        },
        {
          "fieldPath": "success",
          "order": "ASCENDING"
        },
        {
          "fieldPath": "executedAt",
          "order": "DESCENDING"
        }
      ]
    }
  ],
  "fieldOverrides": []
}

firebase deploy --only firestore:indexes

firebase deploy --only firestore

const executions = await db.collection('execution_logs')
  .where('userId', '==', '0x...')
  .orderBy('executedAt', 'desc')
  .limit(20)
  .get();

const failures = await db.collection('execution_logs')
  .where('success', '==', false)
  .orderBy('executedAt', 'desc')
  .limit(50)
  .get();

const limitOrders = await db.collection('execution_logs')
  .where('orderType', '==', 'limit')
  .orderBy('executedAt', 'desc')
  .get();

const oneDayAgo = Date.now() - 86400000;
const stats = await db.collection('execution_logs')
  .where('executedAt', '>', oneDayAgo)
  .get();

const counts = {
  limit: 0,
  take_profit: 0,
  stop_loss: 0,
  trailing_stop_loss: 0,
  tsl_update: 0,
};

stats.forEach(doc => {
  const type = doc.data().orderType;
  counts[type] = (counts[type] || 0) + 1;
});

console.log('Executions (24h):', counts);

const allLogs = await db.collection('execution_logs')
  .orderBy('executedAt', 'desc')
  .limit(1000)
  .get();

const stats: Record<string, { total: number; successful: number }> = {};

allLogs.forEach(doc => {
  const { orderType, success } = doc.data();
  if (!stats[orderType]) stats[orderType] = { total: 0, successful: 0 };
  stats[orderType].total++;
  if (success) stats[orderType].successful++;
});

Object.entries(stats).forEach(([type, data]) => {
  const rate = (data.successful / data.total * 100).toFixed(1);
  console.log(`${type}: ${rate}% success (${data.successful}/${data.total})`);
});