Advanced Search

Return to Snippet

Revision: 54497
at December 30, 2011 01:26 by limepix
Initial Code 
grep "Dauer:" /path/to/postgres.log | sort -nr -k 5 | head -100 | less
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
maybe you must replace "Dauer" with the correct spelling in your logging language (i´ve done this on a german system).
also make sure, that the duration (the value in ms) column is the 5th one in your log file.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
show longest queries in postgres log

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
Bash