Ben Davies

```sql SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_15 FROM (SELECT p0_.run_id AS run_id_0, p0_.attempt AS attempt_1, p0_.message_type AS message_type_2, p0_.description AS description_3, p0_.dispatched_at AS dispatched_at_4, p0_.received_at AS received_at_5, p0_.finished_at...

that comes from [here](https://github.com/zenstruck/messenger-monitor-bundle/blob/1.x/templates/history.html.twig#L134) so OutputWalkers need to be disabled here for CountOutputWalker to not be used.

> > these can be sped up with an index on failure_type and changing COUNT(p0_.finished_at) to COUNT(*) > > I feel like there was a problem using `COUNT(*)` but I'll...

And just thought that this could quite easily be extended to store an average per message type.

> > these can be sped up with an index on failure_type and changing COUNT(p0_.finished_at) to COUNT(*) > > I feel like there was a problem using `COUNT(*)` but I'll...

> > We can store and calculate a cumulative average. > > What about the "period" averages/counts? I forgot about those. it's certainly possible. We could store averages aggregated per...

would it not be easier to just support raw PDO queries if users want to write more complex queries?

if anyone is wondering, [`aeon-php/calendar`](https://github.com/aeon-php/calendar) handles this correctly ```php

futhermore, [`azjezz/psl`](https://github.com/azjezz/psl/) handles this "correctly" ```php use Psl\DateTime\DateTime; use Psl\DateTime\FormatPattern; use Psl\DateTime\Timezone; $x = DateTime::parse('2025-03-30 01:30:00', FormatPattern::SqlDateTime, timezone: Timezone::EuropePrague); $a = $x->plusMinutes(50); $b = $x->plusMinutes(100); var_dump( $x->format(FormatPattern::SqlDateTime), $a->format(FormatPattern::SqlDateTime), $b->format(FormatPattern::SqlDateTime), );...

This appears to be because the `plugins` provided here override the default ones (`virtual_scroll`) during the config merge: https://github.com/symfony/ux-autocomplete/blob/6a1851b8ed5e51c0a285728b0e51522e62ae6fdd/assets/src/controller.ts#L172