Understanding Query Plans Using EXPLAIN

2018 is drawing to a close and we've had an exciting year of PostgreSQL meetups! Before we kick off 2019, we thought we could get in one more meetup to cover an important topic in PostgreSQL world - how to figure out what our query is doing!

One of the most complex parts of the PostgreSQL system is the planner and the optimizer. This talk will help you understand what happens when you ask the database to execute a query on your behalf. We will go over EXPLAIN, EXPLAIN ANALYZE, other ways of running EXPLAIN, how to adjust parameters to view alternative possible plans, and what the output and results mean.

Join us as Stephen Frost, a PostgreSQL Major Contributor, CTO of Crunchy Data, and a past speaker at NYCPUG, teach us how to use EXPLAIN to write better queries!

We will be at the offices of Pivotal on 636 6th Ave (entrance on 19th St). Please go to the 2nd Floor.

Agenda:

6:30pm - 6:50pm - Food & Networking
6:50pm - 8:10pm - Main Event
8:10pm - Meet up at...