[check_postgres] [commit] Wrong order by.

[check_postgres at bucardo.org]

Committed by Greg Sabino Mullane <greg at endpoint.com>

Wrong order by.

---
 check_postgres.pl |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/check_postgres.pl b/check_postgres.pl
index 6f1324b..5f76740 100755
--- a/check_postgres.pl
+++ b/check_postgres.pl
@@ -1881,7 +1881,7 @@ sub check_last_vacuum_analyze {
 	$SQL = q{SELECT nspname, relname, CASE WHEN v IS NULL THEN -1 ELSE round(extract(epoch FROM now()-v)) END, }
 		   .qq{ CASE WHEN v IS NULL THEN '?' ELSE TO_CHAR(v, '$SHOWTIME') END FROM (}
 		   .qq{SELECT nspname, relname, $criteria AS v FROM pg_class c, pg_namespace n }
-		   .q{WHERE relkind = 'r' AND n.oid = c.relnamespace ORDER BY 2) AS foo};
+		   .q{WHERE relkind = 'r' AND n.oid = c.relnamespace ORDER BY 3) AS foo};
 	if ($opt{perflimit}) {
 		$SQL .= " ORDER BY 3 DESC LIMIT $opt{perflimit}";
 	}
-- 
1.5.5.4