QUERY PLAN
Group (cost=5840.60..5879.07 rows=1399 width=52)
Group Key: u.pinyin1, u.namecut1, u.pinyin2, u.namecut2, u.pinyin3, u.namecut3, u.pinyin4, u.namecut4, rvr.user_id, u.name
-> Sort (cost=5840.60..5844.10 rows=1399 width=44)
Sort Key: u.pinyin1 NULLS FIRST, u.namecut1 NULLS FIRST, u.pinyin2 NULLS FIRST, u.namecut2 NULLS FIRST, u.pinyin3 NULLS FIRST, u.namecut3 NULLS FIRST, u.pinyin4 NULLS FIRST, u.namecut4 NULLS FIRST, rvr.user_id, u.name
-> Hash Left Join (cost=9.17..5767.50 rows=1399 width=44)
Hash Cond: (rvr.user_id = u.id)
-> Seq Scan on tbl_approve_verify_rels rvr (cost=0.00..5754.54 rows=1399 width=4)
Filter: (approve_id = ANY ('{2121,2126,2123,2122,2125,2120,2124,1407,2059,1752,1749,1474,1777,2088,2093,1391,1778,1860,1131,1119,1971,1689,1241,1175,1191,1763,1594,1371,2013,1666,1422,1428,1718,113,1479,1514,1546,1526,1559,1561,1574,1575,2119,1359,1606,1924,1081,2108,1678,1353,1795,1890,1911,1951,1958,1974,1998,2010,1362,7,166,1863,356,382,381,435,486,1254,543,572,647,712,764,858,901,971,917,922,935,1010,1007,1020,1027,1028,1057,1123,1107,1113,1176,1207,1227,1313,1475,497,1323,1328,1339,1870,1460,1871,1461,1462,1463,1472,1473,418,293,1484,1485,1495,1483,1879,426,1884,1510,1511,1891,1892,367,1518,1520,504,1853,1522,1525,1529,1530,1531,1532,1916,1917,1918,1535,1542,1543,1544,1922,1550,1553,1928,1934,1558,1935,1569,1937,1938,1939,1942,1943,453,457,1579,1583,1584,1588,1589,460,461,1592,1596,1585,1599,462,511,1597,1603,1604,1608,1612,1613,1615,1616,1618,1619,1607,1952,1633,1929,1956,1960,1961,1965,1959,1189,562,1796,1641,1646,1647,1840,637,1649,1605,1650,1651,1659,1670,1671,1668,1669,1685,1043,1694,659,671,1702,1708,1709,1710,1711,1712,688,703,704,718,1724,999,1734,1738,1739,1740,1741,1748,729,746,1753,758,760,761,763,769,1973,1975,1976,1769,1772,1767,1779,1780,1787,784,797,1798,1978,1979,1981,1985,1984,839,1983,855,854,1991,1996,862,876,2002,2007,2008,830,2011,2017,2021,2022,2023,919,933,940,943,944,1804,1814,972,987,1001,1003,1318,1819,1820,1047,1048,1829,1052,1053,1060,1061,1063,1069,1109,1110,1118,1847,1848,1135,1140,1148,1208,1225,1351,1238,1245,1258,1262,1263,1264,1265,1267,1268,1266,1269,1272,1273,1277,1276,1280,1286,1287,1288,1292,1296,1352,1304,1305,1306,1307,1309,1312,1317,1316,1320,2086,1322,1324,1326,1329,1330,1334,1340,1342,1343,1348,1350,1358,1363,1364,1367,1376,1377,1382,1383,1384,1385,1386,1392,1398,1409,1410,1411,1429,1430,1431,1441,1442,1444,1448,2028,2087,1174,2031,2032,2034,2027,2026,2041,2048,2051,2055,2056,2057,2058,2062,2049,2074,2080,2090,2094,2098,2099,2100,2101,2097,1178,1742,57,1755,143,1746,1730,101,105,102,125,1130,108,2089,1180,107,109,111,115,685,117,120,149,1260,1771,1761,1499,708,1785,1521,2084,255,1538,1789,1637,493,692,742,1836,856,1534,205,170,183,171,178,1127,172,184,181,177,185,189,187,188,194,1136,1137,1889,1881,1138,1120,1108,1164,1128,1126,1141,1129,1132,1145,1133,1146,1144,1923,1595,1025,1067,1677,1681,1235,1690,1697,1894,1295,1704,1855,2001,1327,219,362,924,580,827,866,931,983,1029,1068,1184,1223,1282,1768,1774,1554,451,1838,1076,393,568,565,54,1729,200,1501,316,203,206,627,1192,498,1181,1186,1271,969,808,407,1183,1185,1203,1218,1188,2063,1179,1190,1196,1200,1193,1195,1197,1202,1199,1198,1201,1784,1783,2060,1782,1692,1378,88,2091,578,1803,840,737,910,948,996,2083,1995,2045,1733,1745,1743,1744,1750,1747,1773,1416,1433,404,1759,1765,1760,1756,628,1453,1458,2082,1770,1766,1762,1775,1776,690,1491,1500,897,1552,1564,2105,2095,2102,1570,2118,1652,1365,2111,2109,1408,554,2117,1611,1373,1372,1366,2014,2018,2024,2025,1370,1369,1625,1445,1375,1379,2072,796,1380,2042,2044,2046,2054,2050,1628,2038,1653,1688,1516,485,2053,2047,2043,1387,1389,1790,982,1663,1393,1502,1388,1390,1395,1394,1399,80,1401,1400,1403,1415,527,523,1523,1414,1413,1419,1412,1417,1421,1418,1426,1424,1425,1427,1432,2066,2061,2065,1630,2064,2071,2070,2069,2068,2067,2079,2077,1438,1443,1436,1437,1440,1447,1728,1449,1557,1562,1563,1450,1446,1451,1464,1459,1454,1467,1455,1456,1457,645,1751,749,1465,1470,1468,1466,1471,1469,159,754,1757,1758,1481,1478,1631,1482,1477,1476,1487,1488,1486,1490,1493,1489,1494,1492,1781,778,809,216,209,1497,1498,1508,1509,2106,1513,1503,1504,1515,1512,1507,1505,241,238,240,1519,1799,1517,2085,1540,1527,439,1849,1528,1524,1537,2096,1536,1807,1815,1813,802,805,1816,1533,1539,268,2092,1636,1548,1547,1549,793,817,1556,1555,1551,1560,1880,324,1573,1565,1571,1566,1578,1567,1617,1896,1572,1568,1581,1576,1577,1582,941,1902,1580,1586,1587,2110,2107,1664,2115,2114,2116,2113,2112,366,1590,1591,1045,1593,1602,1600,1598,1601,1609,1657,1610,394,1897,1941,1656,1624,1614,1622,1623,1620,1621,1627,1629,1074,1075,1626,1640,1638,1642,1639,1643,1632,1648,476,468,466,1665,1655,1654,1658,514,1667,1969,1675,1674,1673,1672,1679,1676,1726,1194,1680,1684,1682,1683,1355,1687,1693,1899,1900,1719,2005,1698,1695,1691,1700,1696,1701,1703,1705,1893,641,660,2006,2020,721,596,1706,1713,1715,1720,1716,1717,1827,1360,18,1901,259,300,355,421,710,734,795,799,803,864,1111,1143,1173,1219,1285,1723,1721,1722,1725,624,1727,640,1737,1732,1731,1817,1824,1792,1354,1786,1794,1793,755,1801,1802,1806,1808,1810,1812,1811,1805,1809,1822,1821,1826,1823,1828,1825,1833,1831,1830,1859,1835,1837,1844,2039,1854,1839,1843,1841,1842,1850,1851,1852,1857,1858,880,752,1872,282,1865,1861,1868,1867,1862,2036,1866,1864,1876,1875,1874,1877,1878,1882,1883,1887,1888,1895,1904,1905,1903,1906,1908,1914,1909,1913,1912,1915,1919,1920,1921,1011,1930,1932,1931,1936,1940,1055,1945,1947,1946,1948,39,1944,1949,9,1977,1955,1992,1966,1963,1962,1964,1967,1968,1970,1163,1155,1161,97,903,1217,1988,1990,250,1986,1999,1994,27,2000,1993,1997,715,2003,2004,1270,2019,2012,142,138,17,23,15,16,14,12,1346,2033,2037,2040,247,13,8,20,22,26,25,28,81,76,34,30,33,31,43,32,40,41,35,45,44,36,77,131,620,79,49,46,65,48,428,68,47,78,75,62,202,83,153,50,61,58,141,53,52,99,67,66,70,82,86,84,85,137,148,129,106,151,201,193,204,87,89,96,90,95,100,94,93,104,98,103,116,122,118,121,123,124,127,130,140,132,133,135,134,146,144,936,147,150,152,154,199,156,158,217,169,161,160,163,162,168,196,192,211,570,317,207,212,208,214,218,210,215,790,220,221,251,748,223,225,224,232,226,229,228,231,249,501,230,280,233,234,337,602,235,236,1059,237,246,245,244,254,308,253,260,252,261,256,258,257,263,338,361,503,496,909,264,586,273,270,266,271,276,275,274,277,278,279,500,283,340,287,291,285,294,311,286,289,288,335,290,295,296,344,297,303,304,312,301,299,307,313,305,309,310,314,336,341,403,315,319,321,318,320,325,322,326,328,323,327,329,331,333,339,686,346,348,347,349,358,400,353,354,359,352,357,360,363,427,441,502,368,370,365,377,371,372,375,376,379,380,445,707,383,397,384,398,395,390,387,391,389,396,388,399,402,409,459,405,408,406,411,410,412,413,415,420,424,416,422,423,425,436,469,564,429,437,433,430,431,440,432,443,438,442,558,446,447,448,618,518,492,470,449,450,456,452,454,458,463,577,464,560,553,487,465,473,477,471,483,478,479,475,481,480,482,484,489,491,488,714,490,536,505,517,506,556,549,508,510,512,509,513,520,515,519,535,569,592,525,521,524,522,526,545,532,531,530,529,528,534,557,559,537,595,566,674,551,550,538,544,542,555,552,563,575,571,576,579,584,581,574,573,597,610,605,599,472,613,590,611,588,616,615,622,722,798,630,593,609,600,604,601,598,607,603,608,612,614,619,623,626,625,668,673,635,633,629,631,638,636,723,750,672,639,684,642,651,658,650,643,646,644,652,648,716,654,655,649,656,657,794,664,1290,666,662,665,669,667,663,677,678,682,680,679,687,683,695,694,691,693,719,696,697,700,699,701,1300,739,735,709,713,711,720,724,730,725,726,727,733,732,731,736,741,738,743,744,745,777,811,768,826,756,766,759,767,765,770,771,772,773,812,774,775,783,822,819,776,779,789,782,785,1046,786,787,791,792,801,810,804,807,806,815,1154,816,820,828,823,821,824,825,1294,832,829,831,833,990,846,841,882,835,843,842,849,836,847,844,850,851,853,863,870,869,860,867,861,868,872,873,875,889,902,1232,967,885,886,879,884,881,890,887,883,892,891,888,898,894,893,895,900,905,915,904,914,929,908,918,911,916,912,913,997,921,928,926,1116,927,930,934,923,959,932,925,984,998,1002,942,937,951,938,939,954,946,947,956,950,949,952,957,953,955,980,979,1062,958,981,989,993,986,988,1016,985,970,994,991,995,1000,1009,1026,960,1153,1031,962,968,963,964,961,965,1012,966,1021,975,973,974,976,977,978,1023,1005,1006,1018,1008,1013,1017,1014,1022,1019,1044,1049,1122,1024,1034,1134,1054,1035,1236,1030,1032,1033,1039,1066,1038,1037,1040,1041,1042,1050,1058,1051,1056,1142,1065,1064,1070,1302,1071,1089,1072,1073,1077,1086,1084,1083,1080,1091,1079,1085,1088,1082,1087,1092,1095,1094,1099,1096,1097,1106,1103,1105,1102,1100,1104,1101,1112,1115,1114,1147,1149,1150,1151,1152,1177,1187,1166,1157,1213,1156,1159,1169,1160,1165,1167,1168,1170,1171,1206,1211,1209,1212,1210,1215,1214,1221,1222,1220,1226,1224,1228,1230,1234,1231,1279,1233,1247,1242,1239,1237,1249,1240,1246,1243,1244,1253,1251,1252,1250,1257,1261,1259,1357,1275,1281,1274,1278,1283,1284,1291,1299,1301,1308,1310,1311,1356,1325,1321,1319,1331,1332,1333,1335,1344,1338,1337,11,1349,1345,1347,467,1898,474,1927,1374,1439,2103,1869,284,494,1873,281,495,419,1480,292,306,539,540,541,499,507,1907,330,434,546,548,332,364,444,1541,1545,342,343,345,350,351,1933,547,369,373,378,455,19,374,24,37,38,42,51,56,63,69,392,516,91,92,110,112,114,1950,119,126,136,155,157,1634,167,567,1954,1953,1635,179,180,182,190,191,195,197,198,1957,213,222,227,239,242,243,248,262,265,267,269,272,1645,591,594,1644,606,617,621,1660,1661,1662,1686,661,681,1707,1714,698,702,717,1735,1736,1754,728,747,753,1764,757,1972,1788,780,781,788,1797,1791,834,837,838,852,859,865,871,874,899,2009,2016,906,907,920,1004,1015,1036,1090,1117,1121,1139,1162,1204,1205,1216,561,1229,1289,1293,1297,1298,1336,1368,1404,1423,1420,1434,1435,2029,2052,2073,2075,2076,2104,1452,1925,634,1846,1381,1396,128,186,1397,1402,675,1496,1506,800,1885,1832,1910,1980,1989,2030,21,59,751,145,298,334,589,385,414,582,585,587,670,632,676,689,706,705,740,848,845,992,857,877,1248,1886,1926,1856,386,164,165,583,1800,1845}'::integer[]))
-> Hash (cost=7.41..7.41 rows=141 width=44)
-> Seq Scan on tbl_users u (cost=0.00..7.41 rows=141 width=44)