Fix joins against the same table when not necessary

[pimeys]

Let's take a GraphQL query:

query {
  findManyUser(where: { firstName: "Face" })
  {
    firstName
    lastName
    posts { id }
  }
}

This leads to two queries in query-engine:

SELECT
    "sql_load_test"."User"."firstName",
    "sql_load_test"."User"."lastName",
    "sql_load_test"."User"."id"
FROM
    "sql_load_test"."User"
WHERE "sql_load_test"."User"."firstName" = 'Face'
ORDER BY "sql_load_test"."User"."id" ASC;

This one is merely a 24ms query, which is already quite slow, but nothing compared to the following:

SELECT
    "sql_load_test"."Post"."id",
    "RelationTable"."id" AS "__RelatedModel__",
    "RelationTable"."author" AS "__ParentModel__"
FROM
    "sql_load_test"."Post"
INNER JOIN "sql_load_test"."Post" AS "RelationTable" ON "sql_load_test"."Post"."id" = "RelationTable"."id"
WHERE (("RelationTable"."author" IN (1,675,917,1494,3128,3219,3645,3984,4658,6766,8014,8598,8719,9114,9365,9876,10281,10499,11858,12399,13499,13831,13968,14370,14754,15138,15140,15861,15896,16589,16626,16804,16867,18817,19684,19780,19914,20545,20647,20926,21531,22406,24258,24625,26738,27016,27203,28583,32909,33559,33638,34349,34943,36564,36648,37009,37061,37184,37374,38326,39730,39861,41302,43395,44030,44037,44673,45298,45524,46300,47702,47748,49337,55260,57094,57771,58402,58489,58775,59041,59531,60670,61578,65303,66039,66149,66460,68329,68496,68621,69465,69659,71399,71503,71780,72900,73014,73200,73735,74959,74989,75309,76209,76925,77487,77517,78819,79912,80366,80554,81693,82285,82455,83202,83396,83531,84272,86180,87026,88696,90352,91595,92006,92899,94154,95441,96672,97534,97570,98025,99459,100308,101241,102056,102106,102985,106467,106765,107043,108679,111376,113372,114890,115961,117177,118662,121921,122597,122869,123943,124753,125448,126847,127840,131620,135129,135839,135968,136313,136783,136903,137231,137261,138095,138135,140111,141094,141522,141558,142581,143147,143252,143693,146030,146238,146590,148223,150279,152542,153248,154566,155541,158745,160794,160954,160982,164941,165886,166337,166398,166990,167718,168611,171275,172451,172675,173154,174544,176011,176568,176745,177855,178046,178927,180834,181414,181649,181687,185247,185651,188034,188281,189052,189067,189494,192726,192965,193618,194082,194102,196321,200842,204012,204026,206658,207333,208721,209396,210520,215549,216683,220716,221794,221961,222690,224381,226940,227862,228963,229871,230833,232503,232965,233520,235124,235199,235869,236456,238462,238731,239786,239874,243040,246046,247089,247207,248808,248827,250158,250467,251266,251703,254690,257960,258963,259957,260147,261309,261488,261912,262083,263384,264205,264436,264858,265425,266890,267532,269591,270070,271159,271786,272588,274291,274591,274765,276797,279526,280244,283108,284852,285358,286057,286789,287259,288251,288631,289926,290712,292004,292267,292608,293575,294875,295462,295627,296478,296757,298099,298256,299737,300768,301963,302356,304902,305101,305157,306300,308773,311362,311693,313103,315654,316120,317325,317703,318243,318535,319074,319678,322317,323966,324913,325920,328616,329638,330365,331029,331273,331578,331862,332980,334497,336229,336822,336857,337209,338241,338748,339394,339441,339764,339854,341121,341278,341632,341674,341886,343031,345193,345670,348059,348539,348675,348811,348898,353092,353324,355821,356557,356864,356951,360590,360713,361437,363016,363456,363930,365932,366231,366927,367674,369401,370100,371113,371237,374255,374271,374753,375428,376132,376579,376647,377028,378226,378895,379104,379901,379965,380268,380326,381906,381909,382368,384503,385324,385588,385701,387667,392187,392646,395766,396498,396505,397017,397254,397834,398336,398618,398876,400791,401730,401987,402973,405483,406627,407340,408074,408478,410446,410646,410893,412590,413299,414506,414556,416515,417064,417464,417475,418093,418443,418818,418983,419514,421097,421694,422210,422872,423287,424112,425851,426066,428760,430129,430754,430797,431942,432368,433249,434751,435913,436285,439123,439730,441031,442138,442300,443341,444393,444559,444642,444699,445252,445829,446288,447616,448088,450491,452934,452981,453578,453887,453905,455787,456555,457459,458664,459697,461520,462024,462036,462807,463901,466204,467306,467711,468324,471276,472885,473448,473625,474767,476228,478112,478581,479977,480841,481986,482917,484680,486045,487356,490318,491135,491199,491462,491693,491940,492599,492867,496983,498249,498259,498646,499478,499566,501664,501734,502635,503056,503825,503842,504835,505358,505515,506427,506513,506837,509324,509765,511315,512419,512564,512692,512925,513958,517331,518778,519538,520191,520585,520652,521212,523313,524079,525009,526497,527072,531403,533741,536735,536992,537291,539070,539072,539124,542431,544217,545682,546680,547401,548296,550300,550324,551142,551198,551945,552152,554330,555059,557778,559538,559912,561026,561836,562262,562276,562673,563421,564007,564193,565883,566791,567894,571168,571811,572825,573371,574000,574017,574108,574253,574267,575064,577962,578268,579199,579504,579779,579954,581400,582508,583109,583254,585607,585811,586746,587240,588373,589424,589632,589752,590664,590744,591172,591374,591544,591691,591947,592904,594750,595457,596326,596707,597552,600560,600985,602773,602816,603478,605556,606381,608214,608421,609437,613173,616483,616910,617231,617459,619209,620419,620538,621377,622538,622895,623847,625586,626046,626801,627675,628875,629335,630517,630820,630845,631181,631885,634493,634836,635872,637136,637842,640198,642698,642910,644902,646886,647480,647883,648642,649361,649791,650060,651412,654773,655680,659386,661277,661706,663078,663585,664193,664311,670033,671890,672007,672826,673842,674043,676625,676899,677354,678084,678728,681599,682315,682357,683106,683765,683839,684467,685720,686532,687303,687530,687670,687781,687856,688095,688707,690062,697085,697840,698163,698515,698626,699387,699774,700313,700828,701453,701775,702533,703958,704847,705836,706022,706811,709063,709157,710758,710966,712638,712670,712768,713050,715493,715756,716718,719524,719661,719909,720310,720808,721107,722120,722763,723913,724543,726487,727266,728666,729487,729537,731502,732617,733386,734502,735273,735814,736840,738426,738514,741729,742497,744297,749134,749839,750748,751990,753626,753701,754706,756000,756369,756910,758937,759889,760033,760063,760215,762734,763940,766511,766641,766792,769167,772950,772983,773591,778937,780894,781809,782035,782217,782798,782983,783069,783609,785380,785549,785554,785555,787269,787414,787921,789400,789543,790341,790444,792167,792448,793603,793724,794842,795948,796022,796539,800123,800689,802159,803271,803503,803711,805360,805544,805665,805965,806196,807103,807589,807921,808098,811322,811610,812563,812666,814000,816663,818249,819184,819842,821376,821864,824099,827394,827521,828053,828539,833589,833620,834433,835078,835352,837997,841110,841266,841567,841594,843059,845136,845612,846045,849809,850167,850282,850473,850629,851492,851803,852037,852864,854457,856698,857122,857435,857938,858432,859964,860349,860477,862837,864426,865911,866387,867484,867997,868705,869809,869848,870659,870973,871499,872311,873392,873455,878957,879355,881036,882399,882453,883075,883090,884024,884670,885276,886162,886589,886902,887161,887226,887290,890701,894302,895654,903000,904091,905738,906323,907244,907964,908147,908208,908461,908780,908928,912357,912619,914138,914455,915551,916897,916934,918999,919241,919485,920985,923149,923199,923295,924098,924442,925211,925930,926384,926739,927393,928633,931868,934931,935192,935207,935807,936450,939984,940337,947383,947574,948130,948392,948668,949240,949450,950575,952437,954444,954648,954654,954732,955767,956174,956638,956910,957719,961418,961485,961985,963236,965725,967031,967702,967781,968248,970795,971281,971521,971605,972567,973381,975116,976915,979240,982023,984832,987251,987596,987971,989414,991054,992010,992228,992693,994292,995118,996714,996784,996803,996833,997196,997555,999253,1000157,1000198,1001530,1002462,1003045,1003200,1003787,1005510,1006016,1006400,1006783,1007037,1007082,1008634,1009335,1009396,1010536,1011406,1011478,1011747,1012462,1014933,1015221,1017021,1017953,1018058,1018229,1018984,1019683,1020292,1020734,1022426,1025713,1026419,1028268,1028844,1029691,1031284,1032894,1034830,1036254,1036683,1037165,1037462,1037773,1038377,1039232,1040041,1040126,1040776,1041017,1042022,1042273,1042641,1043668,1043680,1046066,1047616,1048869,1049596,1050261,1050288,1050500,1051211,1053400,1054690,1056116,1057331,1058781,1058846,1060490,1060795,1061147,1061374,1061709,1061839,1063367,1063997,1066908,1067429,1067657,1067773,1068290,1071120,1071255,1071842,1072420,1072670,1073643,1079698,1080420,1081677,1082964,1084740,1090225,1090624,1092265,1092495,1098478,1099709,1099786,1100042,1101982,1103861,1105172,1106043,1107273,1107567,1111456,1111506,1112311,1112370,1112438,1113553,1113898,1113955,1114122,1115033,1117436,1119773,1120656,1122312,1123362,1123991,1124633,1125016,1125028,1125033,1125393,1125456,1125770,1126256,1126791,1128584,1128658,1129761,1130434,1130753,1131408,1131840,1132476,1133930,1134621,1135255,1138488,1140655,1141269,1141694,1145486,1146193,1146914,1147995,1148023,1148223,1148603,1148853,1149078,1150627,1150832,1152379,1153081,1153633,1159085,1159184,1160104,1160419,1160659,1162289,1163804,1164904,1165010,1165510,1166790,1168315,1168500,1170845,1171820,1172172,1172504,1174143,1174988,1176660,1177669,1179370,1180798,1181335,1182551,1184293,1184719,1187087,1190244,1190542,1191841,1194947,1195610,1196509,1201865,1202123,1202964,1203398,1204001,1205102,1205181,1205862,1207897,1209783,1209960,1210891,1211650,1211823,1212005,1212860,1213315,1213682,1213796,1214320,1214939,1215249,1216269,1217746,1219004,1219182,1219234,1219870,1220046,1220818,1220912,1222340,1222814,1222853,1223154,1224123,1225973,1226741,1227414,1228867,1229174,1230636,1232420,1233251,1236114,1236998,1237687,1239054,1239773,1240120,1240626,1242202,1243069,1244183,1244381,1245086,1247327,1249044,1249995,1250315,1250367,1250384,1253901,1256836,1257292,1257526,1258007,1258261,1258699,1259799,1259972,1260086,1261313,1261332,1261848,1262717,1262798,1263619,1263961,1264063,1264270,1265076,1265555,1266624,1266942,1268959,1270248,1271105,1273531,1273768,1275942,1275972,1279011,1281531,1282763,1283528,1283709,1285102,1286415,1288346,1289105,1290340,1291364,1292451,1294565,1299689,1300147,1300321,1300534,1300914,1301953,1302045,1304189,1304646,1304877,1307910,1308712,1311589,1315698,1316296,1316980,1319182,1319976,1320289,1320403,1320508,1320550,1320825,1323109,1325831,1325951,1326798,1327180,1327437,1327820,1328937,1330808,1331663,1331901,1333010,1333051,1335878,1337038,1337228,1337900,1339053,1339336,1340428,1341029,1341585,1342208,1342556,1349054,1350320,1350661,1351640,1353070,1353384,1353996,1354089,1355509,1355885,1357057,1358192,1359271,1364675,1365151,1365859,1368332,1369205,1370250,1370994,1371028,1371167,1371959,1372043,1372145,1372703,1373854,1375475,1376174,1376328,1376799,1376987,1377350,1380508,1380794,1381706,1382478,1383189,1384416,1385421,1388147,1390474,1394555,1397515,1398054,1398117,1398671,1400726,1404421,1404608,1404766,1404899,1405785,1406134,1406735,1406890,1407391,1407975,1408059,1408830,1408985,1409540,1409767,1410322,1410390,1411148,1411166,1411705,1413456,1414504,1415148,1415341,1417195,1418670,1420941,1421504,1422302,1422455,1423044,1423165,1427014,1429005,1433317,1433789,1433975,1435773,1437485,1438761,1440260,1440762,1441649,1442065,1442498,1443856,1444596,1445393,1445703,1446701,1448348,1449791,1450236,1450561,1450623,1450925,1452087,1452206,1452290,1452336,1452523,1452649,1452963,1453111,1453136,1453957,1454251,1454258,1454267,1456170,1456886,1457962,1460576,1461463,1462684,1464037,1464222,1464457,1467579,1468693,1468872,1470828,1471335,1471352,1472188,1472375,1474295,1474460,1475616,1476050,1477418,1478521,1480493,1480495,1481321,1481561,1484990,1485598,1488034,1489212,1490281,1490440,1490744,1491400,1491905,1495508,1496286,1497256,1498773,1499555,1499765,1501960,1503252,1506281,1506802,1507100,1507370,1508027,1510350,1511061,1511816,1512729,1512733,1512876,1512969,1513000,1513428,1513755,1515393,1515510,1515722,1515942,1518537,1519530,1519944,1520272,1522068,1522241,1522706,1523837,1523924,1524318,1524345,1524353,1526300,1528448,1528698,1529193,1529262,1529591,1532343,1532728,1532969,1533231,1533636,1533641,1533660,1535937,1536469,1536796,1539280,1539590,1539752,1543354,1543544,1545554,1546855,1547858,1547862,1550004,1550104,1550454,1550517,1551473,1552653,1554385,1554612,1555717,1556626,1556799,1557538,1559579,1560283,1560303,1560538,1561263,1562603,1563292,1565558,1565683,1567777,1568347,1568488,1570612,1571268,1573380,1573487,1575803,1575973,1576180,1576444,1577342,1578629,1579242,1580381,1580423,1582841,1583530,1585731,1585946,1586162,1586360,1589178,1589449,1591155,1591344,1592144,1594145,1594418,1595070,1596398,1597223,1598134,1598916,1599784,1601176,1601233,1601408,1603597,1604329,1604433,1604674,1604786,1604998,1605618,1606220,1606288,1611454,1611916,1611938,1612239,1612326,1612449,1616273,1617637,1617945,1618601,1618818,1619247,1620741,1626561,1627451,1628387,1629314,1631448,1631527,1633966,1634609,1637212,1637696,1637948,1639481,1639510,1639850,1639907,1640742,1645875,1647670,1648925,1650185,1651852,1654636,1654732,1655121,1658124,1658460,1659513,1662052,1662129,1662222,1662625,1662748,1665995,1666013,1667424,1668345,1669032,1669588,1670154,1671236,1671457,1671829,1673538,1674251,1674553,1674783,1675295,1677123,1677809,1678253,1678972,1679423,1679605,1679675,1681835,1682403,1683132,1683611,1684321,1684778,1685476,1688773,1691678,1692196,1693130,1693209,1694202,1694510,1695163,1695662,1696201,1698679,1698927,1698988,1699767,1701192,1701687,1702560,1704276,1706101,1707348,1708472,1709509,1713601,1714362,1715175,1715600,1718991,1719525,1720759,1724500,1724987,1725396,1727665,1727998,1730043,1730500,1730798,1731604,1732359,1732709,1737243,1737683,1738368,1742159,1742575,1742939,1743741,1743767,1745353,1746548,1747782,1747867,1748779,1749745,1749775,1750190,1750237,1750812,1751024,1751039,1751243,1751615,1752923,1756749,1759185,1759539,1760093,1760474,1760873,1762112,1763277,1763978,1765218,1766914,1767003,1769215,1769296,1773194,1774072,1774870,1775335,1776013,1776925,1779522,1780780,1783444,1783834,1784911,1785542,1785616,1785870,1786350,1788123,1788165,1790095,1791101,1792842,1793698,1794070,1797220,1797659,1798313,1799790,1799883,1801710,1804221,1804733,1806106,1807725,1807910,1808126,1808405,1808608,1811047,1812205,1812341,1816312,1816449,1818247,1818557,1820545,1820917,1821288,1821739,1821877,1823207,1824440,1825511,1827290,1828019,1831137,1831647,1832826,1833859,1836214,1837389,1837543,1837840,1837897,1839258,1841699,1841926,1844176,1845520,1846446,1847894,1848056,1849301,1849617,1849778,1850311,1853860,1854375,1854413,1855688,1858615,1858747,1859659,1860540,1861553,1862404,1862738,1863168,1865262,1865908,1866140,1866345,1869157,1870214,1871020,1872798,1873037,1874425,1874727,1875604,1875759,1876906,1880036,1880617,1882258,1882895,1883017,1883244,1883279,1885230,1885879,1888530,1888772,1889683,1891238,1891265,1891693,1893101,1895818,1897917,1900896,1901448,1901659,1901861,1902725,1904570,1904745,1905873,1907298,1907306,1907664,1908461,1909827,1911339,1914576,1915343,1916857,1917424,1918289,1919112,1919641,1921974,1922220,1922752,1924372,1924631,1926261,1926282,1926514,1926702,1928621,1928948,1929530,1929794,1930970,1932176,1932236,1937053,1938711,1939238,1940441,1941750,1942724,1942737,1943367,1944231,1944409,1944694,1947082,1947381,1947970,1948222,1948419,1948649,1951592,1956442,1959607,1959837,1960611,1961034,1961623,1961673,1963032,1963642,1964786,1965284,1966039,1966689,1968471,1968599,1969121,1969665,1970080,1970848,1972837,1974585,1975291,1975878,1977361,1979289,1980532,1985051,1985328,1985466,1988144,1989866,1990480,1992122,1992200,1993996,1994136,1994191,1995354,1995578,1995824,1999084,2000914,2003771,2003973,2005037,2005619,2005991,2006551,2007710,2008035,2015622,2016554,2016886,2017321,2018457,2018949,2020300,2021311,2021389,2021699,2022121,2022150,2022252,2022304,2022829,2023150,2023824,2025217,2026029,2026092,2027193,2027838,2028928,2029030,2029209,2029444,2029568,2030799,2034161,2034817,2036750,2040660,2041214,2041411,2041680,2041684,2041736,2041775,2042083,2043880,2044880,2045476,2046546,2048970,2051990,2052238,2053523,2056375,2057028,2058506,2062575,2063886,2067037,2067549,2070080,2070328,2072246,2074470,2074698,2075090,2076201,2078334,2078824,2079900,2079990,2080538,2080641,2082432,2083015,2083804,2083833,2084318,2088811,2088883,2089005,2089039,2090486,2090516,2090767,2091919,2091989,2092724,2093883,2094258,2095429,2098954,2099697,2103114,2103446,2104057,2106199,2107345,2108308,2109108,2109337,2109602,2110550,2110780,2111326,2111909,2114258,2114567,2115740,2115838,2116269,2117733,2118236,2118446,2120454,2121765,2122361,2122398,2124430,2124895,2125663,2127851,2128451,2128972,2132483,2133591,2134102,2138792,2139241,2139953,2140661,2142474,2143034,2143506,2145705,2146544,2146764,2146996,2147218,2148553,2150784,2151429,2151577,2151993,2155204,2156056,2156269,2157050,2157646,2157743,2158545,2160633,2161386,2161983,2163691,2165553,2167063,2169535,2170683,2171846,2172005,2175640,2176926,2177546,2178499,2178687,2178837,2181237,2181944,2183981,2186059,2186405,2186857,2187945,2191640,2191816,2192948,2194124,2194894,2195905,2196956,2197436,2197915,2200987,2201205,2204066,2206889,2207469,2208271,2208359,2208590,2208736,2209846,2209922,2210996,2211425,2212057,2212927,2213916,2214728,2215031,2215146,2215321,2215678,2215851,2217706,2218489,2219587,2219603,2220050,2220915,2220925,2221948,2222707,2223460,2224804,2225546,2226117,2228143,2230405,2230669,2234485,2235062,2235342,2236826,2238182,2240171,2242099,2243349,2245776,2246282,2246890,2247202,2249906,2250291,2250639,2251157,2251338,2254883,2255454,2257144,2257667,2257764,2261605,2261773,2262330,2264607,2264692,2267276,2268469,2274810,2275224,2275539,2277294,2277450,2279068,2279618,2280558,2280698,2282891,2285787,2286938,2288587,2288986,2289936,2291077,2291666,2292028,2293068,2295003,2296538,2296568,2297346,2297479,2297753,2297789,2299294,2300465,2301129,2301619,2302830,2306185,2306878,2307427,2307445,2309890,2310772,2310830,2311378,2312603,2313796,2313967,2314699,2317023,2317343,2318768,2319469,2320504,2320619,2321110,2321696,2325380,2325562,2326774,2327666,2327698,2330066,2332962,2333428,2333552,2333955,2334483,2336416,2336453,2337401,2337454,2337481,2338393,2341433,2341994,2342471,2343235,2344251,2344939,2345255,2346018,2346744,2348577,2349256,2352642,2353105,2353934,2354862,2356844,2356878,2359693,2361150,2362812,2366879,2367254,2368546,2370044,2370539,2371504,2371990,2372791,2373004,2373216,2373385,2373476,2373521,2374423,2375686,2377541,2377628,2379654,2380826,2382047,2385007,2385584,2385730,2386000,2386334,2386808,2387175,2389017,2389329,2390020,2390568,2391303,2391398,2392441,2394377,2394544,2395387,2396166,2396330,2397321,2399016,2399549,2399976,2402417,2402786,2402795,2402808,2403885,2404090,2406734,2408173,2408944,2409600,2410037,2411759,2412153,2412485,2412594,2412619,2413226,2414006,2414255,2415677,2416177,2416577,2417115,2417634,2418232,2418836,2423330,2423522,2424172,2424193,2426524,2426907,2427560,2427723,2430844,2432269,2434774,2435227,2439191,2443586,2444785,2445172,2445553,2446903,2447329,2448709,2448845,2448925,2449517,2449922,2450567,2450803,2451329,2451778,2452329,2452560,2453894,2455051,2455831,2456236,2456563,2457121,2458338,2459277,2459733,2460062,2460900,2461252,2461324,2464062,2465407,2466209,2466301,2467306,2467307,2468352,2469344,2472442,2473482,2476542,2478468,2478520,2479229,2480576,2481407,2482353,2482515,2483057,2485130,2485563,2486337,2488436,2488960,2490290,2492688,2492882,2493100,2495763,2497021,2497736,2498506,2499417,2500374,2500688,2501736,2503349,2503360,2503493,2506168,2506476,2506950,2506953,2507523,2507725,2508078,2508218,2508273,2510624,2510710,2511857,2513187,2514537,2518447,2518805,2520355,2520857,2520945,2523023,2523873,2524319,2525719,2527106,2528386,2529417,2529711,2529895,2530590,2531072,2532255,2534191,2534194,2534709,2536307,2539697,2540233,2540866,2541696,2542367,2542556,2543062,2545930,2546428,2548705,2550316,2550371,2550988,2556475,2556578,2558606,2559588,2563590,2564573,2565412,2565860,2569357,2569647,2571020,2571720,2573513,2573831,2575169,2575306,2577620,2579740,2580023,2580726,2582603,2582721,2584536,2584820,2585546,2586325,2587123,2588277,2589601,2589793,2589955,2590423,2590888,2591084,2591581,2593043,2593953,2594716,2595210,2595498,2595590,2595835,2596704,2598185,2598645,2599062,2599246,2601146,2602945,2603182,2606124,2608245,2608471,2608495,2608803,2610305,2610374,2610678,2610912,2610915,2611305,2611326,2611601,2613345,2613627,2613829,2616149,2617070,2617590,2618881,2618887,2620290,2621186,2621797,2622808,2623750,2624141,2624989,2625590,2626028,2626133,2626378,2626493,2626650,2627359,2627879,2628711,2629766,2629816,2630236,2633786,2634344,2635177,2635912,2639414,2640646,2640967,2641219,2642951,2643179,2643890,2645924,2646395,2648200,2648856,2649833,2650609,2651084,2653270,2655644,2657141,2658284,2659926,2660758,2661578,2661866,2663647,2664854,2664932,2665799,2667775,2669551,2671542,2672533,2672703,2674736,2675200,2678052,2679431,2680778,2682063,2682604,2683479,2684448,2685723,2686429,2687806,2689571,2690486,2691252,2692332,2692352,2695176,2695761,2695979,2697279,2699152,2699179,2699890,2699962,2700394,2700455,2700621,2701006,2701084,2701133,2701720,2701903,2702141,2702401,2702459,2704078,2704289,2707358,2709251,2711307,2712256,2712590,2713870,2714465,2715541,2715952,2717379,2719122,2720328,2721559,2722853,2723144,2724266,2724323,2725724,2726065,2727346,2731968,2732847,2734565,2738067,2738326,2738945,2739165,2739470,2739575,2739828,2740728,2741506,2743912,2744871,2745879,2746008,2746367,2748417,2749345,2749514,2752163,2754070,2755377,2756630,2758499,2758905,2760170,2761325,2761891,2762913,2764010,2764426,2765348,2768398,2768442,2770501,2770850,2771549,2771810,2775021,2775226,2776394,2776482,2778142,2778203,2779046,2779092,2779889,2780198,2781425,2781710,2781978,2783014,2783365,2783417,2783946,2786834,2789095,2789685,2789725,2789915,2790381,2790784,2791146,2791227,2792006,2792076,2792588,2792676,2792919,2793212,2793603,2793919,2794086,2794346,2794980,2796288,2796340,2796473,2796524,2796563,2798123,2798274,2798737,2799870,2801371,2801564,2802026,2803787,2805533,2807147,2807303,2809215,2812184,2812308,2812662,2812713,2815106,2816091,2816204,2816426,2817351,2817898,2818165,2819417,2820362,2820848,2821586,2821832,2822547,2823894,2825116,2825160,2825403,2826071,2827276,2827412,2828381,2828446,2828473,2828751,2828883,2832222,2833391,2834428,2834754,2835303,2836453,2837934,2838491,2840022,2841196,2844529,2845346,2845376,2848647,2848999,2849060,2851177,2851396,2853002,2853398,2854750,2855330,2855672,2856204,2856466,2857143,2858284,2858720,2858775,2859524,2860779,2861144,2862564,2862764,2862804,2865720,2866206,2867298,2868118,2868257,2870379,2870385,2871502,2871677,2872124,2872597,2875238,2876440,2878391,2878429,2878890,2880265,2880796,2881364,2881676,2884387,2885249,2885495,2887880,2888106,2888633,2891706,2892711,2894831,2894895,2895234,2895391,2895504,2899178,2899289,2899616,2899874,2900463,2901215,2901458,2902606,2903691,2903815,2904140,2905217,2907088,2907355,2907431,2908820,2909612,2910101,2910937,2910942,2914905,2914913,2915023,2915815,2916361,2916673,2917005,2920244,2920304,2920600,2922775,2924818,2926128,2928457,2929308,2930077,2930629,2932236,2932391,2932517,2932711,2932803,2933924,2935146,2937284,2939696,2940379,2940810,2941550,2941914,2943883,2944214,2946322,2946614,2946898,2947246,2950704,2951173,2952677,2952703,2953487,2954048,2956823,2958219,2958515,2959561,2961746,2962443,2962502,2963452,2964119,2964735,2965624,2967672,2970397,2971871,2972273,2976119,2977184,2977860,2978585,2978780,2980532,2980946,2981004,2981114,2981122,2981609,2982542,2983820,2983860,2984224,2984646,2984771,2985284,2986298,2987681,2988035,2988703,2989074,2989381,2989867,2990906,2993633,2995133) AND 1=1) AND 1=1) ORDER BY "RelationTable"."id" ASC;

