The first PostgreSQL query of each request is always slow

[balthild]

Screenshot of Laravel Telescope:

No matter what is queried, the query is slow as long as it is the first one.

The database is at localhost. I tried changing DB_HOST to 127.0.0.1 to avoid DNS resolution, but it doesn't help.

I also tried using PgBouncer (a connection pool) to proxy the connection, and it doesn't help either.

Environment

• OS: Both Windows and Debian
• Laravel: 10.10
• PHP: 8.2
• PostgreSQL: 16

[balthild]

Laravel Octane solved this problem.