Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

316.37 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

ki_management connection

Time▼

Count

Info

90.36 ms
(28.56%)

SELECT
                (SELECT COUNT(*)
                 FROM dbo.Messages
                 WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))
                   AND Role NOT IN ('system')
                   AND [TimeStamp] IS NOT NULL
                ) AS total_messages,

                (SELECT COUNT(*)
                 FROM dbo.Sessions
                 WHERE CreatedAt >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))
                ) AS total_sessions,

                (SELECT ISNULL(SUM(Tokens), 0)
                 FROM dbo.Messages
                 WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))
                   AND Role NOT IN ('system')
                   AND [TimeStamp] IS NOT NULL
                ) AS total_tokens,

                (SELECT ISNULL(AVG(CAST(msg_count AS FLOAT)), 0)
                 FROM (
                     SELECT SessionId, COUNT(*) AS msg_count
                     FROM dbo.Messages
                     WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))
                       AND Role NOT IN ('system')
                       AND SessionId IS NOT NULL
                     GROUP BY SessionId
                 ) t
                ) AS avg_msgs_per_session,

                (SELECT ISNULL(AVG(CAST(tok_sum AS FLOAT)), 0)
                 FROM (
                     SELECT SessionId, SUM(Tokens) AS tok_sum
                     FROM dbo.Messages
                     WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))
                       AND Role NOT IN ('system')
                       AND SessionId IS NOT NULL
                     GROUP BY SessionId
                 ) t
                ) AS avg_tokens_per_session

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  (
    SELECT
      COUNT(*)
    FROM
      dbo.Messages
    WHERE
      [TimeStamp] >= DATEADD(
        MONTH,
        -12,
        CAST(
          GETDATE() AS DATE
        )
      )
      AND Role NOT IN ('system')
      AND [TimeStamp] IS NOT NULL
  ) AS total_messages,
  (
    SELECT
      COUNT(*)
    FROM
      dbo.Sessions
    WHERE
      CreatedAt >= DATEADD(
        MONTH,
        -12,
        CAST(
          GETDATE() AS DATE
        )
      )
  ) AS total_sessions,
  (
    SELECT
      ISNULL(
        SUM(Tokens),
        0
      )
    FROM
      dbo.Messages
    WHERE
      [TimeStamp] >= DATEADD(
        MONTH,
        -12,
        CAST(
          GETDATE() AS DATE
        )
      )
      AND Role NOT IN ('system')
      AND [TimeStamp] IS NOT NULL
  ) AS total_tokens,
  (
    SELECT
      ISNULL(
        AVG(
          CAST(msg_count AS FLOAT)
        ),
        0
      )
    FROM
      (
        SELECT
          SessionId,
          COUNT(*) AS msg_count
        FROM
          dbo.Messages
        WHERE
          [TimeStamp] >= DATEADD(
            MONTH,
            -12,
            CAST(
              GETDATE() AS DATE
            )
          )
          AND Role NOT IN ('system')
          AND SessionId IS NOT NULL
        GROUP BY
          SessionId
      ) t
  ) AS avg_msgs_per_session,
  (
    SELECT
      ISNULL(
        AVG(
          CAST(tok_sum AS FLOAT)
        ),
        0
      )
    FROM
      (
        SELECT
          SessionId,
          SUM(Tokens) AS tok_sum
        FROM
          dbo.Messages
        WHERE
          [TimeStamp] >= DATEADD(
            MONTH,
            -12,
            CAST(
              GETDATE() AS DATE
            )
          )
          AND Role NOT IN ('system')
          AND SessionId IS NOT NULL
        GROUP BY
          SessionId
      ) t
  ) AS avg_tokens_per_session