Taking whopping 300ms to execute.

Now we don't need to join with the same table to get the same results, using a bit faster but still monstrous query:

SELECT
    "sql_load_test"."Post"."id",
    "sql_load_test"."Post"."author" AS "__ParentModel__"
FROM
    "sql_load_test"."Post"
WHERE "sql_load_test"."Post"."author" IN (1,675,917,1494,3128,3219,3645,3984,4658,6766,8014,8598,8719,9114,9365,9876,10281,10499,11858,12399,13499,13831,13968,14370,14754,15138,15140,15861,15896,16589,16626,16804,16867,18817,19684,19780,19914,20545,20647,20926,21531,22406,24258,24625,26738,27016,27203,28583,32909,33559,33638,34349,34943,36564,36648,37009,37061,37184,37374,38326,39730,39861,41302,43395,44030,44037,44673,45298,45524,46300,47702,47748,49337,55260,57094,57771,58402,58489,58775,59041,59531,60670,61578,65303,66039,66149,66460,68329,68496,68621,69465,69659,71399,71503,71780,72900,73014,73200,73735,74959,74989,75309,76209,76925,77487,77517,78819,79912,80366,80554,81693,82285,82455,83202,83396,83531,84272,86180,87026,88696,90352,91595,92006,92899,94154,95441,96672,97534,97570,98025,99459,100308,101241,102056,102106,102985,106467,106765,107043,108679,111376,113372,114890,115961,117177,118662,121921,122597,122869,123943,124753,125448,126847,127840,131620,135129,135839,135968,136313,136783,136903,137231,137261,138095,138135,140111,141094,141522,141558,142581,143147,143252,143693,146030,146238,146590,148223,150279,152542,153248,154566,155541,158745,160794,160954,160982,164941,165886,166337,166398,166990,167718,168611,171275,172451,172675,173154,174544,176011,176568,176745,177855,178046,178927,180834,181414,181649,181687,185247,185651,188034,188281,189052,189067,189494,192726,192965,193618,194082,194102,196321,200842,204012,204026,206658,207333,208721,209396,210520,215549,216683,220716,221794,221961,222690,224381,226940,227862,228963,229871,230833,232503,232965,233520,235124,235199,235869,236456,238462,238731,239786,239874,243040,246046,247089,247207,248808,248827,250158,250467,251266,251703,254690,257960,258963,259957,260147,261309,261488,261912,262083,263384,264205,264436,264858,265425,266890,267532,269591,270070,271159,271786,272588,274291,274591,274765,276797,279526,280244,283108,284852,285358,286057,286789,287259,288251,288631,289926,290712,292004,292267,292608,293575,294875,295462,295627,296478,296757,298099,298256,299737,300768,301963,302356,304902,305101,305157,306300,308773,311362,311693,313103,315654,316120,317325,317703,318243,318535,319074,319678,322317,323966,324913,325920,328616,329638,330365,331029,331273,331578,331862,332980,334497,336229,336822,336857,337209,338241,338748,339394,339441,339764,339854,341121,341278,341632,341674,341886,343031,345193,345670,348059,348539,348675,348811,348898,353092,353324,355821,356557,356864,356951,360590,360713,361437,363016,363456,363930,365932,366231,366927,367674,369401,370100,371113,371237,374255,374271,374753,375428,376132,376579,376647,377028,378226,378895,379104,379901,379965,380268,380326,381906,381909,382368,384503,385324,385588,385701,387667,392187,392646,395766,396498,396505,397017,397254,397834,398336,398618,398876,400791,401730,401987,402973,405483,406627,407340,408074,408478,410446,410646,410893,412590,413299,414506,414556,416515,417064,417464,417475,418093,418443,418818,418983,419514,421097,421694,422210,422872,423287,424112,425851,426066,428760,430129,430754,430797,431942,432368,433249,434751,435913,436285,439123,439730,441031,442138,442300,443341,444393,444559,444642,444699,445252,445829,446288,447616,448088,450491,452934,452981,453578,453887,453905,455787,456555,457459,458664,459697,461520,462024,462036,462807,463901,466204,467306,467711,468324,471276,472885,473448,473625,474767,476228,478112,478581,479977,480841,481986,482917,484680,486045,487356,490318,491135,491199,491462,491693,491940,492599,492867,496983,498249,498259,498646,499478,499566,501664,501734,502635,503056,503825,503842,504835,505358,505515,506427,506513,506837,509324,509765,511315,512419,512564,512692,512925,513958,517331,518778,519538,520191,520585,520652,521212,523313,524079,525009,526497,527072,531403,533741,536735,536992,537291,539070,539072,539124,542431,544217,545682,546680,547401,548296,550300,550324,551142,551198,551945,552152,554330,555059,557778,559538,559912,561026,561836,562262,562276,562673,563421,564007,564193,565883,566791,567894,571168,571811,572825,573371,574000,574017,574108,574253,574267,575064,577962,578268,579199,579504,579779,579954,581400,582508,583109,583254,585607,585811,586746,587240,588373,589424,589632,589752,590664,590744,591172,591374,591544,591691,591947,592904,594750,595457,596326,596707,597552,600560,600985,602773,602816,603478,605556,606381,608214,608421,609437,613173,616483,616910,617231,617459,619209,620419,620538,621377,622538,622895,623847,625586,626046,626801,627675,628875,629335,630517,630820,630845,631181,631885,634493,634836,635872,637136,637842,640198,642698,642910,644902,646886,647480,647883,648642,649361,649791,650060,651412,654773,655680,659386,661277,661706,663078,663585,664193,664311,670033,671890,672007,672826,673842,674043,676625,676899,677354,678084,678728,681599,682315,682357,683106,683765,683839,684467,685720,686532,687303,687530,687670,687781,687856,688095,688707,690062,697085,697840,698163,698515,698626,699387,699774,700313,700828,701453,701775,702533,703958,704847,705836,706022,706811,709063,709157,710758,710966,712638,712670,712768,713050,715493,715756,716718,719524,719661,719909,720310,720808,721107,722120,722763,723913,724543,726487,727266,728666,729487,729537,731502,732617,733386,734502,735273,735814,736840,738426,738514,741729,742497,744297,749134,749839,750748,751990,753626,753701,754706,756000,756369,756910,758937,759889,760033,760063,760215,762734,763940,766511,766641,766792,769167,772950,772983,773591,778937,780894,781809,782035,782217,782798,782983,783069,783609,785380,785549,785554,785555,787269,787414,787921,789400,789543,790341,790444,792167,792448,793603,793724,794842,795948,796022,796539,800123,800689,802159,803271,803503,803711,805360,805544,805665,805965,806196,807103,807589,807921,808098,811322,811610,812563,812666,814000,816663,818249,819184,819842,821376,821864,824099,827394,827521,828053,828539,833589,833620,834433,835078,835352,837997,841110,841266,841567,841594,843059,845136,845612,846045,849809,850167,850282,850473,850629,851492,851803,852037,852864,854457,856698,857122,857435,857938,858432,859964,860349,860477,862837,864426,865911,866387,867484,867997,868705,869809,869848,870659,870973,871499,872311,873392,873455,878957,879355,881036,882399,882453,883075,883090,884024,884670,885276,886162,886589,886902,887161,887226,887290,890701,894302,895654,903000,904091,905738,906323,907244,907964,908147,908208,908461,908780,908928,912357,912619,914138,914455,915551,916897,916934,918999,919241,919485,920985,923149,923199,923295,924098,924442,925211,925930,926384,926739,927393,928633,931868,934931,935192,935207,935807,936450,939984,940337,947383,947574,948130,948392,948668,949240,949450,950575,952437,954444,954648,954654,954732,955767,956174,956638,956910,957719,961418,961485,961985,963236,965725,967031,967702,967781,968248,970795,971281,971521,971605,972567,973381,975116,976915,979240,982023,984832,987251,987596,987971,989414,991054,992010,992228,992693,994292,995118,996714,996784,996803,996833,997196,997555,999253,1000157,1000198,1001530,1002462,1003045,1003200,1003787,1005510,1006016,1006400,1006783,1007037,1007082,1008634,1009335,1009396,1010536,1011406,1011478,1011747,1012462,1014933,1015221,1017021,1017953,1018058,1018229,1018984,1019683,1020292,1020734,1022426,1025713,1026419,1028268,1028844,1029691,1031284,1032894,1034830,1036254,1036683,1037165,1037462,1037773,1038377,1039232,1040041,1040126,1040776,1041017,1042022,1042273,1042641,1043668,1043680,1046066,1047616,1048869,1049596,1050261,1050288,1050500,1051211,1053400,1054690,1056116,1057331,1058781,1058846,1060490,1060795,1061147,1061374,1061709,1061839,1063367,1063997,1066908,1067429,1067657,1067773,1068290,1071120,1071255,1071842,1072420,1072670,1073643,1079698,1080420,1081677,1082964,1084740,1090225,1090624,1092265,1092495,1098478,1099709,1099786,1100042,1101982,1103861,1105172,1106043,1107273,1107567,1111456,1111506,1112311,1112370,1112438,1113553,1113898,1113955,1114122,1115033,1117436,1119773,1120656,1122312,1123362,1123991,1124633,1125016,1125028,1125033,1125393,1125456,1125770,1126256,1126791,1128584,1128658,1129761,1130434,1130753,1131408,1131840,1132476,1133930,1134621,1135255,1138488,1140655,1141269,1141694,1145486,1146193,1146914,1147995,1148023,1148223,1148603,1148853,1149078,1150627,1150832,1152379,1153081,1153633,1159085,1159184,1160104,1160419,1160659,1162289,1163804,1164904,1165010,1165510,1166790,1168315,1168500,1170845,1171820,1172172,1172504,1174143,1174988,1176660,1177669,1179370,1180798,1181335,1182551,1184293,1184719,1187087,1190244,1190542,1191841,1194947,1195610,1196509,1201865,1202123,1202964,1203398,1204001,1205102,1205181,1205862,1207897,1209783,1209960,1210891,1211650,1211823,1212005,1212860,1213315,1213682,1213796,1214320,1214939,1215249,1216269,1217746,1219004,1219182,1219234,1219870,1220046,1220818,1220912,1222340,1222814,1222853,1223154,1224123,1225973,1226741,1227414,1228867,1229174,1230636,1232420,1233251,1236114,1236998,1237687,1239054,1239773,1240120,1240626,1242202,1243069,1244183,1244381,1245086,1247327,1249044,1249995,1250315,1250367,1250384,1253901,1256836,1257292,1257526,1258007,1258261,1258699,1259799,1259972,1260086,1261313,1261332,1261848,1262717,1262798,1263619,1263961,1264063,1264270,1265076,1265555,1266624,1266942,1268959,1270248,1271105,1273531,1273768,1275942,1275972,1279011,1281531,1282763,1283528,1283709,1285102,1286415,1288346,1289105,1290340,1291364,1292451,1294565,1299689,1300147,1300321,1300534,1300914,1301953,1302045,1304189,1304646,1304877,1307910,1308712,1311589,1315698,1316296,1316980,1319182,1319976,1320289,1320403,1320508,1320550,1320825,1323109,1325831,1325951,1326798,1327180,1327437,1327820,1328937,1330808,1331663,1331901,1333010,1333051,1335878,1337038,1337228,1337900,1339053,1339336,1340428,1341029,1341585,1342208,1342556,1349054,1350320,1350661,1351640,1353070,1353384,1353996,1354089,1355509,1355885,1357057,1358192,1359271,1364675,1365151,1365859,1368332,1369205,1370250,1370994,1371028,1371167,1371959,1372043,1372145,1372703,1373854,1375475,1376174,1376328,1376799,1376987,1377350,1380508,1380794,1381706,1382478,1383189,1384416,1385421,1388147,1390474,1394555,1397515,1398054,1398117,1398671,1400726,1404421,1404608,1404766,1404899,1405785,1406134,1406735,1406890,1407391,1407975,1408059,1408830,1408985,1409540,1409767,1410322,1410390,1411148,1411166,1411705,1413456,1414504,1415148,1415341,1417195,1418670,1420941,1421504,1422302,1422455,1423044,1423165,1427014,1429005,1433317,1433789,1433975,1435773,1437485,1438761,1440260,1440762,1441649,1442065,1442498,1443856,1444596,1445393,1445703,1446701,1448348,1449791,1450236,1450561,1450623,1450925,1452087,1452206,1452290,1452336,1452523,1452649,1452963,1453111,1453136,1453957,1454251,1454258,1454267,1456170,1456886,1457962,1460576,1461463,1462684,1464037,1464222,1464457,1467579,1468693,1468872,1470828,1471335,1471352,1472188,1472375,1474295,1474460,1475616,1476050,1477418,1478521,1480493,1480495,1481321,1481561,1484990,1485598,1488034,1489212,1490281,1490440,1490744,1491400,1491905,1495508,1496286,1497256,1498773,1499555,1499765,1501960,1503252,1506281,1506802,1507100,1507370,1508027,1510350,1511061,1511816,1512729,1512733,1512876,1512969,1513000,1513428,1513755,1515393,1515510,1515722,1515942,1518537,1519530,1519944,1520272,1522068,1522241,1522706,1523837,1523924,1524318,1524345,1524353,1526300,1528448,1528698,1529193,1529262,1529591,1532343,1532728,1532969,1533231,1533636,1533641,1533660,1535937,1536469,1536796,1539280,1539590,1539752,1543354,1543544,1545554,1546855,1547858,1547862,1550004,1550104,1550454,1550517,1551473,1552653,1554385,1554612,1555717,1556626,1556799,1557538,1559579,1560283,1560303,1560538,1561263,1562603,1563292,1565558,1565683,1567777,1568347,1568488,1570612,1571268,1573380,1573487,1575803,1575973,1576180,1576444,1577342,1578629,1579242,1580381,1580423,1582841,1583530,1585731,1585946,1586162,1586360,1589178,1589449,1591155,1591344,1592144,1594145,1594418,1595070,1596398,1597223,1598134,1598916,1599784,1601176,1601233,1601408,1603597,1604329,1604433,1604674,1604786,1604998,1605618,1606220,1606288,1611454,1611916,1611938,1612239,1612326,1612449,1616273,1617637,1617945,1618601,1618818,1619247,1620741,1626561,1627451,1628387,1629314,1631448,1631527,1633966,1634609,1637212,1637696,1637948,1639481,1639510,1639850,1639907,1640742,1645875,1647670,1648925,1650185,1651852,1654636,1654732,1655121,1658124,1658460,1659513,1662052,1662129,1662222,1662625,1662748,1665995,1666013,1667424,1668345,1669032,1669588,1670154,1671236,1671457,1671829,1673538,1674251,1674553,1674783,1675295,1677123,1677809,1678253,1678972,1679423,1679605,1679675,1681835,1682403,1683132,1683611,1684321,1684778,1685476,1688773,1691678,1692196,1693130,1693209,1694202,1694510,1695163,1695662,1696201,1698679,1698927,1698988,1699767,1701192,1701687,1702560,1704276,1706101,1707348,1708472,1709509,1713601,1714362,1715175,1715600,1718991,1719525,1720759,1724500,1724987,1725396,1727665,1727998,1730043,1730500,1730798,1731604,1732359,1732709,1737243,1737683,1738368,1742159,1742575,1742939,1743741,1743767,1745353,1746548,1747782,1747867,1748779,1749745,1749775,1750190,1750237,1750812,1751024,1751039,1751243,1751615,1752923,1756749,1759185,1759539,1760093,1760474,1760873,1762112,1763277,1763978,1765218,1766914,1767003,1769215,1769296,1773194,1774072,1774870,1775335,1776013,1776925,1779522,1780780,1783444,1783834,1784911,1785542,1785616,1785870,1786350,1788123,1788165,1790095,1791101,1792842,1793698,1794070,1797220,1797659,1798313,1799790,1799883,1801710,1804221,1804733,1806106,1807725,1807910,1808126,1808405,1808608,1811047,1812205,1812341,1816312,1816449,1818247,1818557,1820545,1820917,1821288,1821739,1821877,1823207,1824440,1825511,1827290,1828019,1831137,1831647,1832826,1833859,1836214,1837389,1837543,1837840,1837897,1839258,1841699,1841926,1844176,1845520,1846446,1847894,1848056,1849301,1849617,1849778,1850311,1853860,1854375,1854413,1855688,1858615,1858747,1859659,1860540,1861553,1862404,1862738,1863168,1865262,1865908,1866140,1866345,1869157,1870214,1871020,1872798,1873037,1874425,1874727,1875604,1875759,1876906,1880036,1880617,1882258,1882895,1883017,1883244,1883279,1885230,1885879,1888530,1888772,1889683,1891238,1891265,1891693,1893101,1895818,1897917,1900896,1901448,1901659,1901861,1902725,1904570,1904745,1905873,1907298,1907306,1907664,1908461,1909827,1911339,1914576,1915343,1916857,1917424,1918289,1919112,1919641,1921974,1922220,1922752,1924372,1924631,1926261,1926282,1926514,1926702,1928621,1928948,1929530,1929794,1930970,1932176,1932236,1937053,1938711,1939238,1940441,1941750,1942724,1942737,1943367,1944231,1944409,1944694,1947082,1947381,1947970,1948222,1948419,1948649,1951592,1956442,1959607,1959837,1960611,1961034,1961623,1961673,1963032,1963642,1964786,1965284,1966039,1966689,1968471,1968599,1969121,1969665,1970080,1970848,1972837,1974585,1975291,1975878,1977361,1979289,1980532,1985051,1985328,1985466,1988144,1989866,1990480,1992122,1992200,1993996,1994136,1994191,1995354,1995578,1995824,1999084,2000914,2003771,2003973,2005037,2005619,2005991,2006551,2007710,2008035,2015622,2016554,2016886,2017321,2018457,2018949,2020300,2021311,2021389,2021699,2022121,2022150,2022252,2022304,2022829,2023150,2023824,2025217,2026029,2026092,2027193,2027838,2028928,2029030,2029209,2029444,2029568,2030799,2034161,2034817,2036750,2040660,2041214,2041411,2041680,2041684,2041736,2041775,2042083,2043880,2044880,2045476,2046546,2048970,2051990,2052238,2053523,2056375,2057028,2058506,2062575,2063886,2067037,2067549,2070080,2070328,2072246,2074470,2074698,2075090,2076201,2078334,2078824,2079900,2079990,2080538,2080641,2082432,2083015,2083804,2083833,2084318,2088811,2088883,2089005,2089039,2090486,2090516,2090767,2091919,2091989,2092724,2093883,2094258,2095429,2098954,2099697,2103114,2103446,2104057,2106199,2107345,2108308,2109108,2109337,2109602,2110550,2110780,2111326,2111909,2114258,2114567,2115740,2115838,2116269,2117733,2118236,2118446,2120454,2121765,2122361,2122398,2124430,2124895,2125663,2127851,2128451,2128972,2132483,2133591,2134102,2138792,2139241,2139953,2140661,2142474,2143034,2143506,2145705,2146544,2146764,2146996,2147218,2148553,2150784,2151429,2151577,2151993,2155204,2156056,2156269,2157050,2157646,2157743,2158545,2160633,2161386,2161983,2163691,2165553,2167063,2169535,2170683,2171846,2172005,2175640,2176926,2177546,2178499,2178687,2178837,2181237,2181944,2183981,2186059,2186405,2186857,2187945,2191640,2191816,2192948,2194124,2194894,2195905,2196956,2197436,2197915,2200987,2201205,2204066,2206889,2207469,2208271,2208359,2208590,2208736,2209846,2209922,2210996,2211425,2212057,2212927,2213916,2214728,2215031,2215146,2215321,2215678,2215851,2217706,2218489,2219587,2219603,2220050,2220915,2220925,2221948,2222707,2223460,2224804,2225546,2226117,2228143,2230405,2230669,2234485,2235062,2235342,2236826,2238182,2240171,2242099,2243349,2245776,2246282,2246890,2247202,2249906,2250291,2250639,2251157,2251338,2254883,2255454,2257144,2257667,2257764,2261605,2261773,2262330,2264607,2264692,2267276,2268469,2274810,2275224,2275539,2277294,2277450,2279068,2279618,2280558,2280698,2282891,2285787,2286938,2288587,2288986,2289936,2291077,2291666,2292028,2293068,2295003,2296538,2296568,2297346,2297479,2297753,2297789,2299294,2300465,2301129,2301619,2302830,2306185,2306878,2307427,2307445,2309890,2310772,2310830,2311378,2312603,2313796,2313967,2314699,2317023,2317343,2318768,2319469,2320504,2320619,2321110,2321696,2325380,2325562,2326774,2327666,2327698,2330066,2332962,2333428,2333552,2333955,2334483,2336416,2336453,2337401,2337454,2337481,2338393,2341433,2341994,2342471,2343235,2344251,2344939,2345255,2346018,2346744,2348577,2349256,2352642,2353105,2353934,2354862,2356844,2356878,2359693,2361150,2362812,2366879,2367254,2368546,2370044,2370539,2371504,2371990,2372791,2373004,2373216,2373385,2373476,2373521,2374423,2375686,2377541,2377628,2379654,2380826,2382047,2385007,2385584,2385730,2386000,2386334,2386808,2387175,2389017,2389329,2390020,2390568,2391303,2391398,2392441,2394377,2394544,2395387,2396166,2396330,2397321,2399016,2399549,2399976,2402417,2402786,2402795,2402808,2403885,2404090,2406734,2408173,2408944,2409600,2410037,2411759,2412153,2412485,2412594,2412619,2413226,2414006,2414255,2415677,2416177,2416577,2417115,2417634,2418232,2418836,2423330,2423522,2424172,2424193,2426524,2426907,2427560,2427723,2430844,2432269,2434774,2435227,2439191,2443586,2444785,2445172,2445553,2446903,2447329,2448709,2448845,2448925,2449517,2449922,2450567,2450803,2451329,2451778,2452329,2452560,2453894,2455051,2455831,2456236,2456563,2457121,2458338,2459277,2459733,2460062,2460900,2461252,2461324,2464062,2465407,2466209,2466301,2467306,2467307,2468352,2469344,2472442,2473482,2476542,2478468,2478520,2479229,2480576,2481407,2482353,2482515,2483057,2485130,2485563,2486337,2488436,2488960,2490290,2492688,2492882,2493100,2495763,2497021,2497736,2498506,2499417,2500374,2500688,2501736,2503349,2503360,2503493,2506168,2506476,2506950,2506953,2507523,2507725,2508078,2508218,2508273,2510624,2510710,2511857,2513187,2514537,2518447,2518805,2520355,2520857,2520945,2523023,2523873,2524319,2525719,2527106,2528386,2529417,2529711,2529895,2530590,2531072,2532255,2534191,2534194,2534709,2536307,2539697,2540233,2540866,2541696,2542367,2542556,2543062,2545930,2546428,2548705,2550316,2550371,2550988,2556475,2556578,2558606,2559588,2563590,2564573,2565412,2565860,2569357,2569647,2571020,2571720,2573513,2573831,2575169,2575306,2577620,2579740,2580023,2580726,2582603,2582721,2584536,2584820,2585546,2586325,2587123,2588277,2589601,2589793,2589955,2590423,2590888,2591084,2591581,2593043,2593953,2594716,2595210,2595498,2595590,2595835,2596704,2598185,2598645,2599062,2599246,2601146,2602945,2603182,2606124,2608245,2608471,2608495,2608803,2610305,2610374,2610678,2610912,2610915,2611305,2611326,2611601,2613345,2613627,2613829,2616149,2617070,2617590,2618881,2618887,2620290,2621186,2621797,2622808,2623750,2624141,2624989,2625590,2626028,2626133,2626378,2626493,2626650,2627359,2627879,2628711,2629766,2629816,2630236,2633786,2634344,2635177,2635912,2639414,2640646,2640967,2641219,2642951,2643179,2643890,2645924,2646395,2648200,2648856,2649833,2650609,2651084,2653270,2655644,2657141,2658284,2659926,2660758,2661578,2661866,2663647,2664854,2664932,2665799,2667775,2669551,2671542,2672533,2672703,2674736,2675200,2678052,2679431,2680778,2682063,2682604,2683479,2684448,2685723,2686429,2687806,2689571,2690486,2691252,2692332,2692352,2695176,2695761,2695979,2697279,2699152,2699179,2699890,2699962,2700394,2700455,2700621,2701006,2701084,2701133,2701720,2701903,2702141,2702401,2702459,2704078,2704289,2707358,2709251,2711307,2712256,2712590,2713870,2714465,2715541,2715952,2717379,2719122,2720328,2721559,2722853,2723144,2724266,2724323,2725724,2726065,2727346,2731968,2732847,2734565,2738067,2738326,2738945,2739165,2739470,2739575,2739828,2740728,2741506,2743912,2744871,2745879,2746008,2746367,2748417,2749345,2749514,2752163,2754070,2755377,2756630,2758499,2758905,2760170,2761325,2761891,2762913,2764010,2764426,2765348,2768398,2768442,2770501,2770850,2771549,2771810,2775021,2775226,2776394,2776482,2778142,2778203,2779046,2779092,2779889,2780198,2781425,2781710,2781978,2783014,2783365,2783417,2783946,2786834,2789095,2789685,2789725,2789915,2790381,2790784,2791146,2791227,2792006,2792076,2792588,2792676,2792919,2793212,2793603,2793919,2794086,2794346,2794980,2796288,2796340,2796473,2796524,2796563,2798123,2798274,2798737,2799870,2801371,2801564,2802026,2803787,2805533,2807147,2807303,2809215,2812184,2812308,2812662,2812713,2815106,2816091,2816204,2816426,2817351,2817898,2818165,2819417,2820362,2820848,2821586,2821832,2822547,2823894,2825116,2825160,2825403,2826071,2827276,2827412,2828381,2828446,2828473,2828751,2828883,2832222,2833391,2834428,2834754,2835303,2836453,2837934,2838491,2840022,2841196,2844529,2845346,2845376,2848647,2848999,2849060,2851177,2851396,2853002,2853398,2854750,2855330,2855672,2856204,2856466,2857143,2858284,2858720,2858775,2859524,2860779,2861144,2862564,2862764,2862804,2865720,2866206,2867298,2868118,2868257,2870379,2870385,2871502,2871677,2872124,2872597,2875238,2876440,2878391,2878429,2878890,2880265,2880796,2881364,2881676,2884387,2885249,2885495,2887880,2888106,2888633,2891706,2892711,2894831,2894895,2895234,2895391,2895504,2899178,2899289,2899616,2899874,2900463,2901215,2901458,2902606,2903691,2903815,2904140,2905217,2907088,2907355,2907431,2908820,2909612,2910101,2910937,2910942,2914905,2914913,2915023,2915815,2916361,2916673,2917005,2920244,2920304,2920600,2922775,2924818,2926128,2928457,2929308,2930077,2930629,2932236,2932391,2932517,2932711,2932803,2933924,2935146,2937284,2939696,2940379,2940810,2941550,2941914,2943883,2944214,2946322,2946614,2946898,2947246,2950704,2951173,2952677,2952703,2953487,2954048,2956823,2958219,2958515,2959561,2961746,2962443,2962502,2963452,2964119,2964735,2965624,2967672,2970397,2971871,2972273,2976119,2977184,2977860,2978585,2978780,2980532,2980946,2981004,2981114,2981122,2981609,2982542,2983820,2983860,2984224,2984646,2984771,2985284,2986298,2987681,2988035,2988703,2989074,2989381,2989867,2990906,2993633,2995133) ORDER BY "sql_load_test"."Post"."id" ASC;

Resulting in 170ms execution time.

Now if we'd be smart, we'd skip the two queries and combine them into one:

SELECT
    p."id",
    p."author" AS "__ParentModel__"
FROM
    "sql_load_test"."Post" p
INNER JOIN "sql_load_test"."User" u ON u.id = p.author
WHERE u."lastName" = 'Face' ORDER BY p."id" ASC;

This skips one roundtrip, but the resulting query is not that much faster, execution time being 170ms.

Before starting the ticket we should consider:

• How easy it is to get to the last query here, running only one query instead of two.
• Or should we just try to optimize the join away when joining against the same table.

Would both of these options break some use cases?

[mavilein]

Optimizing the join away would the most awesome thing to do. I think that this might be doable in core of the query engine actually. The problem here is that we are using a RelationFilter which always results in a join. We should consider to swap this filter with a ScalarFilter in case the relation is inlined in the same table.
The benefit of this would be that all connectors would benefit from this optimization.

[pimeys]

This should be work done after merging the Dom Branch (tm) and asyncification?

[pimeys]

So, if we start working on the async/await tomorrow with Dom, I doubt this will be in p16.

[janpio]

P16 milestone only means that it is being worked on right now, if it is not done we will move it over to P17.

[pimeys]

I will spend some time here this week :)