<?xml version="1.0" encoding="UTF-8"?><oembed><type>video</type><version>1.0</version><html>&lt;iframe src=&quot;https://www.loom.com/embed/25a2903db92c48c5ad42bc1c49d4a8ee&quot; frameborder=&quot;0&quot; width=&quot;2394&quot; height=&quot;1795&quot; webkitallowfullscreen mozallowfullscreen allowfullscreen&gt;&lt;/iframe&gt;</html><height>1795</height><width>2394</width><provider_name>Loom</provider_name><provider_url>https://www.loom.com</provider_url><thumbnail_height>1795</thumbnail_height><thumbnail_width>2394</thumbnail_width><thumbnail_url>https://cdn.loom.com/sessions/thumbnails/25a2903db92c48c5ad42bc1c49d4a8ee-1715978361702.gif</thumbnail_url><duration>1089.033</duration><title>Configuring and using pg_stat_statements data, creating generic query exec plans</title><description>Workshop: https://github.com/andyatkinson/rideshare/blob/main/docs/workshop/README.md

Book: https://pragprog.com/titles/aapsql/high-performance-postgresql-for-rails/

Steps:
- Configure pg_stat_statements and shared_preload_libraries
- Enable the extension
- Explore the query stats captured by the extension
- Basics of using the GENERIC_PLAN parameter with EXPLAIN</description></oembed>