I'm running 7.3.4. Is there anyway to see the actual sql being run by the database via a query? I am having some problems with long running load causing querires from our reporting system. I have sql logging turned on to log the sql statements to my postgres.log file. However, these reporting queries do not appear to be logging the entire query. I am only getting the select clause (and I'm not sure if it's all of it) but no from or where clause.
Can I pull these queries out from postgres? Thanks, Chris ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
