Our great sponsors
-
Rails PG Extras
Rails PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.
Your first impression may be that it's better to add indexes to every field in a database. However, first of all, only one of the defined indexes is working here (see the compound index section). Furthermore, indexes can slow down queries if there are not many records in the database, and each index takes up space in a computer's memory. Often, the size of the indexes may be larger than the amount of the data stored in a database. You can install the "rails-pg-extras" gem to get more information. I recommend that you carefully study the documentation of this gem, as it contains many useful functions that will make your work with the database as efficient as possible.
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
Related posts
- rails-pg-extras introduces new API for measuring SQL queries generated by any Ruby snippet
- rails-pg-extras introduces new API for measuring SQL queries generated by any Ruby snippet
- Best way to learn query optimization?
- rails-pg-extras: a new release adds built-in dashboard interface
- rails-pg-extras: a new release adds built-in dashboard interface