机器数 :1
磁盘类型 :HDD
CPU 核数 :4C
内存大小:64GB
NebulaGraph 版本号 3.0
服务状态,使用 show hosts 语句
图空间 : optical_route_plan_ZH
查询语句,需要调优的那条语句
FIND NOLOOP PATH WITH PROP FROM 100422 TO 100324 OVER edge_join where edge_join.road_fid not in [3835,3921] and edge_join._src in [1917,1974,1961,1919,101153,1970,1988,1951,1667,1661,1810,1811,1800,100658,1815,1807,1834,1472,1468,1777,1776,1802,1801,1857,1692,1695,1831,1775,1792,1669,1675,1605,1688,1644,1604,1634,1665,101252,1673,1703,1799,1827,1728,1727,1804,1805,1816,1733,1895,1751,1761,1778,100229,100230,1793,1809,1824,1700,1852,1720,1737,1749,1770,1790,1818,1765,1704,1830,1740,1806,1759,100063,1902,1791,1890,1907,1698,1814,1697,1682,1649,1668,1640,1678,1503,1511,100032,100031,1500,1721,1750,1783,1803,100062,1742,100517,1773,1694,100423,100422,100334,1734,100335,1766,1781,1730,1696,100324,1722,1508,1613,1620,1663,1674,1618,1619,1625,1581,1639,1861,1756,1710,1747,1707,1764,1744,1702,1882,1741,1656,1670,1626,1565,1652,1657,1642,1629,1680,1496,1828,1699,1739,1752,1872,1871,1746,1715,1723,1731,1647,1662,1631,100276,1654,1651,1638,1587,1645,1540,1817,1849,100439,100440,1859,1839,1889,1822,1691,1838,100277,1637,1684,1588,1623,1528,100896,1672,1612,1608,1607,1610,1611,1602,100520,1666,1628,1595,1650,1876,1846,1758,1788,1795,1797,1796,1853,1789,1701,1636,1614,1627,100975,1709,1714,1736,100344,100614] and edge_join._dst in [1917,1974,1961,1919,101153,1970,1988,1951,1667,1661,1810,1811,1800,100658,1815,1807,1834,1472,1468,1777,1776,1802,1801,1857,1692,1695,1831,1775,1792,1669,1675,1605,1688,1644,1604,1634,1665,101252,1673,1703,1799,1827,1728,1727,1804,1805,1816,1733,1895,1751,1761,1778,100229,100230,1793,1809,1824,1700,1852,1720,1737,1749,1770,1790,1818,1765,1704,1830,1740,1806,1759,100063,1902,1791,1890,1907,1698,1814,1697,1682,1649,1668,1640,1678,1503,1511,100032,100031,1500,1721,1750,1783,1803,100062,1742,100517,1773,1694,100423,100422,100334,1734,100335,1766,1781,1730,1696,100324,1722,1508,1613,1620,1663,1674,1618,1619,1625,1581,1639,1861,1756,1710,1747,1707,1764,1744,1702,1882,1741,1656,1670,1626,1565,1652,1657,1642,1629,1680,1496,1828,1699,1739,1752,1872,1871,1746,1715,1723,1731,1647,1662,1631,100276,1654,1651,1638,1587,1645,1540,1817,1849,100439,100440,1859,1839,1889,1822,1691,1838,100277,1637,1684,1588,1623,1528,100896,1672,1612,1608,1607,1610,1611,1602,100520,1666,1628,1595,1650,1876,1846,1758,1788,1795,1797,1796,1853,1789,1701,1636,1614,1627,100975,1709,1714,1736,100344,100614] and (edge_join.edge_type in ["1"] or ((edge_join._src in [100422,100324] or edge_join._dst in [100422,100324 ]) and edge_join.edge_type in ["2"] ) ) UPTO 14 STEPS YIELD path as p |limit 100 ;
数据量,7k 节点,3w条边
profile 信息,使用 profile query 语句