Skip to content

Details

Dear Illinois Prairie PUG members,

Our first meetup of 2026 will take place on January 13!
Our opening event will feature Ryan Booze, Solutions Engineer at pganalyze.

Talk title:
Configuring Postgres for effective logging and query optimization analysis

Talk Description:

This talk will cover

- config of pg_stat_statements, auto_explain, and logging
- logged statements and plans to locate optimization opportunities
- Identifying three common query patterns that are worth trying a rewrite, and how to do this

Previously, Ryan had presented atthe Chicago PostgreSQL User Group multiple times, and we are excited to have him back!

About the Speaker

Ryan is a Solutions Engineer at pganalyze focusing on PostgreSQL. Ryan has worked as a PostgreSQL advocate, developer, DBA and product manager for more than 25 years, primarily working with time-series data on PostgreSQL and the Microsoft Data Platform.

Ryan is a long-time DBA and developer, starting with MySQL and Postgres in the late 90s. He spent more than 15 years working with SQL Server before returning to PostgreSQL full-time in 2018. He’s at the top of his game when he's learning something new about the data platform or teaching others about the technology he loves.

Event location: DRW Training Center, 540 W. Madison, 25th floor.

A reminder about our venue:

- This is a high-security building, which means the names of all participants should be communicated no later than 7:30 AM on the day of the event, and all participants must present a government-issued ID to be admitted. If your meetup profile does not list your full name, please send a DM with the required information to me (Hettie). Please make sure to do so not later than the day before the meetup. Registration for all in-person events will be closed by 7-30 AM the day of the event.
- The food order will be placed a day before the event, so I strongly encourage everybody planning to attend to RSVP at least a day before.

Please RSVP to this event only if you are attending in person.
If you are planning to attend virtually, please RSVP here.

Hope to see you there!

Hettie Dombrovskaya
Illinois Prairie PostgreSQL User Group Organizer

Events in Chicago, IL
Database Professionals
PostgreSQL
Open Source

AI summary

By Meetup

Illinois Prairie PUG meetup for members: talk on configuring Postgres for logging and query optimization; attendees will identify three rewrite-worthy query patterns.

Members are also interested in