PgHero VS Icinga

PgHero Reviews

Icinga Reviews

PgHero mentions (7)

• Show HN: PostgreSQL Index Advisor

  I am using https://github.com/ankane/pghero/ and this is one of its features with GUI. - Source: Hacker News / 24 days ago

• What are your favourite approaches to keeping on top of Postgres health?

  I use either PgHero or Rails PG Extras on every project. Source: 11 months ago

• Slow query. Should add indexes?

  There are tools available which can look at your Postgres logs and tell you if you need to add indexes, I've used https://github.com/ankane/pghero before and it seems decent. Source: about 1 year ago

• How and why Relational Model works for databases

  I'm a huge supporter of PGhero (https://github.com/ankane/pghero) for this reason. Sometimes a single index is all that's required, but if DB design isn't your forte it's hard to know where to put it. - Source: Hacker News / over 2 years ago

• Check why Django app is slow in production

  If you are using PostgreSQL you can enable logging of slow queries and connect to the server with pghero (https://github.com/ankane/pghero) and check top queries by the number of requests and total usage time. Also, you can just enable logging of queries in Django, and on each request, you will have a list of queries on development, sometimes it's just a missing select_related of prefetch_related to increase... Source: over 2 years ago

Icinga mentions (8)

• What do you use to visualize your topology?

  Two manually updated svg maps on nagvis that integrate with our icinga checks, one for the transport system nodes and one for the routers. Source: about 1 year ago

• SSLPing permanently goes out of service

  Might be a bit of an overkill if you just want to check the certificates, but I'm using Icinga (formerly known as Nagios) to keep track of all of the systems - including webpage certificates. Source: about 2 years ago

• What "legacy" software are you still forced to use in 2022 that you wish would die?

  Some of it can be migrated rather easily to Icinga https://icinga.com/. Icinga forked from Nagios many years ago, they rewrote the engine and have done a nice WebUI. It is able to support e.g. Business branches using "satellites" that act as proxy to the main server/ server cluster. I was one of the two guys doing the setup for a company with multiple branch offices/ factories and during the time I was there it... Source: over 2 years ago

• Is there any program that can alert you of a stalled Plex Server?

  Personally I run https://icinga.com/ (to all my services, including Plex) and it polls every 5sec and after 5 fails in a row it sends me an email. Source: over 2 years ago

• Linux is dead, long-live Docker monoculture

  Fast forward 12 years and I have Icinga2 collectors in each datacenter using check_by_ssh to run check_systemd, all front-ended by Thruk. The TIG stack is something on my list of things to look into at some point, but with Dynatrace available to do all the fancy application monitoring, there's no rush. Source: over 2 years ago