Database growth dashboard

[skiz79]

Hello,

I am trying to create a simple dashboard to show database growth trend. I am using the below table to graph but not able to. Any suggestions?

 datname       | datsize |  dbgrowth  | dbgrowthpercent |   tdate    

----------------------------±-------------------±--------±-----------±----------------±-----------
postgres | 8774511 | (null) | (null) | 2022-03-23
test_cat | 9839471 | (null) | (null) | 2022-03-23
postgres | 8782703 | 8192 bytes | 0.093361326 2022-03-23
postgres | 8823663 | 40 kB | 0.46637124 | 2022-03-24
test_cat | 9847663 | 8192 bytes | 0.083256505 2022-03-28

[Vadim_Yalovets]

Hi @skiz79

Have you tried to create a query by using “Query Builder”?

e.g.

[skiz79]

Thanks for your response.
So i was able to provide the query but i am not sure why it’s converting datsize (8192 bytes) to Mil. any idea how to change the unit?

[Vadim_Yalovets]

@skiz79

i am not sure why it’s converting datsize (8192 bytes) to Mil. any idea how to change the unit?

You may set the correct unit for a panel on the tab “Field”.