{"guid":"6912aa5b-1cfb-5233-908c-f04ef976f689","title":"PostgreSQL: EXPLAIN erklärt","subtitle":null,"slug":"fossgis2019-408-postgresql-explain-erklrt","link":"https://pretalx.com/fossgis2019/talk/WV3EPA/","description":"Bei der Analyse von Performance-Problemen (Warum ist diese Abfrage langsam) kann eine Auswertung\ndes Abfrageplanes via EXPLAIN helfen. Doch wie liest man dies?\n\nDie OpenSource-Datenbank kommt mit einem leistungsfähigen Planner \u0026 Optimizer daher. Dieser\nberechnet mögliche Ausführungspläne einer an die Datenbank gestellten Abfrage und bewertet\ndiese mit Kosten, um den günstigsten Abfrageplan auszuwählen.\n\nDoch wie arbeitet dieses Kostenmodell, und wie interpretiert man einen solchen Kostenplan?\n\nIm Vortrag sollen die grundlegende Arbeitsweise von EXPLAIN und die Auswertung von\nAusführungsplänen vorgestellt werden.","original_language":"deu","persons":["Andreas Kretschmer"],"tags":["fossgis2019","408","2019","Geo","OpenStreeetMap","FOSS","Dresden"],"view_count":281,"promoted":false,"date":"2019-03-13T00:00:00.000+01:00","release_date":"2019-03-14T01:00:00.000+01:00","updated_at":"2026-04-10T10:15:04.160+02:00","length":1506,"duration":1506,"thumb_url":"https://static.media.ccc.de/media/events/fossgis/2019/408-hd.jpg","poster_url":"https://static.media.ccc.de/media/events/fossgis/2019/408-hd_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/fossgis/2019/408-hd.timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/fossgis/2019/408-hd.thumbnails.vtt","frontend_link":"https://media.ccc.de/v/fossgis2019-408-postgresql-explain-erklrt","url":"https://api.media.ccc.de/public/events/6912aa5b-1cfb-5233-908c-f04ef976f689","conference_title":"FOSSGIS 2019","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2019","related":[{"event_id":6779,"event_guid":"044219ec-981e-5726-b30d-8317879ee5b2","weight":11},{"event_id":6781,"event_guid":"6805ef29-7080-5b95-831f-f12dc63300d4","weight":12},{"event_id":6786,"event_guid":"6410a81e-2021-55bd-a190-9b4d0c7e663f","weight":13},{"event_id":6796,"event_guid":"51d3b894-e061-570d-8d94-d0ce984b37c4","weight":15},{"event_id":6801,"event_guid":"5723e0b3-024e-5e53-a1cc-61557d4c1c00","weight":10},{"event_id":6803,"event_guid":"af989d48-b461-5bbc-a1a8-e73f2d9002e9","weight":14},{"event_id":6804,"event_guid":"95f8217e-9bca-5745-a051-d88775aa8d56","weight":8},{"event_id":6805,"event_guid":"c4fe31fb-89d7-5ab3-a9f6-0f56c6c4c898","weight":20},{"event_id":6806,"event_guid":"f64871ee-26c3-5b5e-a769-4b5ef883661d","weight":12},{"event_id":6807,"event_guid":"61ec52d4-db5e-5941-9ce8-c9fa03260d6d","weight":13}],"recordings":[{"size":141,"length":1506,"mime_type":"video/mp4","language":"deu","filename":"fossgis2019-408-deu-PostgreSQL_EXPLAIN_erklaert_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2019-03-14T01:19:12.704+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2019/h264-hd/fossgis2019-408-deu-PostgreSQL_EXPLAIN_erklaert_hd.mp4","url":"https://api.media.ccc.de/public/recordings/33833","event_url":"https://api.media.ccc.de/public/events/6912aa5b-1cfb-5233-908c-f04ef976f689","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2019"},{"size":22,"length":1506,"mime_type":"audio/mpeg","language":"deu","filename":"fossgis2019-408-deu-PostgreSQL_EXPLAIN_erklaert_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2019-03-14T01:39:34.651+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2019/mp3/fossgis2019-408-deu-PostgreSQL_EXPLAIN_erklaert_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/33870","event_url":"https://api.media.ccc.de/public/events/6912aa5b-1cfb-5233-908c-f04ef976f689","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2019"},{"size":14,"length":1506,"mime_type":"audio/opus","language":"deu","filename":"fossgis2019-408-deu-PostgreSQL_EXPLAIN_erklaert_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2019-03-14T01:40:03.363+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2019/opus/fossgis2019-408-deu-PostgreSQL_EXPLAIN_erklaert_opus.opus","url":"https://api.media.ccc.de/public/recordings/33871","event_url":"https://api.media.ccc.de/public/events/6912aa5b-1cfb-5233-908c-f04ef976f689","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2019"},{"size":46,"length":1506,"mime_type":"video/mp4","language":"deu","filename":"fossgis2019-408-deu-PostgreSQL_EXPLAIN_erklaert_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2019-03-14T01:43:04.450+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2019/h264-sd/fossgis2019-408-deu-PostgreSQL_EXPLAIN_erklaert_sd.mp4","url":"https://api.media.ccc.de/public/recordings/33878","event_url":"https://api.media.ccc.de/public/events/6912aa5b-1cfb-5233-908c-f04ef976f689","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2019"},{"size":202,"length":1506,"mime_type":"video/webm","language":"deu","filename":"fossgis2019-408-deu-PostgreSQL_EXPLAIN_erklaert_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2019-03-14T11:22:15.310+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2019/webm-hd/fossgis2019-408-deu-PostgreSQL_EXPLAIN_erklaert_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/33886","event_url":"https://api.media.ccc.de/public/events/6912aa5b-1cfb-5233-908c-f04ef976f689","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2019"},{"size":83,"length":1506,"mime_type":"video/webm","language":"deu","filename":"fossgis2019-408-deu-PostgreSQL_EXPLAIN_erklaert_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2019-03-14T11:23:06.284+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2019/webm-sd/fossgis2019-408-deu-PostgreSQL_EXPLAIN_erklaert_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/33888","event_url":"https://api.media.ccc.de/public/events/6912aa5b-1cfb-5233-908c-f04ef976f689","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2019"}]}