{"id":"https://openalex.org/W7204155400","doi":"https://doi.org/10.48550/arxiv.2608.23402","title":"EXPLAIN Yourself! Finding Query Planner Stalls Across DBMSes","display_name":"EXPLAIN Yourself! Finding Query Planner Stalls Across DBMSes","publication_year":2026,"publication_date":"2026-08-24","ids":{"openalex":"https://openalex.org/W7204155400","doi":"https://doi.org/10.48550/arxiv.2608.23402"},"language":"en","primary_location":{"id":"pmh:oai:arXiv.org:2608.23402","doi":null,"is_oa":true,"landing_page_url":"https://arxiv.org/abs/2608.23402","pdf_url":"https://arxiv.org/pdf/2608.23402","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"volume":null,"type":"preprint","is_traditional":true,"indexed_in":["arxiv","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2608.23402","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5046724740","display_name":"Geoffrey X. Yu","orcid":"https://orcid.org/0009-0005-3186-1465","observed_orcids":["https://orcid.org/0009-0005-3186-1465"]},"institutions":[{"id":"https://openalex.org/I4405258931","display_name":"MIT Computer Science and Artificial Intelligence Laboratory","ror":"https://ror.org/01e85r662","country_code":"US","type":"facility","lineage":["https://openalex.org/I4405258931","https://openalex.org/I63966007"]},{"id":"https://openalex.org/I63966007","display_name":"Massachusetts Institute of Technology","ror":"https://ror.org/042nb2s44","country_code":"US","type":"education","lineage":["https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yu, Geoffrey X.","raw_affiliation_strings":["MIT CSAIL Cambridge , MA , USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MIT CSAIL Cambridge , MA , USA","institution_ids":["https://openalex.org/I4405258931","https://openalex.org/I63966007"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5025731013","display_name":"Ryan Marcus","orcid":"https://orcid.org/0000-0002-1279-1124","observed_orcids":["https://orcid.org/0000-0002-1279-1124"]},"institutions":[{"id":"https://openalex.org/I79576946","display_name":"University of Pennsylvania","ror":"https://ror.org/00b30xv10","country_code":"US","type":"education","lineage":["https://openalex.org/I79576946"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Marcus, Ryan","raw_affiliation_strings":["University of Pennsylvania Philadelphia , PA , USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Pennsylvania Philadelphia , PA , USA","institution_ids":["https://openalex.org/I79576946"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5034086130","display_name":"Tim Kraska","orcid":"https://orcid.org/0009-0003-2414-2759","observed_orcids":["https://orcid.org/0009-0003-2414-2759"]},"institutions":[{"id":"https://openalex.org/I4405258931","display_name":"MIT Computer Science and Artificial Intelligence Laboratory","ror":"https://ror.org/01e85r662","country_code":"US","type":"facility","lineage":["https://openalex.org/I4405258931","https://openalex.org/I63966007"]},{"id":"https://openalex.org/I63966007","display_name":"Massachusetts Institute of Technology","ror":"https://ror.org/042nb2s44","country_code":"US","type":"education","lineage":["https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kraska, Tim","raw_affiliation_strings":["MIT CSAIL Cambridge , MA , USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MIT CSAIL Cambridge , MA , USA","institution_ids":["https://openalex.org/I4405258931","https://openalex.org/I63966007"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9980000257492065,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9980000257492065,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.0003000000142492354,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10906","display_name":"AI-based Problem Solving and Planning","score":9.999999747378752e-05,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/query-planning","display_name":"query planning","score":0.6909999847412109},{"id":"https://openalex.org/keywords/database-management-systems","display_name":"database management systems","score":0.7160000205039978},{"id":"https://openalex.org/keywords/denial-of-service-attacks","display_name":"denial-of-service attacks","score":0.7360000014305115},{"id":"https://openalex.org/keywords/common-table-expressions","display_name":"common table expressions","score":0.824999988079071},{"id":"https://openalex.org/keywords/constant-folding","display_name":"constant folding","score":0.9649999737739563},{"id":"https://openalex.org/keywords/agentic-search","display_name":"agentic search","score":0.746999979019165}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7271000146865845},{"id":"https://openalex.org/C2776999362","wikidata":"https://www.wikidata.org/wiki/Q2349274","display_name":"Planner","level":2,"score":0.6970999836921692},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6480000019073486},{"id":"https://openalex.org/C79581498","wikidata":"https://www.wikidata.org/wiki/Q1367530","display_name":"Suite","level":2,"score":0.614799976348877},{"id":"https://openalex.org/C63479239","wikidata":"https://www.wikidata.org/wiki/Q7353546","display_name":"Robustness (evolution)","level":3,"score":0.5764999985694885},{"id":"https://openalex.org/C2780938662","wikidata":"https://www.wikidata.org/wiki/Q973710","display_name":"Tying","level":2,"score":0.4666999876499176},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.42980000376701355},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.41909998655319214},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.41749998927116394},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.41359999775886536},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.41119998693466187},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.41110000014305115},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.4106000065803528},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.3928000032901764},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.3903000056743622},{"id":"https://openalex.org/C165464430","wikidata":"https://www.wikidata.org/wiki/Q1570441","display_name":"Parameterized complexity","level":2,"score":0.3578000068664551},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.3537999987602234},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.35019999742507935},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.3361000120639801},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.31949999928474426},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.3190000057220459},{"id":"https://openalex.org/C28719098","wikidata":"https://www.wikidata.org/wiki/Q44946","display_name":"Point (geometry)","level":2,"score":0.30070000886917114},{"id":"https://openalex.org/C2989070954","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database query","level":2,"score":0.27869999408721924},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.2773999869823456},{"id":"https://openalex.org/C63584917","wikidata":"https://www.wikidata.org/wiki/Q333286","display_name":"Bounding overwatch","level":2,"score":0.2750999927520752},{"id":"https://openalex.org/C82876162","wikidata":"https://www.wikidata.org/wiki/Q17096504","display_name":"Latency (audio)","level":2,"score":0.27320000529289246},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.26489999890327454},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.25699999928474426}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:arXiv.org:2608.23402","doi":null,"is_oa":true,"landing_page_url":"https://arxiv.org/abs/2608.23402","pdf_url":"https://arxiv.org/pdf/2608.23402","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"doi:10.48550/arxiv.2608.23402","doi":"https://doi.org/10.48550/arxiv.2608.23402","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2608.23402","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:2608.23402","doi":null,"is_oa":true,"landing_page_url":"https://arxiv.org/abs/2608.23402","pdf_url":"https://arxiv.org/pdf/2608.23402","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W7204155400.pdf","grobid_xml":"https://content.openalex.org/works/W7204155400.grobid-xml"},"referenced_works_count":20,"referenced_works":["https://openalex.org/W2027259333","https://openalex.org/W2164645353","https://openalex.org/W2259817977","https://openalex.org/W2396309311","https://openalex.org/W2475801470","https://openalex.org/W2798325362","https://openalex.org/W2911464154","https://openalex.org/W2998249308","https://openalex.org/W3042605769","https://openalex.org/W3106731144","https://openalex.org/W4284665426","https://openalex.org/W4386128182","https://openalex.org/W4398233983","https://openalex.org/W4406734979","https://openalex.org/W4411403367","https://openalex.org/W4411522876","https://openalex.org/W4415316685","https://openalex.org/W6925398415","https://openalex.org/W7159649516","https://openalex.org/W7161576351"],"related_works":["https://openalex.org/W3201461576","https://openalex.org/W4413349908","https://openalex.org/W4390769402","https://openalex.org/W4229984083","https://openalex.org/W7168321631","https://openalex.org/W2888876958","https://openalex.org/W4411403274","https://openalex.org/W2758202177","https://openalex.org/W4394769417","https://openalex.org/W2985029549"],"abstract_inverted_index":{"Query":[0],"planners":[1],"are":[2,118],"typically":[3],"expected":[4],"to":[5,21,67,71,74,106,160],"produce":[6],"optimized":[7],"plans":[8],"quickly,":[9],"leading":[10],"many":[11],"researchers":[12,154,192],"(including":[13],"the":[14,94,102,113],"authors":[15],"of":[16,149],"this":[17,40],"paper)":[18],"and":[19,99,133,155,180,184,193],"practitioners":[20],"design":[22],"systems":[23,104],"that":[24,39,61,111,153,168,181],"assume":[25],"query":[26,58,151,169],"planning":[27,117,170],"is":[28],"a":[29,33,88,146,176],"low-cost":[30],"operation.":[31],"Using":[32],"lightweight":[34],"agentic":[35],"search,":[36],"we":[37,53],"show":[38,167],"assumption":[41],"does":[42],"not":[43],"always":[44,172],"hold.":[45],"Across":[46],"seven":[47,103],"DBMSes,":[48],"including":[49],"four":[50],"commercial":[51],"systems,":[52],"find":[54,110],"at":[55],"least":[56],"one":[57],"per":[59],"system":[60],"takes":[62],"more":[63],"than":[64],"three":[65],"minutes":[66],"plan.":[68],"In":[69],"addition":[70],"being":[72],"slow":[73,116],"plan,":[75],"such":[76],"queries":[77,95,114,143],"risk":[78],"tying":[79],"up":[80],"database":[81,156,191],"resources":[82],"without":[83],"performing":[84],"useful":[85],"work,":[86],"creating":[87],"potential":[89],"denial-of-service":[90],"vector.":[91],"We":[92,109,139],"analyze":[93],"our":[96,141,165],"search":[97],"uncovers":[98],"compare":[100],"how":[101],"respond":[105],"each":[107],"pattern.":[108],"although":[112],"triggering":[115],"largely":[119],"DBMS-specific,":[120],"recurring":[121],"pathologies":[122,152],"involving":[123],"correlated":[124],"subqueries,":[125],"CTE":[126],"expansion,":[127],"repeated":[128],"subquery":[129],"expressions,":[130],"disjunctive":[131],"joins,":[132],"constant":[134],"folding":[135],"affect":[136],"multiple":[137],"systems.":[138],"release":[140],"uncovered":[142],"along":[144],"with":[145],"curated":[147],"suite":[148],"parameterized":[150],"engineers":[157],"can":[158],"use":[159],"test":[161],"planner":[162],"robustness.":[163],"Overall,":[164],"results":[166],"cannot":[171],"be":[173],"treated":[174],"as":[175],"predictably":[177],"inexpensive":[178],"operation":[179],"its":[182],"latency":[183],"robustness":[185],"deserve":[186],"further":[187],"attention":[188],"from":[189],"both":[190],"engineers.":[194]},"counts_by_year":[],"updated_date":"2026-11-07T11:25:07.637180","created_date":"2026-08-26T00:00:00"}