SELECT
                (SELECT COUNT(*)
                 FROM dbo.Messages
                 WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))
                   AND Role NOT IN ('system')
                   AND [TimeStamp] IS NOT NULL
                ) AS total_messages,

                (SELECT COUNT(*)
                 FROM dbo.Sessions
                 WHERE CreatedAt >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))
                ) AS total_sessions,

                (SELECT ISNULL(SUM(Tokens), 0)
                 FROM dbo.Messages
                 WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))
                   AND Role NOT IN ('system')
                   AND [TimeStamp] IS NOT NULL
                ) AS total_tokens,

                (SELECT ISNULL(AVG(CAST(msg_count AS FLOAT)), 0)
                 FROM (
                     SELECT SessionId, COUNT(*) AS msg_count
                     FROM dbo.Messages
                     WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))
                       AND Role NOT IN ('system')
                       AND SessionId IS NOT NULL
                     GROUP BY SessionId
                 ) t
                ) AS avg_msgs_per_session,

                (SELECT ISNULL(AVG(CAST(tok_sum AS FLOAT)), 0)
                 FROM (
                     SELECT SessionId, SUM(Tokens) AS tok_sum
                     FROM dbo.Messages
                     WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))
                       AND Role NOT IN ('system')
                       AND SessionId IS NOT NULL
                     GROUP BY SessionId
                 ) t
                ) AS avg_tokens_per_session
        ;

#	File/Call
1	App\KIManagement\Service\StatisticsService->getSummaryStats (line 63)
2	App\Controller\StatisticsController->index (line 25)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 191)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 5)

61.48 ms
(19.43%)

SELECT DATEFROMPARTS(YEAR([TimeStamp]), MONTH([TimeStamp]), 1) AS period, ISNULL(SUM(Tokens), 0) AS period_value
            FROM dbo.Messages
            WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE)) AND Role NOT IN ('system') AND [TimeStamp] IS NOT NULL
            GROUP BY DATEFROMPARTS(YEAR([TimeStamp]), MONTH([TimeStamp]), 1)
            ORDER BY period ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DATEFROMPARTS(
    YEAR([TimeStamp]),
    MONTH([TimeStamp]),
    1
  ) AS period,
  ISNULL(
    SUM(Tokens),
    0
  ) AS period_value
FROM
  dbo.Messages
WHERE
  [TimeStamp] >= DATEADD(
    MONTH,
    -12,
    CAST(
      GETDATE() AS DATE
    )
  )
  AND Role NOT IN ('system')
  AND [TimeStamp] IS NOT NULL
GROUP BY
  DATEFROMPARTS(
    YEAR([TimeStamp]),
    MONTH([TimeStamp]),
    1
  )
ORDER BY
  period ASC

SELECT DATEFROMPARTS(YEAR([TimeStamp]), MONTH([TimeStamp]), 1) AS period, ISNULL(SUM(Tokens), 0) AS period_value
            FROM dbo.Messages
            WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE)) AND Role NOT IN ('system') AND [TimeStamp] IS NOT NULL
            GROUP BY DATEFROMPARTS(YEAR([TimeStamp]), MONTH([TimeStamp]), 1)
            ORDER BY period ASC
        ;

#	File/Call
1	App\KIManagement\Service\StatisticsService->buildSeries (line 251)
2	App\KIManagement\Service\StatisticsService->getTokenConsumption (line 158)
3	App\Controller\StatisticsController->index (line 28)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 191)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

60.10 ms
(19.00%)

SELECT DATEFROMPARTS(YEAR([TimeStamp]), MONTH([TimeStamp]), 1) AS period, COUNT(*) AS period_value
            FROM dbo.Messages
            WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE)) AND Role NOT IN ('system') AND [TimeStamp] IS NOT NULL
            GROUP BY DATEFROMPARTS(YEAR([TimeStamp]), MONTH([TimeStamp]), 1)
            ORDER BY period ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DATEFROMPARTS(
    YEAR([TimeStamp]),
    MONTH([TimeStamp]),
    1
  ) AS period,
  COUNT(*) AS period_value
FROM
  dbo.Messages
WHERE
  [TimeStamp] >= DATEADD(
    MONTH,
    -12,
    CAST(
      GETDATE() AS DATE
    )
  )
  AND Role NOT IN ('system')
  AND [TimeStamp] IS NOT NULL
GROUP BY
  DATEFROMPARTS(
    YEAR([TimeStamp]),
    MONTH([TimeStamp]),
    1
  )
ORDER BY
  period ASC

