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