Tag: sql

When pasting ActiveRecord::Base.logger = Logger.new(STDOUT) into the rails console, it will convert all active record queries into raw SQL.

This is helpful to make sure active record queries are optimized (avoid n+1) or quickly grab an SQL statement for database software.

A great tip to keep in your back pocket!

Here’s some commands to help make your sql output more readable in your command line:

output the name of each column

.header on

now we are in column mode, enabling us to run the next two .width commands

.mode column

adjusts and normalizes column width

.width auto

or

customize column width

.width <NUM1>, <NUM2>