Joe, a Postgres query optimization bot
I&#x27;ve used Joe quite a bit, and all I can say is that it&#x27;s a great idea that solves a noticeable problem: troubleshoot your queries.<p>It may not look like is a hard challenge: but the reality is that most troubleshoot them in production, which means that:<p>a) you need access to production, when you shouldn&#x27;t;
b) you run queries in production, potentially affecting -sometimes noticeably- production workloads.<p>Joe provisions a database clone using ZFS snapshot (I believe LVM support was added recently) and gives you a full copy of the database for you, with real data. You can test the queries, explain plans, create indexes to test if you need. And when you are done, it goes away. With a Slack interface, so you don&#x27;t need to bother with connection, provisioning, credentials and decommissioning.<p>Give it a try, it is a very good tool!