On 09/11/2021 04:45, Roman Simakov wrote: > Hello! > > There are 2 threads: PSQL profiler and SQL profiler. I've decided to > continue here) > > It seems to me that profiling only the same attachment is not as > useful as it could be. > Imagine a working application. It's ready but you want to know where > it spends time. You attach to the server by profiler and run profiling > session in *your* attachment but specifying the attachment ID of the > target. Then you run a command in the application and see collected > data in the profiling attachment. Like the trace does where you can > trace any activity. >
Currently it's only possible via database triggers making others attachments start they own sessions. > It would be nice to have it implemented. > Agree. Please note I'm refactoring the profiler branch, making it via a plugin. But a thing didn't changed. There could only be a single active profile session per attachment. When profiling others attachment it's not clear for me if multiple active sessions per attachment should be allowed or if the remote session should count as active session for the initiator or the being profiled attachment. Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
