{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/25a2903db92c48c5ad42bc1c49d4a8ee\" frameborder=\"0\" width=\"2394\" height=\"1795\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1795,"width":2394,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1795,"thumbnail_width":2394,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/25a2903db92c48c5ad42bc1c49d4a8ee-1715978361702.gif","duration":1089.033,"title":"Configuring and using pg_stat_statements data, creating generic query exec plans","description":"Workshop: https://github.com/andyatkinson/rideshare/blob/main/docs/workshop/README.md\n\nBook: https://pragprog.com/titles/aapsql/high-performance-postgresql-for-rails/\n\nSteps:\n- Configure pg_stat_statements and shared_preload_libraries\n- Enable the extension\n- Explore the query stats captured by the extension\n- Basics of using the GENERIC_PLAN parameter with EXPLAIN"}