How To Install ruby-activerecord-explain-analyze on Ubuntu
Posted on April 1, 2023 (Last modified on May 20, 2023 )
3 minutes • 428 words
Introduction
In this tutorial we learn how to install ruby-activerecord-explain-analyze on Ubuntu.
What is ruby-activerecord-explain-analyze
ruby-activerecord-explain-analyze is:
Extends ActiveRecord#explain with support for EXPLAIN ANALYZE and output formats of JSON, XML, and YAML.
What’s EXPLAIN ANALYZE? PostgreSQL devises a query plan for each query it receives. Choosing the right plan to match the query structure and the properties of the data is absolutely critical for good performance, so the system includes a complex planner that tries to choose good plans. One can use the EXPLAIN command to see what query plan the planner creates for any query. With EXPLAIN ANALYZE, EXPLAIN actually executes the query, and then displays the true row counts and true run time accumulated within each plan node.
There are three methods to install ruby-activerecord-explain-analyze on Ubuntu. We can use apt-get, apt and aptitude. In the following sections we will describe each method. You can choose one of them.
Install ruby-activerecord-explain-analyze Using apt-get
Update apt database with apt-get using the following command.
sudo apt-get update
After updating apt database, We can install ruby-activerecord-explain-analyze using apt-get by running the following command:
sudo apt-get -y install ruby-activerecord-explain-analyze
Install ruby-activerecord-explain-analyze Using apt
Update apt database with apt using the following command.
sudo apt update
After updating apt database, We can install ruby-activerecord-explain-analyze using apt by running the following command:
sudo apt -y install ruby-activerecord-explain-analyze
Install ruby-activerecord-explain-analyze Using aptitude
If you want to follow this method, you might need to install aptitude first since aptitude is usually not installed by default on Ubuntu. Update apt database with aptitude using the following command.
sudo aptitude update
After updating apt database, We can install ruby-activerecord-explain-analyze using aptitude by running the following command:
sudo aptitude -y install ruby-activerecord-explain-analyze
How To Uninstall ruby-activerecord-explain-analyze on Ubuntu
To uninstall only the ruby-activerecord-explain-analyze package we can use the following command:
sudo apt-get remove ruby-activerecord-explain-analyze
Uninstall ruby-activerecord-explain-analyze And Its Dependencies
To uninstall ruby-activerecord-explain-analyze and its dependencies that are no longer needed by Ubuntu, we can use the command below:
sudo apt-get -y autoremove ruby-activerecord-explain-analyze
Remove ruby-activerecord-explain-analyze Configurations and Data
To remove ruby-activerecord-explain-analyze configuration and data from Ubuntu we can use the following command:
sudo apt-get -y purge ruby-activerecord-explain-analyze
Remove ruby-activerecord-explain-analyze configuration, data, and all of its dependencies
We can use the following command to remove ruby-activerecord-explain-analyze configurations, data and all of its dependencies, we can use the following command:
sudo apt-get -y autoremove --purge ruby-activerecord-explain-analyze
Dependencies
ruby-activerecord-explain-analyze have the following dependencies:
References
Summary
In this tutorial we learn how to install ruby-activerecord-explain-analyze package on Ubuntu using different package management tools: apt, apt-get and aptitude.