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