powa-team / powa

PostgreSQL Workload Analyzer
http://powa.readthedocs.io/
PostgreSQL License
764 stars 57 forks source link

Empty details for database section #19

Closed Victor-D closed 9 years ago

Victor-D commented 9 years ago

Hi,

pg_stats_collector is activated and configured. powa seems well installed and the graphics show data collected.

Nevertheless the details for database dbxxx is empty.

Same behavior for all databases.

Regards,

rjuju commented 9 years ago

Hi,

I don't understand your problem. What graphics show you data collected ?

Victor-D commented 9 years ago

Here is a screenshot :

sc1

rjuju commented 9 years ago

Do you still have the issue after downgrading Mojolicious to 4.75 ?

And are you using the release 1.1 of powa ?

Victor-D commented 9 years ago

Yes, and I use the version of powa released this morning.

sc2

rjuju commented 9 years ago

We only released versions 1.0 and 1.1. Current git version is still in development and should not be used except for testing. However on current HEAD, the query detail is available.

Does the log show you some errors when displaying this page, more precisely in Statements.pm between lines 68 and 98 ?

Victor-D commented 9 years ago

I see no error in warn level.

I will install the 1.1 version tomorow and let you know.

Victor-D commented 9 years ago

I was already using REL_1.1

rjuju commented 9 years ago

What does the following query show you (on database powa)?

select count(*) from powa_getstatdata_db('2014-08-28 15:26:18','2014-08-28 16:28:18','intranetpreprod');

rjuju commented 9 years ago

Hi,

Any news on this issue ?