Index unique scan -> Clarification
Hi Experts,
Index unique scan at step 42 estimated cardinality is 1,but the actual rows returned is 127K.
Can index unique scan return 127K rows?
MC4q1Sgbk0n8Al62vfTAit7ncz5dtv0Iqfw1JnqzJO89EQT5sBVYb2rlPX8TkH3dpX8wncsKbH34UtX8q1N+TmE06lUM7gw0XTkyvaKga1IcyN7kR+jq3ZOst2MD2IaeRqa0/N32pCvK/+6jmbsnM/MppUzd88dta6f8nqp+D6IoqtJVN7rn12lTq9f/PSdovwFs+BoPpfl6ocnDpdNyCdGPnLtnp7wfjnAe+++X9+7a36/L2o/69Sv//SmU+2JLe+86fxv5C5zS//zP/5R+pt0gavitWWBq9LSpgQO9Oqa84WaIga/x0JPpvFYLgqGCqOdP78GQuo8yD15q05913z2Zo6dWekE2Tt9Bedn/asn2MsaDekoHMWttr+0wfzdBtZdofOpB0K3R0b5nCsyR0tkT3SiXv2HF/KtTfk7k6Vm9qi8mxoN6qtGjbhvIHmv8Yiuw5g0eAnx92MH2+pbmv7QNuIZuf/sL8OonODYB9c8ft61x+T1h/R48y9ovi/6XPFmqFdesU/+TWm+/AewMNF1PeVbHdWj6PnDDdlNAJV37+3XL7cfmR+SMh4vQfZEtR593NQqF/AVOZRNALQukthJE3c4J2LUl5zP1K4YxWWg978nudtTpRF3LGW7XovBbsyB+aTWeNDIPAyzecDPXSfe4htAbHj8vUVH6Vj8K1NNDXnLKtpemL+65F9jqZqa7bHs1xfkbPegE9ofGH4f1o7HeQ2ZAPPhZVcu/CuXn9AZ67lUN7kS9EVJKymcUyPbkBccFsAO7G+87GjqVar8K8t946MX/FwWy2unBknH++NMald826ndB+7rfs8H/8tJD+Qu/r91+Ktf/9PfaaL8BoJyvL09n7oSAovfLe/e33q+L61fUacHRwSPQr6sXu6d53Wnm7g75C1SxHzgtCqS2EkQdTDdzaqw0mqXn7AvdvjrDpZzVWuu5JW/Iwg9tCr9nCrYvrdFw4/1gTWrOzp6tbtM5UWt0haqSvsaK0reZ92VubV/mU+/aZdsrHb44f6O5DT15nqW3Fh9wGvVojJ3l+lQweO7J/jgyCFJWPsNfLRukLZoTdSVnL3hZPf9X+pElS7tAUa/0lwEg1qD8tlK/C+pXNKR/M3wwekg/6MlQ4f5xdP1vof0GgGLR/IKe2n2GQ7mi98t793fer8vqVzQKLGsqI8+21fxN6K8jf4EqkgHT//7v/87896SW50Q1NHmzJO8rXrgmrpjzRfTr4WCq9dxSYL8wp18roh5uyfkVy+bEGbw6ZxyyXSV9SxVPcVS2vaLBNJ543ZQ3zFjFsGx71cNk5q+hh54Oe2g11H1MzM+5Fep3mZxzsyj/6pefkxm8yll+Vcj3aB6o6qK5fALTkmUGxwdq47YtGYCqlP/Bj1b+l5ajV72OpJ/GGVv3/HHbmpTfM9TvwbMsefryddxQ/u1+qtb/vO+3034DwD5/3JUdmHJWTG9wOfvvl39b6Pa3oze6dpAa0REFSv/O+3VZ/Qrdd3lZvSQVdWJZOcv6CybfEfIXqGcTQE0GUrO0HESNmY/qSnEPmr2V3rqPYjRqS+KFNXbDjTvqDD1p81J7aWXpy5pTL6ls+xGiIdb5gcWy7dckOyCSmGy+LP+uqvwYehot9fVd8jH/S55qzIvlf0QPD59TTd+i3mpHd2QYvMrRZtGuCvkft3W/v0v1HgwZDz15X65+m3SLrXv+uG1Nyu9Z6nc0pN/78rOH8ldWsf6X7eWG2m8A1y90+xp6ppzVgqHk12DzfvnHGZPFboSbpdSIjsXE+DPv1+X1K70WQRZj8ilHtrr0Uj5A/gL17AdOiwKpLQdR44mtN5UxXgQl2XvG/7CrzXOJUps5TFbJoZLxDdfLeUv2P+yMxXAulb7NfKHdVGAgdN34l+ay7fX50aQwuedftr10/2fMXw1e5ZiehonM8cfDxC+Kxfl3TPk5JeNppOVslv+B0FV/6MmsPC9W1B5ps9rkYBqd29E91aLh0NuFbErzX5I82XYv6p03eJbl2bKDvQffqmqfP25bs/J7rvo9eLYk713vy+xFCaoqrf8VNG2/AWAjdPvq2iKAehX23i/v3R94v65Uv+IRLsXTaBiaLOayvOGNTmdwGuRvC0JX/U5HnQ4jnO5BXsA0798bBlFDuf3EghEHE1sPNF1HFW/zmaFnac6Kn61Y/WT/ehS91O6GvOwWPupoqLnW+xNEbxbm2P7108NB9hcGqditv0r6jMkiHoK52/+Lnrblo2x7Yfq2jV/i/JeOVpvzL9teUWn+NpV7fQxNFis5y2Hu8Yvyr2r5KS0fuXbtQ9QBblhcfoyJ3nrB3vw7noab43Zt9bImzs+5/v44mgNonpzD8dWRqXTgsw7jaSQzsPXihirN/3j18F3Pif1FoarkT4Xzx59Uufzm1M/K9btMWfsf93gPgpyh/FXvH5n1v0BL7TeALInn+7gH+7DW/f/WRT20pCBeuGf3R4escyh7v7x31/5+XdZ+VKlfceDcea1wTgNN55YCu3sngT7yF7i0znq9XkvRCojvj6urvUFde/oAAMjC/Qu4XdTfZu49/+79/C+N/C927/lz7+d/aveev/d+/qfWJH///fvX6NinmRMVAAAAAAAAAP4IgqgAANwVX+O9ofD7fwxZBQAAAIC07XB+AAAAAAAAAPiLGM4PAAAAAAAAACdEEBUAAAAAAAAACmyDqP64o74bXjItha49fQAAZOH+Bdwu6m8z955/937+l0b+F7v3/Ln38z+1e8/fez//U7tk/tITFQAAAAAAAAAKNA6ihm4/varvwZK+odx+0XYcby9vN399V6Ekha76+3keuup3+nLDxPbE3340/+D6JvYfbYv3tRWv+lzlOoeu+p2x0p+Mvj/2K6S/7Pw3exwntyeOV3b8kvOv5jCNB7+Y7F2Hw19UNvvYy+vS/AFwqyq1r/64QnuU035UTkNW+xelI+vX3+g7Ubta2H6WtF+Z3z1oIyu0r/knV9r+p4+x/1ngHtx7+b/387+c8vfLexc/D2z/rvHZv6j+7KX/4Fkg+/4ffSzjXu2PE9vvBfkLXErjIKoxWWi9Xsd/c1neMFHBQrn9rmajVbx9JWc5pFtzawxNFlHezy1J1jzK58VExvYzpszle8GN1dI8cf16dvfwQWWz381fvH9j8inHDGS/7F7i/fFQnuloNR20dI5F6S8/f3/c0XDpaLXefM7TsO7DcM75l4vKv91Lf38xSXzbH6vTtdWb77Z/6judvvBbMzlyrECz7/2MKLu+AG5Ra+1rYftRQWb7N9CzJQWz770AbqjvWSBZzxoUfn8jv/1KPluk2vdtG1qhfW3KH6vTeZFGVnv7BG7FvZf/ez//Cyt+v7x3odz+UEtntc2jlaPU88LFFdafKP2ap6/vNj5gTLRIPjes11qvHJky9djN2p2r/tCTNV+rtdfPa0f+AhfV8nD+rh5NafkbV9LwW7PA0tv2pcbQ5M1SYH/wi+4ZjUa9ii/PA01XjkyvalDO0OTTkRnY+oh7jr57kvVWNchYTfX07wldvXumnM9degbTuSx5+jpHAQy/FcUT8u44odx3T6azSt2UjMlEyW+E3zNp9KTJs5URtGiQPwCuWDvta1n7caxBFEVVuulZ6aewzTt0fPte1r425Ws8lObrhSYPJzoEcLXuvfzf+/lfm733y7sX3Wt7D7unAeOhJwU/Wl0wVTtl9SfqBLN798n7YTaxxw9bgfWmw99JQ7kvtrT3LvW3kb/ApbUbRA2/NQtMjZ7iGrj6UbD/me6jTC3FffCMnp7Vq/rybDyopxo9loyJ3izJex9r/GIrsObtN7J10p8Qfs8UqKeH1A0hehDzzhFFNR7Uk+S95/wyvF9fMkU9u3oPRlR3DoIWOjp/AFy5xu1rhfbjWINnWfv3Cv9LnizVimse236Vta+NDTRdT8U7A+7TvZf/ez//K1PpeflvCt1+xlQGA706przhZgi/r/HQk+m8XkmZbbn+bH5Ezni4CN0X2XL02eYolKtH/gKX1koQdTvnZNeWnM/drxiDZ1ny9J6cv+zFPgys4sQGeu5VfXmOgowp3rBwXqLBdC4r8OQFppzXU9y+66R/j/mo9MgEQw+9mvsoOf98cc/ewFY363urn4wg7564N/fzQJLxpJGZFeBukD8Arlqj9rVS+1Eit/077Nngf3npofyF39duP0e1XyXtKwDgpuW+Xy0