From 0ec808a5db04d641f08ded1a3dc34ed0a0e509cf Mon Sep 17 00:00:00 2001
From: Darold Gilles <gilles@darold.net>
Date: Sun, 1 Dec 2013 23:47:21 +0100
Subject: [PATCH] Fix wrong timestamps saved with top queries. Thanks to Herve
 Werner for the report.

---
 pgbadger | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/pgbadger b/pgbadger
index b051572..e6af1b6 100755
--- a/pgbadger
+++ b/pgbadger
@@ -7994,7 +7994,7 @@ sub store_queries
 				$normalyzed_info{$normalized}{chronos}{"$cur_day_str"}{"$cur_hour_str"}{duration} += $cur_info{$t_pid}{duration};
 
 				# Store normalized query samples
-				&set_top_sample($normalized, $cur_info{$t_pid}{query}, $cur_info{$t_pid}{duration}, $overall_stat{'last_log_ts'},$cur_info{$t_pid}{dbname}, $cur_info{$t_pid}{dbuser}, $cur_info{$t_pid}{dbclient},$cur_info{$t_pid}{dbappname});
+				&set_top_sample($normalized, $cur_info{$t_pid}{query}, $cur_info{$t_pid}{duration}, $cur_last_log_timestamp, $cur_info{$t_pid}{dbname}, $cur_info{$t_pid}{dbuser}, $cur_info{$t_pid}{dbclient},$cur_info{$t_pid}{dbappname});
 			}
 		}
 	}
-- 
2.40.0