SELECT DATEFROMPARTS(YEAR([TimeStamp]), MONTH([TimeStamp]), 1) AS period, COUNT(*) AS period_value
            FROM dbo.Messages
            WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE)) AND Role NOT IN ('system') AND [TimeStamp] IS NOT NULL
            GROUP BY DATEFROMPARTS(YEAR([TimeStamp]), MONTH([TimeStamp]), 1)
            ORDER BY period ASC
        ;

#	File/Call
1	App\KIManagement\Service\StatisticsService->buildSeries (line 251)
2	App\KIManagement\Service\StatisticsService->getMessageCounts (line 132)
3	App\Controller\StatisticsController->index (line 26)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 191)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

56.93 ms
(17.99%)

SELECT DATEPART(HOUR, [TimeStamp]) AS hour_of_day, COUNT(*) AS msg_count
            FROM dbo.Messages
            WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))
              AND Role NOT IN ('system')
              AND [TimeStamp] IS NOT NULL
            GROUP BY DATEPART(HOUR, [TimeStamp])
            ORDER BY hour_of_day ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DATEPART(HOUR, [TimeStamp]) AS hour_of_day,
  COUNT(*) AS msg_count
FROM
  dbo.Messages
WHERE
  [TimeStamp] >= DATEADD(
    MONTH,
    -12,
    CAST(
      GETDATE() AS DATE
    )
  )
  AND Role NOT IN ('system')
  AND [TimeStamp] IS NOT NULL
GROUP BY
  DATEPART(HOUR, [TimeStamp])
ORDER BY
  hour_of_day ASC

SELECT DATEPART(HOUR, [TimeStamp]) AS hour_of_day, COUNT(*) AS msg_count
            FROM dbo.Messages
            WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))
              AND Role NOT IN ('system')
              AND [TimeStamp] IS NOT NULL
            GROUP BY DATEPART(HOUR, [TimeStamp])
            ORDER BY hour_of_day ASC
        ;

#	File/Call
1	App\KIManagement\Service\StatisticsService->getHourlyMessageDistribution (line 178)
2	App\Controller\StatisticsController->index (line 29)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 191)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 5)

47.51 ms
(15.02%)

SELECT DATEFROMPARTS(YEAR(CreatedAt), MONTH(CreatedAt), 1) AS period, COUNT(*) AS period_value
            FROM dbo.Sessions
            WHERE CreatedAt >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE)) AND 1=1
            GROUP BY DATEFROMPARTS(YEAR(CreatedAt), MONTH(CreatedAt), 1)
            ORDER BY period ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DATEFROMPARTS(
    YEAR(CreatedAt),
    MONTH(CreatedAt),
    1
  ) AS period,
  COUNT(*) AS period_value
FROM
  dbo.Sessions
WHERE
  CreatedAt >= DATEADD(
    MONTH,
    -12,
    CAST(
      GETDATE() AS DATE
    )
  )
  AND 1 = 1
GROUP BY
  DATEFROMPARTS(
    YEAR(CreatedAt),
    MONTH(CreatedAt),
    1
  )
ORDER BY
  period ASC

SELECT DATEFROMPARTS(YEAR(CreatedAt), MONTH(CreatedAt), 1) AS period, COUNT(*) AS period_value
            FROM dbo.Sessions
            WHERE CreatedAt >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE)) AND 1=1
            GROUP BY DATEFROMPARTS(YEAR(CreatedAt), MONTH(CreatedAt), 1)
            ORDER BY period ASC
        ;

#	File/Call
1	App\KIManagement\Service\StatisticsService->buildSeries (line 251)
2	App\KIManagement\Service\StatisticsService->getSessionCounts (line 145)
3	App\Controller\StatisticsController->index (line 27)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 191)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
ki_management	doctrine.dbal.ki_management_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
management	doctrine.orm.management_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

management entity manager

Class	Amount of managed objects

Symfony Profiler

GET https://ai-analytics-tool.staging.webwerk.at/statistiken

Query Metrics

Grouped Statements

ki_management connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

management entity manager

Entities Mapping

default entity manager

management entity manager

Symfony Profiler

GET https://ai-analytics-tool.staging.webwerk.at/statistiken

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

ki_management connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

management entity manager

Entities Mapping

default entity manager

management entity manager