# How to use pmm2 dashboards & exporter in our existing grafana & Prometheus setup **URL:** \ **Category:** PMM 2.x\ **Tags:** dashboard, grafana, pmm\ **Created:** [April 15, 2020, 1:53pm UTC](https://forums.percona.com/t/how-to-use-pmm2-dashboards-exporter-in-our-existing-grafana-prometheus-setup/7539 "2020-04-15T13:53:25Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![jaiswalvinny9](https://avatars.discourse-cdn.com/v4/letter/j/c67d28/32.png) [@jaiswalvinny9](https://forums.percona.com/u/jaiswalvinny9)\ **Post date:** [April 15, 2020, 1:53pm UTC](https://forums.percona.com/t/how-to-use-pmm2-dashboards-exporter-in-our-existing-grafana-prometheus-setup/7539/1 "2020-04-15T13:53:25Z")
Hi ,  i have a centralised grafana dashboard across vertical to monitor the metrics with diff data sources including prometheus . i want to integrate pmm2 dashboard and exporter\*  in our existing setup. i have imported all dashboards in our existing grafana with Prometheus datasource  and dashboards loaded successfully. Can you plz guide and suggest how can i use all pmm2 exporter in our existing setup so that no need to change the query format/variables under  pmm2 dashboards .  ---
**Author:** ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)\ **Post date:** [April 16, 2020, 4:35am UTC](https://forums.percona.com/t/how-to-use-pmm2-dashboards-exporter-in-our-existing-grafana-prometheus-setup/7539/2 "2020-04-16T04:35:01Z")
Hi, Here is the list of labels with example data that have to be added in Prometheus targets in order to correctly process formulas in dashboards. _    labels:_ _     agent\_id: /agent\_id/6e726077-bd18-46f4-a4ba-4395d5e8c370_ _     agent\_type: postgres\_exporter_ _     instance: /agent\_id/6e726077-bd18-46f4-a4ba-4395d5e8c370_ _     node\_id: pmm-server_ _     node\_name: pmm-server_ _     node\_type: generic_ _     region: South Central US_ _     service\_id: /service\_id/508b7436-584a-4b7f-9ec1-733a1a238ea3_ _     service\_name: pmm-server-postgresql_ _     service\_type: postgresql_ ![](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/1X/3fa145cfe646a00f0a8bb7844fad6211d2fa5101.png) ---
**Author:** ![jaiswalvinny9](https://avatars.discourse-cdn.com/v4/letter/j/c67d28/32.png) [@jaiswalvinny9](https://forums.percona.com/u/jaiswalvinny9)\ **Post date:** [April 18, 2020, 11:51am UTC](https://forums.percona.com/t/how-to-use-pmm2-dashboards-exporter-in-our-existing-grafana-prometheus-setup/7539/3 "2020-04-18T11:51:22Z")
Thanks for the input . Already configured and it’s working fine except one dashboard  ( Home Dashboard ) . I’m getting an error while importing Home dashboard over grafana as panel plugin not found : pmm-update -panel . As per git repo , [https://github.com/percona/grafana-dashboards/tree/master/pmm-app/src/pmm-update-panel](https://github.com/percona/grafana-dashboards/tree/master/pmm-app/src/pmm-update-panel "Link: https://github.com/percona/grafana-dashboards/tree/master/pmm-app/src/pmm-update-panel") this is not plugin , this  come from repo . Can you plz help me to resolve this dependency as plugin or alternate way .  ---
**Author:** ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)\ **Post date:** [April 20, 2020, 2:29pm UTC](https://forums.percona.com/t/how-to-use-pmm2-dashboards-exporter-in-our-existing-grafana-prometheus-setup/7539/4 "2020-04-20T14:29:09Z")
I think you may just remove this pmm-update element from the Home dashboard. Anyway it has no functionality in your installation. Here are steps for building pmm-app plugin and adding it into Grafana in case if you decide to keep the element. # git clone [GitHub - percona/grafana-dashboards: PMM dashboards for database monitoring](https://github.com/percona/grafana-dashboards) # git checkout PMM-2.0 # cd grafana-dashboards/pmm-app/ # npm i # npm run build # cp -r …/pmm-app /var/lib/grafana/plugins/ Restart grafana after a plugin installing. Also the plugin can be taken from the package percona-dashboards ([https://repo.percona.com/pmm2-components/](https://repo.percona.com/pmm2-components/ "Link: https://repo.percona.com/pmm2-components/")). Plugin is located in the next folder /usr/share/percona-dashboards ---
**Author:** ![Yuvaraj\_64](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/yuvaraj_64/32/6670_2.png) [@Yuvaraj\_64](https://forums.percona.com/u/Yuvaraj_64)\ **Post date:** [June 3, 2020, 12:10am UTC](https://forums.percona.com/t/how-to-use-pmm2-dashboards-exporter-in-our-existing-grafana-prometheus-setup/7539/5 "2020-06-03T00:10:09Z")
Hi, I am am same issue, where we have Standalone prometheus and grafana wanted to utilize QAN of PMM2 . Not errored due to plugin issue… As suggested  I have download the below rpm … I need to copy only below files   to /var/lib/grafana/plugins/ ?  rpm -qpl  percona-dashboards-2.6.1-14.2005181356.53769cb.el7.noarch.rpm /usr/share/percona-dashboards/pmm-app/dist/react-plugins-deps/assets/usr/share/percona-dashboards/pmm-app/dist/react-plugins-deps/assets/50747258.png/usr/share/percona-dashboards/pmm-app/dist/react-plugins-deps/assets/Percona\_XtraDB\_Cluster.png/usr/share/percona-dashboards/pmm-app/dist/react-plugins-deps/assets/background.png/usr/share/percona-dashboards/pmm-app/dist/react-plugins-deps/assets/database.png/usr/share/percona-dashboards/pmm-app/dist/react-plugins-deps/assets/footer-logo.png/usr/share/percona-dashboards/pmm-app/dist/react-plugins-deps/assets/logo.png/usr/share/percona-dashboards/pmm-app/dist/react-plugins-deps/assets/mysql\_64\_black.png/usr/share/percona-dashboards/pmm-app/dist/react-plugins-deps/assets/percona-server-black-50.png/usr/share/percona-dashboards/pmm-app/dist/react-plugins-deps/assets/pmm-logo.svg/usr/share/percona-dashboards/pmm-app/dist/react-plugins-deps/assets/search.svg/usr/share/percona-dashboards/pmm-app/dist/react-plugins-deps/assets/sm-logo.png ---
**Author:** ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)\ **Post date:** [June 3, 2020, 3:25am UTC](https://forums.percona.com/t/how-to-use-pmm2-dashboards-exporter-in-our-existing-grafana-prometheus-setup/7539/6 "2020-06-03T03:25:14Z")
Hi Revana, QAN requires connections to elements that are provided by pmm-server. So there is no chance to use the plugin without pmm-server.  ---
**Author:** ![Yuvaraj\_64](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/yuvaraj_64/32/6670_2.png) [@Yuvaraj\_64](https://forums.percona.com/u/Yuvaraj_64)\ **Post date:** [June 2, 2022, 7:47am UTC](https://forums.percona.com/t/how-to-use-pmm2-dashboards-exporter-in-our-existing-grafana-prometheus-setup/7539/7 "2022-06-02T07:47:57Z")
Hi, AS I menetioned earlier, We have dedicated Prometheus and Grafan server. We wanted to utilize PMM2/QAN for PostgrSQL Could please provide me details steps to configure ? Thanks Siddesh ---
**Author:** ![Yuvaraj\_64](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/yuvaraj_64/32/6670_2.png) [@Yuvaraj\_64](https://forums.percona.com/u/Yuvaraj_64)\ **Post date:** [June 2, 2022, 7:53am UTC](https://forums.percona.com/t/how-to-use-pmm2-dashboards-exporter-in-our-existing-grafana-prometheus-setup/7539/8 "2022-06-02T07:53:43Z")
> [@jaiswalvinny9](#): > > Already configured and it’s working fine except one dashboard Hi, Could please provide details steps , I have dedicated Prometheus and Grafan server running on bare metal server. We wanted to utilize PMM2 for PostgreSQl … -Siddesh ---
**Author:** ![Yuvaraj\_64](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/yuvaraj_64/32/6670_2.png) [@Yuvaraj\_64](https://forums.percona.com/u/Yuvaraj_64)\ **Post date:** [June 2, 2022, 10:30am UTC](https://forums.percona.com/t/how-to-use-pmm2-dashboards-exporter-in-our-existing-grafana-prometheus-setup/7539/9 "2022-06-02T10:30:38Z")
Below is what I have completed … I am unable to see any dashboards . Please help us on priority 1. Installed prometheus 2. Installed percona-grafana rpm -ivh percona-grafana-8.3.5-95.2205101657.f666e10.el7.x86\_64.rpm 3. Installed percona-dashboards rpm -ivh percona-dashboards-2.28.0-15.2204281446.b497641.el7.x86\_64.rpm warning: percona-dashboards-2.28.0-15.2204281446.b497641.el7.x86\_64.rpm: Header V4 RSA/SHA256 Signature, key ID 8507efa5: NOKEY Preparing… ################################# [100%] Updating / installing… 1:percona-dashboards-2.28.0-15.2204################################# [100%] 1. Installed percona-qan-api2 rpm -ivh percona-qan-api2-2.28.0-15.2204182342.ba60012.el7.x86\_64.rpm warning: percona-qan-api2-2.28.0-15.2204182342.ba60012.el7.x86\_64.rpm: Header V4 RSA/SHA256 Signature, key ID 8507efa5: NOKEY Preparing… ################################# [100%] Updating / installing… 1:percona-qan-api2-2.28.0-15.220418################################# [100%] ---
**Author:** ![steve.hoffman](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/steve.hoffman/32/66_2.png) [@steve.hoffman](https://forums.percona.com/u/steve.hoffman)\ **Post date:** [June 2, 2022, 2:04pm UTC](https://forums.percona.com/t/how-to-use-pmm2-dashboards-exporter-in-our-existing-grafana-prometheus-setup/7539/10 "2022-06-02T14:04:07Z")
QAN isn’t available standalone and is tightly intertwined with PMM2. The dashboards alone is not going to be enough because the QAN data isn’t retrieved as part of normal exporters, there’s a special agent in PMM client that streams query data in buckets to PMM server from either (slowlog or perfschema for mysql or pg\_stat\_statements or pg\_stat\_monitor for postgres) only that data is not stored in Prometheus (victoriametrics for PMM), rather a clickhouse database bundled with PMM server. So if you’re trying to cherry pick the feature and incorporate it into your existing Grafana/Prometheus you’ve minimally got to recreate that whole data retrieval and storage process and put it in a place your dashboard is going to look before your dashboard would even begin to come to life but even then there will be a lot of elements you’d need the rest of the client for (explain plans, tables view, etc). Not impossible but not something we would even support if you were a paying customer. You’d almost have an easier time having pmm client run on your DB server sending data to a PMM server and exposing the clickhouse port from that PMM server then adding it as a datasource to your Grafana instance. Even then I don’t think you’d be able to import the QAN dashboards and they just work but you’d at least be able to build your own custom dashboard to show queries and such. ---
**Author:** ![Yuvaraj\_64](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/yuvaraj_64/32/6670_2.png) [@Yuvaraj\_64](https://forums.percona.com/u/Yuvaraj_64)\ **Post date:** [June 2, 2022, 2:48pm UTC](https://forums.percona.com/t/how-to-use-pmm2-dashboards-exporter-in-our-existing-grafana-prometheus-setup/7539/11 "2022-06-02T14:48:54Z")
Thanks a lot for the quick response , Basically we dont want use Docker image of PMM2 , We want to install PMM2 on standalone servers. Could please help me on this … -Siddesh ---
**Author:** ![ngougni\_heguens](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ngougni_heguens/32/8482_2.png) [@ngougni\_heguens](https://forums.percona.com/u/ngougni_heguens)\ **Post date:** [December 2, 2022, 7:40am UTC](https://forums.percona.com/t/how-to-use-pmm2-dashboards-exporter-in-our-existing-grafana-prometheus-setup/7539/12 "2022-12-02T07:40:09Z")
Please can I have an example with psmdb. I’m trying to use all PMM dashboards in my grafana and prometheus instance