Hi Vikas. Can you please share the video where you have explained how to create a table and populate the table in postgres for dashboard making. Thank you
@jamakhtar89
2 жыл бұрын
Nice and simple...Can u show how to monitor postgres database down or not ???
@ahlamsaeed498
2 жыл бұрын
am facing with this error "db query error: failed to connect to server - please inspect Grafana server log for details" please help???
@giyama
Жыл бұрын
Thanks for sharing man!
@VikasJha001
Жыл бұрын
Glad it helped.
@nishasati8249
7 ай бұрын
Hello. Your video is providing lot of details. Thanku for sharing. How can i use PostgresSQL as grafana Backup (for dashboards and other configurations)?
@franciscoborges9426
5 ай бұрын
Thank you Vikas
@Mr.Equinox
3 жыл бұрын
That's awesome
@VikasJha001
3 жыл бұрын
Thanks.
@shubhanshis2138
2 жыл бұрын
Can you please share another video to connect Kibana with PostgreSQL
@GeorgeFoto1
2 жыл бұрын
Hello there, congrats on your video. Is it possible to monitor memory usage for Postgres while applying queries on full-text search ? Also monitor memory on insertion time ?
@abhisekchowdhury8584
3 жыл бұрын
How to run custom query with joins and CTEs ? And can we create read only login accounts?
@muhammadkhajehpour6526
2 жыл бұрын
hi is there any tools to monitor postgresql metadata like how much each query is taking? or how much time does each query take? or how much of the system resources are given to a specific postgresql user? things like this.. and tnx for the video :)
@VikasJha001
2 жыл бұрын
I would have to explore on this as well. Will update this comment if I find a solution for this.
@learnvik
2 жыл бұрын
thanks, can we connect grafana to s3 and cloudwatch logs for creating dashboards? is there a way we can also troubleshoot the issue in case a batch/application fails ? can we directly go to the root of the issue using grafana ?
@shabuddinshaik1478
Жыл бұрын
How to set alerts for postgres number of connection for specific schema
@vivekmishra9693
3 жыл бұрын
How to make it live with cloud redshift db / postgre (with reduced columns)? from where i initiate data feed
@annie_makkx
3 жыл бұрын
Thnx
@VikasJha001
3 жыл бұрын
Glad it helped.
@eavenhuang7419
Ай бұрын
I have PSQL for my ticketing system, how can I know what port is needed and what DB is used? What user account and permission is needed to connect to Grafana?
@VikasJha001
Ай бұрын
Typically these details are known from the DB guys who have setup the database. Or if it's out of the box DB of some application, then you can see the documentation of that app to know these details. Select on Tables and Views permissions are enough to setup the connection with the database.
@eavenhuang7419
Ай бұрын
@@VikasJha001 thanks alot!! I will need to check further on our side:)
@qbnetrix1847
3 жыл бұрын
HI Vikas. What will be the query to display the transaction rate of a PostgreSQl database ? reat Video btw, keep up the good work.
@paldavidi5098
8 ай бұрын
Hello, I'm creating a dashboard database using Postgres Exporter, Prometheus, and Grafana. But it seems the database is not connected to the grafana dashboard because there is no data and the database not appear on dashboard. Then i check Prometheus, there is no query for pg_stat? The only queries available are pg_exporter_last_scrape_duration_seconds, pg_up, pg_exporter_last_scrape_error, pg_exporter_scrapes_total. So basically, I'm missing some metrics from the PostgreSQL exporter. Can you help me on how to resolve this? Thank you.
@JosephHeady
7 ай бұрын
When trying to connect grafana to postgres database on digital Ocean... grafana listed 209 ip addresses to whitelist. Problem is digital Ocean has a 200 max ip limit.. so it is not letting me connect. Any idea what I can do to fix the issue?
@anandkumarmaurya2757
3 жыл бұрын
what is datatype for creating table in postgres database for time column?
@VikasJha001
3 жыл бұрын
It auto guesses best data type, If you want custom datatype then please create the table in database with the correct datatype before loading the data.
@sweety98628
2 жыл бұрын
when i select table in grafana,it showing no data in grafana.can anyone pls tell me what's the problem.
@ranimkayali2333
2 жыл бұрын
Hello I connected grafana with postgresql but I didn't get a result to show the data with grafana. I don't know which is problem??
@siddharthagrawal4280
3 жыл бұрын
can we connect grafana with mongodb or firebase? any NOSQL dbs??
@aviralsingh6382
2 жыл бұрын
Can we analyse the logs of postgres in grafana.
@VikasJha001
2 жыл бұрын
For log monitoring you probably should use Loki
@VikasJha001
Жыл бұрын
You can see Loki Tutorial here kzitem.info/news/bejne/2Wir2Y6Mi6CJfmk
@nithinl1059
Жыл бұрын
How share grafana dashboard in windows settings it some tricky
@devops__guy8909
2 жыл бұрын
@vikasjha SELECT pid, now() - pg_stat_activity.query_start AS duration, query, state FROM pg_stat_activity WHERE (now() - pg_stat_activity.query_start) > interval '3 minutes'; This command shows the list of queries thats running for more than 3 mins. it has a WHERE part which is not working in Grafana. is it just me or you too can't run this query(with WHERE)?? is it a bug or How do I make this command work in my Grafana?
@shivamgarg7761
3 жыл бұрын
Thanks sir
@VikasJha001
2 жыл бұрын
Welcome
@therus000
3 жыл бұрын
I got a question about variable in influx i got 4 servers and 2 environment dev and test I could make a variable for environment to chose by this code : import "influxdata/influxdb/schema" schema.tagValues(bucket: "postgresql", tag: "env") But couldn't make an environment to choose a server. i tru this but it not work: import "influxdata/influxdb/schema" from(bucket: "postgresql") |> range(start: -30d) |> filter(fn: (r) => r["env"] == v.pg_env ) |> keep(columns: ["server"]) can you help?
@lakshmidasari9817
2 жыл бұрын
How to create bar charts
@VikasJha001
2 жыл бұрын
try following examples of bar charts on play.grafana.org/d/000000012/grafana-play-home?orgId=1
@gouravbhati23
Жыл бұрын
Hey i want to add something else in grafana can we connect on LinkedIn ???
Пікірлер: 43