NixOS / hydra

Hydra, the Nix-based continuous build system
http://nixos.org/hydra
GNU General Public License v3.0
1.1k stars 291 forks source link

foreman/start-hydra: enable query log in postgres #1371

Closed Ma27 closed 2 months ago

Ma27 commented 3 months ago

That way it's possible to observe which queries are fired against the DB from DBIx. This is particularly useful to find out if DBIx correctly prefetches everything it needs or if too much / too few things are loaded, see e.g. #1335.

delroth commented 2 months ago

Another way (what I've been doing) is DBIC_TRACE=1 in the environment variables when starting the Perl server. Maybe better?

Ma27 commented 2 months ago

Oh yes it is, TIL!