Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT CAST([TimeStamp] AS DATE) AS series_date, COUNT(*) AS series_value
            FROM dbo.Messages
            WHERE [TimeStamp] >= DATEADD(DAY, -30, CAST(GETDATE() AS DATE))
              AND Role NOT IN ('system')
              AND [TimeStamp] IS NOT NULL
            GROUP BY CAST([TimeStamp] AS DATE)
            ORDER BY series_date ASC

[]

SELECT
  CAST([TimeStamp] AS DATE) AS series_date,
  COUNT(*) AS series_value
FROM
  dbo.Messages
WHERE
  [TimeStamp] >= DATEADD(
    DAY,
    -30,
    CAST(
      GETDATE() AS DATE
    )
  )
  AND Role NOT IN ('system')
  AND [TimeStamp] IS NOT NULL
GROUP BY
  CAST([TimeStamp] AS DATE)
ORDER BY
  series_date ASC

SELECT CAST([TimeStamp] AS DATE) AS series_date, COUNT(*) AS series_value
            FROM dbo.Messages
            WHERE [TimeStamp] >= DATEADD(DAY, -30, CAST(GETDATE() AS DATE))
              AND Role NOT IN ('system')
              AND [TimeStamp] IS NOT NULL
            GROUP BY CAST([TimeStamp] AS DATE)
            ORDER BY series_date ASC
        ;