Name: Understanding Query Plans Using EXPLAIN
Start: 2018-12-19T18:30:00-05:00
End: 2018-12-19T20:00:00-05:00
Location: Pivotal

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...

Renee

NYC Postgres

Technology

PostgreSQL

Open Source

Data Management

Database Development

Database Professionals

Geospatial

Data Analytics

Big Data

Python

JavaScript

NoSQL

Web Development

MySQL

Oracle

Understanding Query Plans Using EXPLAIN

Pivotal

Share

NYC Postgres

Understanding Query Plans Using EXPLAIN

NYC Postgres

Details

Members are also interested in