TIL
psql picks the layout with \x auto
\x auto switches psql to one column per row only when a row is wider than the terminal. Narrow results stay a table.
$ echo '\x auto' >> ~/.psqlrcI used to toggle \x by hand and forget to toggle it back.
Queries, indexes and migrations, measured before and after.
TIL
\x auto switches psql to one column per row only when a row is wider than the terminal. Narrow results stay a table.
$ echo '\x auto' >> ~/.psqlrcI used to toggle \x by hand and forget to toggle it back.
Post
stummel looked up every code with a sequential scan over 1.2 million clicks’ worth of links. EXPLAIN ANALYZE showed it in one line.
1 min
PostMembers only
Seven questions I answer before any migration touches a table with data in it. For members, free.
1 min