Explore the World's Best Ideas
Join today and uncover 100+ curated journeys from 50+ topics. Unlock access to our mobile app with extensive features.
Enable slow query log
Set the followings settings in /etc/postgresql/15/main/postgresql.conf:
"Error Reporting and Logging"
- logging_collector = on
- log_min_duration_statement = 1s
- log_lock_waits = on
"Run-time Statistics"
- track_activity_query_size = 8192
2
38 reads
MORE IDEAS ON THIS
Analyze slow query log
- Download the log files on your computer. The default location is
/var/lib/postgresql/15/main/log/. - Install pgBadger
- Analyze the logs:
pgbadger -o stats.html --prefix '%m \[%p\] %q%u@%d' /dir\_with\_logs/\*.log
2
34 reads
CURATED FROM
IDEAS CURATED BY
Alt account of @ocp. I use it to stash ideas about software engineering
Other curated ideas on this topic:
Arrive Early on the First Day
Reporting to work late on the first day or during the first few weeks can leave the wrong impression.
To be punctual, you can find out about the reporting time and work towards getting to the workplace at least 15 minutes earlier. Take into account factors such as ongoing cons...
Middleware
Middleware gives you the possibility to run code before a request is complete and based on the incoming request, you can rewrite, redirect, add headers or even stream HTML. It can be used for anything that shares logic for a set of pages, including:
10. Start a log
- It’s important that you write down everything you do and eat and make yourself accountable for every action or non-action during your fitness journey.
- Record absolutely everything including the small things like when you picked stairs over elevator – these are the small victories tha...
Read & Learn
20x Faster
without
deepstash
with
deepstash
with
deepstash
Personalized microlearning
—
100+ Learning Journeys
—
Access to 200,000+ ideas
—
Access to the mobile app
—
Unlimited idea saving
—
—
Unlimited history
—
—
Unlimited listening to ideas
—
—
Downloading & offline access
—
—
Supercharge your mind with one idea per day
Enter your email and spend 1 minute every day to learn something new.
I agree to receive email updates