QUERY PLAN
Group (cost=10742.05..10824.66 rows=2100 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=10742.05..10749.56 rows=3004 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=18.24..10568.53 rows=3004 width=44)
Hash Cond: (rvr.user_id = u.id)
-> Seq Scan on tbl_approve_verify_rels rvr (cost=0.00..10542.17 rows=3004 width=4)
Filter: (approve_id = ANY ('{2527,2526,2521,2522,2525,2523,2524,2121,2534,2531,2532,2530,2126,2123,2535,2533,2536,2134,2133,2541,2540,2545,2543,2479,2539,2529,2528,2537,2538,1178,181,2542,2546,2544,2548,2549,2547,2550,2551,57,1144,2063,2024,2588,2556,2555,2553,2552,2554,2559,2565,2558,2561,2566,2557,2564,969,2560,2568,2562,2563,2567,2569,1625,2574,2584,2573,2571,2579,2577,2576,2583,2575,2581,2570,1424,2572,2578,2582,2580,2585,2586,2587,1752,2597,2590,2594,2591,2592,2600,2598,2589,2593,2596,2595,2602,2483,2601,2603,2599,2604,101,105,2605,2606,2607,1771,1761,2623,1020,2615,2620,2614,2613,2608,1851,2616,2610,2609,1813,1816,2611,2619,2622,2618,2617,2612,2624,2621,2626,1499,2627,708,2653,2630,2629,2632,2628,2625,1648,2631,2633,1886,1898,1926,1927,1521,2654,2657,2661,2676,2635,2642,2636,2639,2640,2637,2641,2638,2647,2648,2643,2644,1713,2646,2645,2649,1789,2656,2651,2668,2658,2665,1808,1857,2652,2659,2663,2664,2662,2667,2655,2669,2666,2670,2671,2660,2684,2681,2683,2672,2678,2677,2675,2674,1994,2673,2679,2686,2680,2685,2682,2689,2687,2688,2690,43,2710,2691,2695,796,2704,2696,2693,2692,2702,2705,2699,2697,2694,2700,2698,2703,2707,2708,2706,2709,2711,2701,2712,141,99,2726,2717,2715,2727,2720,2721,1637,2716,2396,2713,2714,2719,2722,2724,2718,2728,2725,2723,2730,2729,2731,2732,138,2736,2733,2739,2735,2743,2741,2734,2738,2740,2737,493,249,274,570,301,299,328,356,381,390,387,413,435,477,692,515,742,581,604,601,629,646,644,687,701,770,1270,1836,856,833,844,1046,205,170,171,2185,1136,1137,2188,1119,997,1923,1595,1087,1159,1067,1677,1279,1681,2198,1869,284,494,1873,281,495,419,1235,1690,499,1545,1295,69,114,2205,167,222,239,591,1660,907,920,1404,589,705,740,992,165,2217,2216,2214,2221,2232,2238,2239,2251,2258,2257,2255,2252,2256,2223,1704,1856,1374,2103,2269,2267,2285,2292,2287,2286,2301,2309,2311,2322,2313,2331,2338,2337,2350,2346,2364,2358,2363,2370,2372,2378,2377,2375,2386,2394,2388,2409,2410,2430,2435,2450,2458,2469,2481,2490,2487,2491,2122,2050,2508,2520,2511,2513,2509,2139,2138,2125,2128,2512,2516,2141,2135,2120,2127,2140,2124,2129,1019,2131,2130,2132,2137,108,107,109,111,115,685,117,120,149,1260,183,178,172,1218,184,177,185,189,187,188,194,1120,1164,1128,1126,1141,1130,1127,1129,1132,1145,1133,1146,1742,1188,1179,1195,1197,1202,1199,1198,1201,1784,1783,1782,1692,1378,88,2142,1407,2059,808,407,2091,578,1803,840,737,910,948,996,1750,1747,1773,1416,2082,1770,1766,1762,2102,1570,2118,1365,2111,2117,2018,2025,1370,1369,1445,2044,2054,1628,2038,1653,1663,1652,1408,1399,1401,1400,1403,1415,1418,2143,1426,1425,1427,1432,2066,2061,1438,1443,1436,1437,1440,1450,113,1464,1459,1454,1467,1455,1456,1457,645,1755,1452,143,1746,1730,1469,754,1758,1476,1487,1488,1486,1493,1489,1494,2145,2144,1751,2146,1749,102,125,128,2148,2154,2152,2156,2159,2149,2147,2155,2150,1566,2151,2153,2158,2161,2162,2157,2164,2163,1492,1781,778,809,216,209,1497,1498,1512,1507,1505,241,238,240,1519,1799,1517,2085,1540,1578,1044,1537,1496,1474,2165,1536,1815,802,805,1533,1539,1556,1555,1560,1557,324,1573,1571,1567,1885,1785,1617,1896,941,1902,1586,1587,2110,2107,2115,2114,1590,1591,1045,1777,1593,1602,1600,1598,2166,1601,1609,1657,1624,1622,1623,1620,1621,476,468,466,1654,1658,514,1667,1969,1675,1674,1673,2088,1720,2084,255,1672,1679,1676,1726,1693,1900,2005,1698,1695,1691,1700,2160,2167,2168,1696,1701,1715,1823,1716,1719,1717,710,734,795,799,803,864,1111,1143,1173,1219,1285,1723,1721,1722,1725,624,1727,1538,2089,1792,1786,1794,2171,2093,1793,755,1801,1802,1806,2173,2170,2172,1809,1822,1821,1817,1826,1824,1828,1825,1833,1831,1830,1859,1852,1858,880,1866,1864,1832,1876,1875,1877,1878,1882,1883,1904,1903,1906,1908,1049,1914,1909,1913,1912,1915,1949,9,1977,1986,1999,27,14,12,2033,2037,2040,247,13,7,169,8,20,22,26,25,34,30,33,2174,31,32,39,250,40,41,35,161,45,44,36,131,620,49,46,65,48,68,47,78,75,503,496,62,202,79,752,50,61,58,53,52,137,129,106,909,447,151,201,204,428,282,87,89,59,96,90,95,100,94,93,97,104,98,103,116,123,124,127,130,140,132,133,135,134,146,144,142,148,147,156,1122,160,163,162,168,196,192,212,214,218,217,210,215,790,220,221,251,748,321,223,225,224,226,229,228,334,231,230,280,233,234,235,353,237,246,245,2175,254,501,253,261,256,258,257,263,338,361,270,276,275,277,278,279,287,291,285,294,286,289,335,290,295,296,344,354,448,297,1391,304,298,312,307,313,305,308,311,309,310,314,336,341,403,315,318,317,325,322,326,323,327,329,331,333,339,686,346,347,349,358,359,352,357,360,363,427,502,365,371,372,375,376,379,380,445,707,2176,442,612,383,397,384,398,395,391,389,396,388,399,400,402,409,459,558,446,408,406,411,410,415,420,424,416,422,423,425,436,469,564,437,431,440,432,443,438,441,618,518,492,454,458,463,464,560,553,487,465,470,483,478,479,475,614,481,480,482,484,489,491,488,714,517,506,2177,508,510,509,513,519,535,525,521,524,522,526,532,531,530,529,528,2001,534,557,559,551,550,544,545,542,556,549,555,554,552,571,579,584,574,573,577,586,2178,1327,597,610,611,619,1193,588,616,615,622,798,630,582,1778,593,609,599,598,607,603,608,623,626,635,633,631,638,636,723,750,672,639,684,642,651,650,643,647,652,648,654,655,649,656,657,794,664,1290,666,662,677,678,682,680,679,733,2179,683,695,697,700,699,2180,739,735,709,711,724,730,725,726,727,732,731,736,741,738,743,744,745,777,811,759,767,771,772,773,812,774,775,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,990,846,842,836,850,851,903,853,861,868,998,1002,872,873,875,889,902,967,848,845,2183,1860,2184,2182,885,884,881,890,887,883,892,888,898,894,893,895,900,905,915,904,971,908,918,1889,1881,1138,1108,2199,2187,2194,2186,2189,2193,2192,1252,2190,2196,1131,2202,2200,2201,2197,916,913,921,928,926,1116,930,934,923,932,925,936,984,942,937,951,938,939,954,946,956,950,949,952,957,953,980,959,958,981,1022,989,993,986,1025,988,1016,985,991,995,1000,960,1031,962,968,963,964,2203,961,965,1012,975,973,974,976,977,978,979,1009,1026,1023,1005,1006,1008,1013,1017,1014,1024,1034,1134,1035,1030,1032,1033,1038,1037,1040,1041,1042,1050,1058,1051,1056,1062,1250,1054,1059,1064,1070,1071,1089,1072,1073,1077,1086,1084,1083,1080,1091,1079,1085,1088,1082,1092,1153,1099,1254,1096,1097,1106,1103,1105,1102,1100,1104,1101,1112,1115,1114,1177,1187,1166,1157,1213,1156,1169,1160,1257,1165,1167,1168,1170,1171,1206,1207,1210,1214,1221,1220,1224,1226,1227,1228,1230,1234,1231,1239,1249,1240,1246,1243,1244,1253,1251,1261,1248,1971,1259,1357,497,1335,1344,362,1338,1337,11,1480,292,1697,1894,467,306,540,541,507,1907,434,24,546,548,2195,2204,332,444,1541,342,343,345,350,351,1933,547,364,369,373,378,455,19,374,37,38,42,51,56,63,386,472,474,392,516,91,92,110,112,1950,119,126,1689,136,155,157,1634,567,1954,1953,1635,179,180,182,190,191,195,197,198,1957,213,227,1662,242,243,248,262,265,267,269,272,1645,592,594,1644,583,2206,606,617,621,1661,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,865,871,874,899,2009,2016,906,1004,1015,1036,1090,1117,1121,1139,1162,1204,1205,1216,561,1229,1289,1293,1297,1298,1336,1368,2207,1423,1434,1435,2029,2052,186,1397,1402,800,21,751,414,585,587,670,632,676,706,877,164,1800,1845,2209,2212,2211,2213,2208,2210,2220,2225,2218,2215,2219,2231,2224,2222,2228,2230,2227,2245,2229,2240,2242,2237,2234,2226,1485,2235,2241,2247,2236,2243,2244,2246,2249,2248,2250,2254,2259,2260,2253,2261,2263,2262,2265,2280,2272,2324,2278,2271,2270,2268,2266,2277,2275,2274,2276,2264,2282,2279,2281,2283,2284,2273,2302,2290,2291,2297,2294,2296,2342,2288,2307,2300,2289,2303,2295,2298,2305,2306,2304,2299,2308,2312,2315,2314,2310,2319,2317,2323,2320,2318,2316,2321,2325,2326,2329,2330,2233,2328,2332,2341,2335,2334,1420,2343,2339,2347,2340,2348,2336,2345,2344,2333,2353,2354,2359,2361,2352,2355,2351,2349,2356,2362,2366,2357,2360,2365,2369,2367,2371,2368,2373,2381,2380,2376,2429,2374,2379,2385,2384,2293,2383,2382,2387,2390,2392,2399,2391,2393,2389,2395,2400,2398,2403,2397,2402,2401,2406,2404,2405,2407,2408,2413,2425,2424,2419,2411,2418,2414,2417,2416,2412,2415,2422,2423,2421,2427,2420,2428,2426,2436,2431,2433,2442,2434,2432,2441,2438,2439,2445,2443,2437,2440,2444,2448,2446,2447,2449,2482,2452,2456,2451,2457,2453,2461,2454,2460,2455,2463,2459,2464,2467,2462,2466,2465,2468,2471,2477,2470,2486,2488,2484,2474,2473,2476,2472,2480,2475,2485,2489,2499,2501,2494,2497,2495,2496,2493,2492,2506,2498,2502,2504,2500,2507,2503,2505,2515,2517,2518,2514,2510,2519,1855,219,924,580,827,866,2030,1339,1484,1495,1483,1892,1518,1520,504,1853,1522,1525,1529,539,1937,1938,1939,1942,1943,453,1925,1608,1612,1613,1615,1670,1671,1668,1669,1685,1694,659,671,1702,931,1708,1709,1710,1739,1740,1741,1748,761,763,769,1973,1975,1976,1769,1772,1767,1779,1780,1787,854,1991,919,933,859,1804,972,987,1001,1003,1819,1820,1047,1048,1829,1052,1288,1053,1060,1061,1063,1069,1351,1846,1245,1258,1262,1263,1264,1265,1267,1268,1266,1269,1272,1273,1277,1276,1280,1286,1287,1292,1296,1352,1307,1312,1317,1316,1320,1322,1324,1326,1329,1330,1334,1340,1342,1343,1348,1350,1376,1377,1382,1383,1384,1385,1386,1392,1398,1409,1410,1411,983,1381,1396,1444,1448,2028,2031,2032,2034,2027,2026,2041,2048,393,2051,2055,2058,2062,2049,2074,2080,2086,2087,2090,1029,2094,2098,2099,2100,2101,2097,2075,2076,2104,1068,1184,1223,1282,1768,1774,1554,451,1838,1076,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,2083,1995,2045,1733,1745,1743,1744,1433,2060,404,1763,1759,1765,1760,1756,628,1453,1458,1775,690,1491,1500,897,523,1594,1552,1564,2105,2095,2109,1611,2013,1373,1372,1366,2014,1371,1375,1379,2072,1380,2042,2046,1523,1688,1516,485,2053,2047,2043,1387,1389,1790,982,1393,1502,1388,1390,1666,1395,1394,80,1422,527,1428,1414,1413,1419,1412,1417,1421,2065,1630,2064,2071,2070,2069,2068,2067,2079,2077,1718,1447,1728,1449,1446,1451,749,1465,1470,1468,1466,1471,159,1757,675,1479,1481,1478,1631,1482,1477,1490,1514,1508,1509,1513,1503,1504,1515,1506,1565,1827,1527,439,1528,1524,1526,1807,268,2092,1546,1636,1548,1547,1549,793,817,1849,1551,1559,1561,1562,1563,2096,2108,2106,1863,1880,1081,1574,1575,1572,1568,1581,1576,1577,1582,1580,2119,2116,1359,2113,2112,366,1610,394,1606,1897,1941,1924,1614,1627,1629,1074,1075,1626,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,2020,721,596,1706,1360,1353,18,1901,259,300,355,421,1795,640,1737,1732,1731,1354,1810,1812,1811,1805,1835,1837,1844,2039,1854,1839,1843,1841,1842,1850,1872,1865,1861,1868,1867,1862,2036,1874,1887,1890,1888,1895,1997,1911,1905,1910,1919,1920,1921,1011,1930,1932,1931,1936,1940,1055,1945,1947,1946,1948,1951,1944,1955,1992,715,2003,2004,1966,1963,1962,1964,1958,1967,1968,1970,1163,1155,1161,1974,1217,1988,1990,1980,1989,1998,2000,1993,2010,2019,2012,17,1362,23,15,16,1346,28,81,76,77,83,153,67,66,70,82,86,84,473,85,193,122,118,121,150,152,154,199,158,166,145,211,207,208,232,337,602,236,244,471,722,260,252,264,273,266,271,500,283,340,288,303,319,320,590,348,368,370,377,382,385,405,412,429,433,430,449,450,456,452,486,490,536,505,512,520,569,537,543,595,566,674,538,563,575,572,576,605,613,600,625,668,673,658,665,669,667,663,694,691,693,712,719,696,689,713,716,720,768,1461,756,766,765,764,783,819,779,789,841,882,835,843,849,847,863,858,870,869,860,867,857,886,879,901,891,917,914,929,911,912,922,935,927,947,955,970,994,966,1021,1010,1007,1462,1018,1027,1028,1039,1057,1066,1142,1065,1123,1095,1107,1113,1094,1147,1176,1149,1150,1151,1152,1211,1463,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,1439,1349,1345,1347,1870,1460,1871,1472,1473,1475,418,293,1879,426,1884,1510,1511,1891,1530,1531,1532,1916,1917,1918,1535,1542,1543,1544,1922,330,1550,1553,1928,1934,1935,1558,1569,367,457,1579,1583,1584,1588,1589,460,461,1592,1596,1585,1599,462,511,1597,1603,1604,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,1711,1712,688,703,704,718,1724,1734,1738,729,746,1753,758,760,784,797,1798,1978,1979,1981,1985,1984,839,1983,855,1996,862,876,2002,2007,2008,2011,2017,2021,2022,2023,940,943,944,1814,1109,1110,1118,1847,1848,1135,1140,1148,1208,1225,1238,1304,1305,1306,1309,1358,1363,1364,1367,1429,1430,1431,1441,1442,2056,2057,2073,2751,2745,2742,2747,2752,2750,2753,2746,2765,2754,2758,2755,2749,2774,2767,2756,2757,2769,2759,2763,2768,2761,2764,2770,2766,2771,2772,2773}'::integer[]))
-> Hash (cost=16.44..16.44 rows=144 width=44)
-> Seq Scan on tbl_users u (cost=0.00..16.44 rows=144 width=44)