{"id":12170,"date":"2023-03-15T09:45:56","date_gmt":"2023-03-15T06:15:56","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/efficiently-deleting-data-3el3\/"},"modified":"2023-03-15T09:45:56","modified_gmt":"2023-03-15T06:15:56","slug":"efficiently-deleting-data-3el3","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/efficiently-deleting-data-3el3\/","title":{"rendered":"\u062d\u0630\u0641 \u06a9\u0627\u0631\u0622\u0645\u062f \u062f\u0627\u062f\u0647 \u0647\u0627 &#8211; \u0627\u0646\u062c\u0645\u0646 DEV"},"content":{"rendered":"<div data-article-id=\"1399230\" id=\"article-body\">\n<p>\u0648\u0642\u062a\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062f\u0631 CockroachDB (CRDB) \u062d\u0630\u0641 \u0645\u06cc \u06a9\u0646\u0645\u060c \u062d\u0630\u0641 \u06a9\u0646\u062f \u0627\u0633\u062a\u060c \u0648 \u0686\u06af\u0648\u0646\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u0645 \u0633\u0631\u0639\u062a \u0622\u0646 \u0631\u0627 \u0627\u0641\u0632\u0627\u06cc\u0634 \u062f\u0647\u0645\u061f<\/p>\n<p>\u0627\u06cc\u0646 \u0645\u0648\u0636\u0648\u0639\u06cc \u0627\u0633\u062a \u06a9\u0647 \u06af\u0647\u06af\u0627\u0647 \u0645\u0637\u0631\u062d \u0645\u06cc \u0634\u0648\u062f\u060c \u0648 \u0641\u0648\u0642 \u0627\u0644\u0639\u0627\u062f\u0647 \u0634\u0647\u0648\u062f\u06cc \u0646\u06cc\u0633\u062a\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0641\u06a9\u0631 \u0645\u06cc \u06a9\u0646\u0645 \u0627\u0631\u0632\u0634 \u062a\u0648\u0636\u06cc\u062d \u0628\u06cc\u0634\u062a\u0631 \u0631\u0627 \u062f\u0627\u0631\u062f.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter-rtl ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\u062a\u063a\u06cc\u06cc\u0631 \u0648\u0636\u0639\u06cc\u062a \u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nabfollower.com\/blog\/efficiently-deleting-data-3el3\/#%D8%A8%D8%B1%D9%BE%D8%A7%DB%8C%DB%8C\" >\u0628\u0631\u067e\u0627\u06cc\u06cc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nabfollower.com\/blog\/efficiently-deleting-data-3el3\/#%D9%86%DA%AF%D8%A7%D9%87%DB%8C_%D8%A8%D9%87_%D8%AA%D9%88%D8%B6%DB%8C%D8%AD_%D8%B7%D8%B1%D8%AD_%D9%87%D8%A7\" >\u0646\u06af\u0627\u0647\u06cc \u0628\u0647 \u062a\u0648\u0636\u06cc\u062d \u0637\u0631\u062d \u0647\u0627<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nabfollower.com\/blog\/efficiently-deleting-data-3el3\/#%D8%AD%D8%B1%DA%A9%D8%AA_%D8%A8%D9%87_%D8%B3%D9%85%D8%AA_%D8%AD%D8%B0%D9%81_%D9%87%D8%A7\" >\u062d\u0631\u06a9\u062a \u0628\u0647 \u0633\u0645\u062a \u062d\u0630\u0641 \u0647\u0627<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nabfollower.com\/blog\/efficiently-deleting-data-3el3\/#%D8%AE%D9%84%D8%A7%D8%B5%D9%87\" >\u062e\u0644\u0627\u0635\u0647<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D8%A8%D8%B1%D9%BE%D8%A7%DB%8C%DB%8C\"><\/span>\n<p>  \u0628\u0631\u067e\u0627\u06cc\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0628\u0631\u0627\u06cc \u0628\u0631\u0631\u0633\u06cc \u0627\u06cc\u0646 \u0645\u0648\u0636\u0648\u0639\u060c \u0628\u06cc\u0627\u06cc\u06cc\u062f \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0628\u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u0627 \u0622\u0646\u0647\u0627 \u0628\u0627\u0632\u06cc \u06a9\u0646\u06cc\u0645.<\/p>\n<p>\u0627\u0628\u062a\u062f\u0627 \u0628\u06cc\u0627\u06cc\u06cc\u062f \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645 \u0648 \u0633\u067e\u0633 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0637\u0648\u0631\u06cc \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u067e\u0633 \u0627\u0632 \u062d\u0630\u0641 \u0627\u0645\u0631\u0648\u0632 \u0641\u0642\u0637 60 \u062b\u0627\u0646\u06cc\u0647 \u0635\u0628\u0631 \u06a9\u0646\u06cc\u0645 \u062a\u0627 \u062f\u0631 \u0648\u0627\u0642\u0639 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0627\u0632 \u0644\u0627\u06cc\u0647 \u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc \u062f\u0631 CRDB \u062d\u0630\u0641 \u06a9\u0646\u06cc\u0645 (\u0627\u06af\u0631 \u0644\u0627\u0632\u0645 \u0628\u0627\u0634\u062f \u0686\u0646\u062f\u06cc\u0646 \u0628\u0627\u0631 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u0645 \u0648 \u0647\u0645\u0647 \u0686\u06cc\u0632 \u0631\u0627 \u062f\u0648\u0628\u0627\u0631\u0647 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u0645 \u0645\u0641\u06cc\u062f \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f)<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">CREATE<\/span> <span class=\"k\">DATABASE<\/span> <span class=\"n\">deletes<\/span><span class=\"p\">;<\/span>\n<span class=\"k\">ALTER<\/span> <span class=\"k\">DATABASE<\/span> <span class=\"n\">deletes<\/span> <span class=\"n\">CONFIGURE<\/span> <span class=\"k\">ZONE<\/span> <span class=\"k\">USING<\/span> <span class=\"n\">gc<\/span><span class=\"p\">.<\/span><span class=\"n\">ttlseconds<\/span><span class=\"o\">=<\/span> <span class=\"mi\">60<\/span><span class=\"p\">;<\/span>\n<span class=\"n\">USE<\/span> <span class=\"n\">deletes<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0633\u067e\u0633\u060c \u0628\u06cc\u0627\u06cc\u06cc\u062f \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645.  \u0645\u0646 \u0645\u06cc \u062e\u0648\u0627\u0647\u0645 \u062c\u062f\u0648\u0644\u06cc \u0628\u0627 \u0686\u0646\u062f \u0633\u062a\u0648\u0646 \u0627\u0632 \u06a9\u0627\u0631\u062f\u06cc\u0646\u0627\u0644\u06cc\u062a\u0647 \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0648 100 \u0645\u06cc\u0644\u06cc\u0648\u0646 \u0631\u062f\u06cc\u0641 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u0645.  \u06cc\u06a9 \u062a\u0627\u0628\u0639 \u0645\u0641\u06cc\u062f \u062f\u0631 CRDB \u0628\u0647 \u0646\u0627\u0645 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f <code>generate_series<\/code> \u06a9\u0647 \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u0646\u0648\u0639 \u0627\u06cc\u062c\u0627\u062f \u062f\u0627\u062f\u0647 \u0639\u0627\u0644\u06cc \u0627\u0633\u062a:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">deletes<\/span><span class=\"p\">.<\/span><span class=\"n\">order_items<\/span> <span class=\"p\">(<\/span> <span class=\"n\">id<\/span> <span class=\"k\">PRIMARY<\/span> <span class=\"k\">KEY<\/span><span class=\"p\">,<\/span> <span class=\"n\">customer_id<\/span><span class=\"p\">,<\/span> <span class=\"n\">order_id<\/span><span class=\"p\">,<\/span> <span class=\"n\">product_id<\/span><span class=\"p\">,<\/span> <span class=\"n\">order_date<\/span> <span class=\"p\">)<\/span>\n<span class=\"k\">AS<\/span>\n<span class=\"k\">SELECT<\/span>\n  <span class=\"k\">g<\/span><span class=\"p\">.<\/span><span class=\"n\">i<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">id<\/span><span class=\"p\">,<\/span>\n  <span class=\"k\">g<\/span><span class=\"p\">.<\/span><span class=\"n\">i<\/span> <span class=\"o\">%<\/span> <span class=\"mi\">77777<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">customer_id<\/span><span class=\"p\">,<\/span>\n  <span class=\"k\">g<\/span><span class=\"p\">.<\/span><span class=\"n\">i<\/span> <span class=\"o\">%<\/span> <span class=\"mi\">1000000<\/span> <span class=\"k\">as<\/span> <span class=\"n\">order_id<\/span><span class=\"p\">,<\/span>\n  <span class=\"k\">g<\/span><span class=\"p\">.<\/span><span class=\"n\">i<\/span> <span class=\"o\">%<\/span> <span class=\"mi\">11111<\/span> <span class=\"k\">as<\/span> <span class=\"n\">product_id<\/span><span class=\"p\">,<\/span>\n  <span class=\"k\">g<\/span><span class=\"p\">.<\/span><span class=\"n\">i<\/span><span class=\"p\">::<\/span><span class=\"nb\">TIMESTAMP<\/span> <span class=\"k\">as<\/span> <span class=\"n\">order_date<\/span>\n<span class=\"k\">FROM<\/span> <span class=\"n\">generate_series<\/span><span class=\"p\">(<\/span><span class=\"mi\">1578003200<\/span><span class=\"p\">,<\/span> <span class=\"mi\">1678003200<\/span><span class=\"p\">,<\/span> <span class=\"mi\">1<\/span><span class=\"p\">)<\/span> <span class=\"k\">g<\/span><span class=\"p\">(<\/span><span class=\"n\">i<\/span><span class=\"p\">);<\/span>\n<span class=\"c1\">-- 100,000,000 records<\/span>\n<span class=\"c1\">--  between 2020-01-02 22:13:20 (i.e., 1578003200)<\/span>\n<span class=\"c1\">--  and 2023-03-05 08:00:00 (i.e., 1678003200)<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0645\u0646 \u0627\u0632 \u0686\u0646\u062f \u062a\u06a9\u0646\u06cc\u06a9 \u0645\u0641\u06cc\u062f \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u0645:<\/p>\n<ul>\n<li>\u0645\u0646 \u0627\u0632 <code>CREATE TABLE AS<\/code> (\u06cc\u0627 \u0628\u0647 \u0642\u0648\u0644 \u0645\u0627 CTAS) \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0648\u0644 \u062c\u062f\u06cc\u062f.  \u0627\u06cc\u0646 \u062f\u0631 CRDB \u0628\u0633\u06cc\u0627\u0631 \u0633\u0631\u06cc\u0639\u062a\u0631 \u0627\u0632 \u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0648\u0644 \u0648 \u0633\u067e\u0633 \u0627\u0646\u062c\u0627\u0645 \u0622\u0646 \u0627\u0633\u062a <code>INSERT INTO ... SELECT<\/code> \u0632\u06cc\u0631\u0627 \u062a\u0645\u0627\u0645 \u0627\u0644\u06af\u0648\u0631\u06cc\u062a\u0645 \u0647\u0627\u06cc \u0628\u0631\u0631\u0633\u06cc \u0633\u0627\u0632\u06af\u0627\u0631\u06cc \u0631\u0627 \u062f\u0648\u0631 \u0645\u06cc \u0632\u0646\u062f.<\/li>\n<li>\u0645\u0646 \u0627\u0632 <code>g.i<\/code> \u0645\u0642\u062f\u0627\u0631 \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 &#8220;\u0645\u0642\u062f\u0627\u0631 \u0627\u0648\u0644\u06cc\u0647&#8221; \u0645\u0646 \u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0622\u0646 \u0645\u0633\u062a\u0642\u06cc\u0645\u0627\u064b \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0641\u06cc\u0644\u062f \u0634\u0646\u0627\u0633\u0647 \u0645\u0646<\/li>\n<li>\u0628\u0631\u0627\u06cc \u0628\u0631\u062e\u06cc \u0627\u0632 \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u062f\u06cc\u06af\u0631\u060c \u0645\u0646 \u0627\u0632 \u0639\u0645\u0644\u06af\u0631 \u0645\u062f\u0648\u0644 (\u06cc\u0639\u0646\u06cc \u066a) \u062f\u0631 \u0628\u0631\u0627\u0628\u0631 gi feild \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u0645\u0642\u0627\u062f\u06cc\u0631 \u06a9\u0645 \u06a9\u0627\u0631\u062f\u06cc\u0646\u0627\u0644\u06cc\u062a\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u0645.<\/li>\n<li>\u0645\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631\u06cc \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 \u0628\u06cc\u0646 1578003200 \u0648 1678003200 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u0645 \u062a\u0627 \u0628\u062a\u0648\u0627\u0646\u0645 \u0628\u0647 \u0631\u0627\u062d\u062a\u06cc \u0627\u06cc\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0631\u0627 \u0628\u0647 \u0645\u0647\u0631 \u0632\u0645\u0627\u0646\u06cc \u062a\u0628\u062f\u06cc\u0644 \u06a9\u0646\u0645.<\/li>\n<li>\u0646\u06a9\u062a\u0647: \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646\u06a9\u0647 \u0628\u0641\u0647\u0645\u06cc\u062f \u0627\u0632 \u0686\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631\u06cc \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0634\u0631\u0648\u0639 \u0648 \u067e\u0627\u06cc\u0627\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f\u060c \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f <code>SELECT '2023-01-15 2:00 PM'::TIMESTAMP::INT;<\/code> \u0628\u0627 \u0645\u0642\u0627\u062f\u06cc\u0631 \u062a\u0627\u0631\u06cc\u062e \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u062e\u0648\u062f\u060c \u0645\u0642\u0627\u062f\u06cc\u0631 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0631\u0627 \u0645\u0634\u062e\u0635 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n<p>\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u062c\u062f\u0648\u0644 \u062e\u0648\u062f \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u06cc\u0645\u060c \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0646\u0645\u0627\u06cc\u0647 \u0647\u0627\u06cc\u06cc \u0631\u0627 \u062f\u0631 \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u062f\u06cc\u06af\u0631 \u062e\u0648\u062f \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645 \u062a\u0627 \u0622\u0646\u0686\u0647 \u0631\u0627 \u06a9\u0647 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0648\u0627\u0642\u0639\u06cc \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u062f \u062a\u0642\u0644\u06cc\u062f \u06a9\u0646\u06cc\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">CREATE<\/span> <span class=\"k\">INDEX<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">order_items<\/span> <span class=\"p\">(<\/span> <span class=\"n\">customer_id<\/span> <span class=\"p\">);<\/span>\n<span class=\"k\">CREATE<\/span> <span class=\"k\">INDEX<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">order_items<\/span> <span class=\"p\">(<\/span> <span class=\"n\">order_id<\/span> <span class=\"p\">);<\/span>\n<span class=\"k\">CREATE<\/span> <span class=\"k\">INDEX<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">order_items<\/span> <span class=\"p\">(<\/span> <span class=\"n\">product_id<\/span> <span class=\"p\">);<\/span>\n<span class=\"k\">CREATE<\/span> <span class=\"k\">INDEX<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">order_items<\/span> <span class=\"p\">(<\/span> <span class=\"n\">order_date<\/span> <span class=\"p\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u062f\u0631\u06a9 \u062f\u0631\u0633\u062a\u06cc \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u062e\u0648\u062f\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span>\n  <span class=\"k\">COUNT<\/span><span class=\"p\">(<\/span><span class=\"o\">*<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">rec_count<\/span><span class=\"p\">,<\/span>\n  <span class=\"k\">COUNT<\/span><span class=\"p\">(<\/span><span class=\"k\">DISTINCT<\/span> <span class=\"n\">customer_id<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">cust_count<\/span><span class=\"p\">,<\/span>\n  <span class=\"k\">COUNT<\/span><span class=\"p\">(<\/span><span class=\"k\">DISTINCT<\/span> <span class=\"n\">order_id<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">ord_count<\/span><span class=\"p\">,<\/span>\n  <span class=\"k\">COUNT<\/span><span class=\"p\">(<\/span><span class=\"k\">DISTINCT<\/span> <span class=\"n\">product_id<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">prd_count<\/span><span class=\"p\">,<\/span>\n  <span class=\"k\">COUNT<\/span><span class=\"p\">(<\/span><span class=\"k\">DISTINCT<\/span> <span class=\"n\">order_date<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">date_count<\/span>\n<span class=\"k\">FROM<\/span> <span class=\"n\">order_items<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0646\u062a\u0627\u06cc\u062c \u0645\u0627:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>  rec_count | cust_count | ord_count | prd_count | date_count\n------------+------------+-----------+-----------+-------------\n  100000001 |      77777 |   1000000 |     11111 |  100000001\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D9%86%DA%AF%D8%A7%D9%87%DB%8C_%D8%A8%D9%87_%D8%AA%D9%88%D8%B6%DB%8C%D8%AD_%D8%B7%D8%B1%D8%AD_%D9%87%D8%A7\"><\/span>\n<p>  \u0646\u06af\u0627\u0647\u06cc \u0628\u0647 \u062a\u0648\u0636\u06cc\u062d \u0637\u0631\u062d \u0647\u0627<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0627\u06a9\u0646\u0648\u0646 \u06a9\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc\u06cc \u0628\u0631\u0627\u06cc \u0628\u0627\u0632\u06cc \u06a9\u0631\u062f\u0646 \u062f\u0627\u0631\u06cc\u0645\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u0641\u0647\u0645\u06cc\u0645 \u0648\u0642\u062a\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0627\u06cc\u0646 \u062c\u062f\u0648\u0644 \u0631\u0627 \u062d\u0630\u0641 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645 \u0686\u0647 \u0627\u062a\u0641\u0627\u0642\u06cc \u0645\u06cc\u200c\u0627\u0641\u062a\u062f.<\/p>\n<p>\u0628\u06cc\u0627\u06cc\u06cc\u062f \u0628\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06cc\u06a9 \u0631\u06a9\u0648\u0631\u062f \u0648\u0627\u062d\u062f \u0628\u0627 \u0645\u0642\u062f\u0627\u0631 PK \u0634\u0631\u0648\u0639 \u06a9\u0646\u06cc\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span>\n<span class=\"k\">FROM<\/span> <span class=\"n\">order_items<\/span>\n<span class=\"k\">WHERE<\/span> <span class=\"n\">id<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1600000000<\/span><span class=\"p\">;<\/span>\n\n      <span class=\"n\">id<\/span>     <span class=\"o\">|<\/span> <span class=\"n\">customer_id<\/span> <span class=\"o\">|<\/span> <span class=\"n\">order_id<\/span> <span class=\"o\">|<\/span> <span class=\"n\">product_id<\/span> <span class=\"o\">|<\/span>     <span class=\"n\">order_date<\/span>\n<span class=\"c1\">-------------+-------------+----------+------------+----------------------<\/span>\n  <span class=\"mi\">1600000000<\/span> <span class=\"o\">|<\/span>       <span class=\"mi\">49333<\/span> <span class=\"o\">|<\/span>        <span class=\"mi\">0<\/span> <span class=\"o\">|<\/span>       <span class=\"mi\">4889<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2020<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">13<\/span> <span class=\"mi\">12<\/span><span class=\"p\">:<\/span><span class=\"mi\">26<\/span><span class=\"p\">:<\/span><span class=\"mi\">40<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06a9\u0646\u0648\u0646\u060c \u0628\u06cc\u0627\u06cc\u06cc\u062f &#8220;EXPLAIN&#8221; \u0631\u0627 \u0628\u0647 \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u062e\u0648\u062f \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u0645 \u062a\u0627 \u0628\u0647 \u0637\u0631\u062d \u0627\u062c\u0631\u0627 \u0646\u06af\u0627\u0647 \u06a9\u0646\u06cc\u0645.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">EXPLAIN<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span>\n<span class=\"k\">FROM<\/span> <span class=\"n\">order_items<\/span>\n<span class=\"k\">WHERE<\/span> <span class=\"n\">id<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1600000000<\/span><span class=\"p\">;<\/span>\n                                                        <span class=\"n\">info<\/span>\n<span class=\"c1\">---------------------------------------------------------------------------------------------------------------------<\/span>\n  <span class=\"n\">distribution<\/span><span class=\"p\">:<\/span> <span class=\"k\">local<\/span>\n  <span class=\"n\">vectorized<\/span><span class=\"p\">:<\/span> <span class=\"k\">true<\/span>\n\n  <span class=\"err\">\u2022<\/span> <span class=\"n\">scan<\/span>\n    <span class=\"n\">estimated<\/span> <span class=\"k\">row<\/span> <span class=\"k\">count<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span> <span class=\"p\">(<\/span><span class=\"o\">&lt;<\/span><span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">01<\/span><span class=\"o\">%<\/span> <span class=\"k\">of<\/span> <span class=\"n\">the<\/span> <span class=\"k\">table<\/span><span class=\"p\">;<\/span> <span class=\"n\">stats<\/span> <span class=\"n\">collected<\/span> <span class=\"mi\">3<\/span> <span class=\"n\">hours<\/span> <span class=\"n\">ago<\/span><span class=\"p\">;<\/span> <span class=\"k\">using<\/span> <span class=\"n\">stats<\/span> <span class=\"n\">forecast<\/span> <span class=\"k\">for<\/span> <span class=\"mi\">3<\/span> <span class=\"n\">hours<\/span> <span class=\"n\">ago<\/span><span class=\"p\">)<\/span>\n    <span class=\"k\">table<\/span><span class=\"p\">:<\/span> <span class=\"n\">order_items<\/span><span class=\"o\">@<\/span><span class=\"n\">order_items_pkey<\/span>\n    <span class=\"n\">spans<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span><span class=\"o\">\/<\/span><span class=\"mi\">1600000000<\/span> <span class=\"o\">-<\/span> <span class=\"o\">\/<\/span><span class=\"mi\">1600000000<\/span><span class=\"p\">]<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0628\u0647 \u0647\u0645\u0627\u0646 \u0633\u0627\u062f\u06af\u06cc \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 \u0627\u062c\u0631\u0627\u06cc\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u062f\u0631\u06cc\u0627\u0641\u062a \u06a9\u0646\u06cc\u062f.  \u0627\u06cc\u0646 \u062f\u0631 \u062d\u0627\u0644 \u0627\u0646\u062c\u0627\u0645 \u0627\u0633\u06a9\u0646 1 \u062f\u0647\u0627\u0646\u0647 \u062f\u0631 \u0634\u0627\u062e\u0635 \u0627\u0648\u0644\u06cc\u0647 (\u06cc\u0639\u0646\u06cc \u062e\u0648\u062f \u062c\u062f\u0648\u0644) \u0627\u0633\u062a.<\/p>\n<p>\u0627\u06a9\u0646\u0648\u0646\u060c \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0628\u0627 \u0641\u06cc\u0644\u062f order_date \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0647\u0645\u0686\u0646\u06cc\u0646 \u06cc\u06a9 \u0645\u0642\u062f\u0627\u0631 \u0628\u0633\u06cc\u0627\u0631 \u0628\u0627\u0644\u0627 \u0628\u0627 \u06cc\u06a9 \u0634\u0627\u062e\u0635 \u0631\u0648\u06cc \u0622\u0646 \u0627\u0633\u062a:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span>\n<span class=\"k\">FROM<\/span> <span class=\"n\">order_items<\/span>\n<span class=\"k\">WHERE<\/span> <span class=\"n\">order_date<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1600000000<\/span><span class=\"p\">::<\/span><span class=\"nb\">timestamp<\/span><span class=\"p\">;<\/span>\n      <span class=\"n\">id<\/span>     <span class=\"o\">|<\/span> <span class=\"n\">customer_id<\/span> <span class=\"o\">|<\/span> <span class=\"n\">order_id<\/span> <span class=\"o\">|<\/span> <span class=\"n\">product_id<\/span> <span class=\"o\">|<\/span>     <span class=\"n\">order_date<\/span>\n<span class=\"c1\">-------------+-------------+----------+------------+----------------------<\/span>\n  <span class=\"mi\">1600000000<\/span> <span class=\"o\">|<\/span>       <span class=\"mi\">49333<\/span> <span class=\"o\">|<\/span>        <span class=\"mi\">0<\/span> <span class=\"o\">|<\/span>       <span class=\"mi\">4889<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2020<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">13<\/span> <span class=\"mi\">12<\/span><span class=\"p\">:<\/span><span class=\"mi\">26<\/span><span class=\"p\">:<\/span><span class=\"mi\">40<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0645\u0627 \u062f\u0642\u06cc\u0642\u0627 \u0647\u0645\u0627\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u067e\u0633 \u0645\u06cc \u06af\u06cc\u0631\u06cc\u0645.  \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0628\u0647 \u062a\u0648\u0636\u06cc\u062d \u0637\u0631\u062d \u0646\u06af\u0627\u0647 \u06a9\u0646\u06cc\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">EXPLAIN<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span>\n<span class=\"k\">FROM<\/span> <span class=\"n\">order_items<\/span>\n<span class=\"k\">WHERE<\/span> <span class=\"n\">order_date<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1600000000<\/span><span class=\"p\">::<\/span><span class=\"nb\">timestamp<\/span><span class=\"p\">;<\/span>\n                                                                            <span class=\"n\">info<\/span>\n<span class=\"c1\">-------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>\n  <span class=\"n\">distribution<\/span><span class=\"p\">:<\/span> <span class=\"k\">local<\/span>\n  <span class=\"n\">vectorized<\/span><span class=\"p\">:<\/span> <span class=\"k\">true<\/span>\n\n  <span class=\"err\">\u2022<\/span> <span class=\"k\">index<\/span> <span class=\"k\">join<\/span>\n  <span class=\"err\">\u2502<\/span> <span class=\"n\">estimated<\/span> <span class=\"k\">row<\/span> <span class=\"k\">count<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span>\n  <span class=\"err\">\u2502<\/span> <span class=\"k\">table<\/span><span class=\"p\">:<\/span> <span class=\"n\">order_items<\/span><span class=\"o\">@<\/span><span class=\"n\">order_items_pkey<\/span>\n  <span class=\"err\">\u2502<\/span>\n  <span class=\"err\">\u2514\u2500\u2500<\/span> <span class=\"err\">\u2022<\/span> <span class=\"n\">scan<\/span>\n        <span class=\"n\">estimated<\/span> <span class=\"k\">row<\/span> <span class=\"k\">count<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span> <span class=\"p\">(<\/span><span class=\"o\">&lt;<\/span><span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">01<\/span><span class=\"o\">%<\/span> <span class=\"k\">of<\/span> <span class=\"n\">the<\/span> <span class=\"k\">table<\/span><span class=\"p\">;<\/span> <span class=\"n\">stats<\/span> <span class=\"n\">collected<\/span> <span class=\"mi\">3<\/span> <span class=\"n\">hours<\/span> <span class=\"n\">ago<\/span><span class=\"p\">;<\/span> <span class=\"k\">using<\/span> <span class=\"n\">stats<\/span> <span class=\"n\">forecast<\/span> <span class=\"k\">for<\/span> <span class=\"mi\">3<\/span> <span class=\"n\">hours<\/span> <span class=\"n\">ago<\/span><span class=\"p\">)<\/span>\n        <span class=\"k\">table<\/span><span class=\"p\">:<\/span> <span class=\"n\">order_items<\/span><span class=\"o\">@<\/span><span class=\"n\">order_items_order_date_idx<\/span>\n        <span class=\"n\">spans<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span><span class=\"o\">\/<\/span><span class=\"s1\">'2020-09-13 12:26:40'<\/span> <span class=\"o\">-<\/span> <span class=\"o\">\/<\/span><span class=\"s1\">'2020-09-13 12:26:40'<\/span><span class=\"p\">]<\/span>\n\n  <span class=\"k\">index<\/span> <span class=\"n\">recommendations<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span>\n  <span class=\"mi\">1<\/span><span class=\"p\">.<\/span> <span class=\"k\">type<\/span><span class=\"p\">:<\/span> <span class=\"k\">index<\/span> <span class=\"n\">replacement<\/span>\n     <span class=\"k\">SQL<\/span> <span class=\"n\">commands<\/span><span class=\"p\">:<\/span> <span class=\"k\">CREATE<\/span> <span class=\"k\">INDEX<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">order_items<\/span> <span class=\"p\">(<\/span><span class=\"n\">order_date<\/span><span class=\"p\">)<\/span> <span class=\"n\">STORING<\/span> <span class=\"p\">(<\/span><span class=\"n\">customer_id<\/span><span class=\"p\">,<\/span> <span class=\"n\">order_id<\/span><span class=\"p\">,<\/span> <span class=\"n\">product_id<\/span><span class=\"p\">);<\/span> <span class=\"k\">DROP<\/span> <span class=\"k\">INDEX<\/span> <span class=\"n\">order_items<\/span><span class=\"o\">@<\/span><span class=\"n\">order_items_order_date_idx<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0628\u0647 \u0686\u0646\u062f \u062a\u0641\u0627\u0648\u062a \u062f\u0631 \u0645\u0648\u0631\u062f \u0627\u06cc\u0646 \u0637\u0631\u062d \u062a\u0648\u0636\u06cc\u062d\u06cc \u0628\u0627 \u0637\u0631\u062d \u0628\u0627\u0644\u0627 \u062a\u0648\u062c\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<ol>\n<li>\u0645\u0627 \u06cc\u06a9 \u0627\u0633\u06a9\u0646 \u0627\u0632 \u0622\u0646 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u062f\u0647\u06cc\u0645 <code>order_items_order_date_idx<\/code> \u0627\u06cc\u0646 \u0628\u0627\u0631<\/li>\n<li>\u0633\u067e\u0633 \u06cc\u06a9 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u062f\u0647\u06cc\u0645 <code>index join<\/code> \u0628\u0627\u0632\u06af\u0634\u062a \u0628\u0647 \u0634\u0627\u062e\u0635 \u0627\u0648\u0644\u06cc\u0647 <code>order_items_pkey<\/code>\n<\/li>\n<li>CRDB \u0628\u0647 \u06a9\u0645\u06a9 \u0645\u0627 \u0686\u0646\u062f \u067e\u06cc\u0634\u0646\u0647\u0627\u062f \u062f\u0631 \u0645\u0648\u0631\u062f \u0627\u06cc\u0646\u06a9\u0647 \u0686\u06af\u0648\u0646\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0634\u0627\u062e\u0635 \u062e\u0648\u062f \u0631\u0627 \u0628\u0631\u0627\u06cc \u0639\u0645\u0644\u06a9\u0631\u062f \u0628\u0647\u062a\u0631 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u0645\u060c \u0628\u0647 \u0645\u0627 \u0627\u0631\u0627\u0626\u0647 \u06a9\u0631\u062f\u0647 \u0627\u0633\u062a.<\/li>\n<\/ol>\n<p>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0634\u0627\u062e\u0635 order_date \u0628\u0633\u06cc\u0627\u0631 \u06a9\u0627\u0631\u0622\u0645\u062f \u0627\u0633\u062a \u0632\u06cc\u0631\u0627 \u0645\u062d\u0645\u0648\u0644 \u0645\u0627 \u0631\u0648\u06cc order_date \u0627\u0633\u062a.  \u0627\u0645\u0627 \u0641\u0647\u0631\u0633\u062a order_date \u0641\u0642\u0637 \u0634\u0627\u0645\u0644 \u0641\u06cc\u0644\u062f\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0645\u0627 \u0627\u06cc\u0646\u062f\u06a9\u0633 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645 (order_date) \u0648 \u06cc\u06a9 \u0645\u0631\u062c\u0639 \u0628\u0647 PK (id).  \u0628\u0647 \u0645\u0646\u0638\u0648\u0631 \u0628\u0631\u0622\u0648\u0631\u062f\u0647 \u06a9\u0631\u062f\u0646 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0645\u0627 <code>SELECT *<\/code> \u0628\u0646\u062f\u060c \u0645\u0627 \u0628\u0627\u06cc\u062f \u062f\u0648\u0628\u0627\u0631\u0647 \u0628\u0647 \u0634\u0627\u062e\u0635 \u0627\u0648\u0644\u06cc\u0647 \u0645\u0644\u062d\u0642 \u0634\u0648\u06cc\u0645 \u062a\u0627 \u0628\u0642\u06cc\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0641\u06cc\u0644\u062f \u0631\u0627 \u062f\u0631 \u0627\u06cc\u0646 \u0631\u06a9\u0648\u0631\u062f \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u0645.  \u067e\u06cc\u0634\u0646\u0647\u0627\u062f \u0627\u06cc\u0646\u062f\u06a9\u0633 \u0628\u0647 \u0645\u0627 \u0645\u06cc\u200c\u06af\u0648\u06cc\u062f \u06a9\u0647 \u0627\u06af\u0631 \u0647\u0645\u0647 \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u062f\u06cc\u06af\u0631 \u0631\u0627 \u0627\u0632 \u0631\u06a9\u0648\u0631\u062f \u062f\u0631 \u0641\u0647\u0631\u0633\u062a order_date \u0628\u06af\u0646\u062c\u0627\u0646\u06cc\u0645\/\u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u06cc\u0645\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0639\u0636\u0648\u06cc\u062a \u0627\u06cc\u0646\u062f\u06a9\u0633 \u0631\u0627 \u0631\u062f \u06a9\u0646\u06cc\u0645\u060c \u0632\u06cc\u0631\u0627 \u0627\u0632 \u0642\u0628\u0644 \u062a\u0645\u0627\u0645 \u0646\u0642\u0627\u0637 \u062f\u0627\u062f\u0647\u200c\u0627\u06cc \u0644\u0627\u0632\u0645 \u0628\u0631\u0627\u06cc \u0628\u0631\u0622\u0648\u0631\u062f\u0647 \u06a9\u0631\u062f\u0646 \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u062e\u0648\u062f \u0631\u0627 \u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u0627\u0634\u062a.<\/p>\n<p>\u0634\u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u06cc\u0646 \u0631\u0627 \u0628\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u067e\u0631\u0633 \u0648 \u062c\u0648\u06cc SELECT \u062b\u0627\u0628\u062a \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0641\u0642\u0637 \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc id \u0648 order_date \u0631\u0627 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u06cc\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">EXPLAIN<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"n\">id<\/span><span class=\"p\">,<\/span> <span class=\"n\">order_date<\/span>\n<span class=\"k\">FROM<\/span> <span class=\"n\">order_items<\/span>\n<span class=\"k\">WHERE<\/span> <span class=\"n\">order_date<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1600000000<\/span><span class=\"p\">::<\/span><span class=\"nb\">timestamp<\/span><span class=\"p\">;<\/span>\n                                                        <span class=\"n\">info<\/span>\n<span class=\"c1\">---------------------------------------------------------------------------------------------------------------------<\/span>\n  <span class=\"n\">distribution<\/span><span class=\"p\">:<\/span> <span class=\"k\">local<\/span>\n  <span class=\"n\">vectorized<\/span><span class=\"p\">:<\/span> <span class=\"k\">true<\/span>\n\n  <span class=\"err\">\u2022<\/span> <span class=\"n\">scan<\/span>\n    <span class=\"n\">estimated<\/span> <span class=\"k\">row<\/span> <span class=\"k\">count<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span> <span class=\"p\">(<\/span><span class=\"o\">&lt;<\/span><span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">01<\/span><span class=\"o\">%<\/span> <span class=\"k\">of<\/span> <span class=\"n\">the<\/span> <span class=\"k\">table<\/span><span class=\"p\">;<\/span> <span class=\"n\">stats<\/span> <span class=\"n\">collected<\/span> <span class=\"mi\">3<\/span> <span class=\"n\">hours<\/span> <span class=\"n\">ago<\/span><span class=\"p\">;<\/span> <span class=\"k\">using<\/span> <span class=\"n\">stats<\/span> <span class=\"n\">forecast<\/span> <span class=\"k\">for<\/span> <span class=\"mi\">3<\/span> <span class=\"n\">hours<\/span> <span class=\"n\">ago<\/span><span class=\"p\">)<\/span>\n    <span class=\"k\">table<\/span><span class=\"p\">:<\/span> <span class=\"n\">order_items<\/span><span class=\"o\">@<\/span><span class=\"n\">order_items_order_date_idx<\/span>\n    <span class=\"n\">spans<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span><span class=\"o\">\/<\/span><span class=\"s1\">'2020-09-13 12:26:40'<\/span> <span class=\"o\">-<\/span> <span class=\"o\">\/<\/span><span class=\"s1\">'2020-09-13 12:26:40'<\/span><span class=\"p\">]<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D8%AD%D8%B1%DA%A9%D8%AA_%D8%A8%D9%87_%D8%B3%D9%85%D8%AA_%D8%AD%D8%B0%D9%81_%D9%87%D8%A7\"><\/span>\n<p>  \u062d\u0631\u06a9\u062a \u0628\u0647 \u0633\u0645\u062a \u062d\u0630\u0641 \u0647\u0627<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0627\u06a9\u0646\u0648\u0646 \u06a9\u0647 \u062d\u0633 \u062a\u0641\u0633\u06cc\u0631 \u0637\u0631\u062d \u0647\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0631\u0627 \u0631\u0648\u06cc \u0645\u06cc\u0632 \u062e\u0648\u062f \u062f\u0627\u0631\u06cc\u0645\u060c \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0628\u0647 \u0627\u06cc\u0646 \u0641\u06a9\u0631 \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0648\u0642\u062a\u06cc \u06cc\u06a9 \u0631\u06a9\u0648\u0631\u062f \u0631\u0627 \u062f\u0631 CRDB \u062d\u0630\u0641 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u0686\u0647 \u0627\u062a\u0641\u0627\u0642\u06cc \u0645\u06cc \u0627\u0641\u062a\u062f.<\/p>\n<p>\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u06cc\u06a9 \u0631\u06a9\u0648\u0631\u062f \u0631\u0627 \u0628\u0627 \u0645\u0642\u062f\u0627\u0631 PK \u062d\u0630\u0641 \u0645\u06cc \u06a9\u0646\u06cc\u0645\u060c \u0628\u0631\u0646\u0627\u0645\u0647 \u0627\u062c\u0631\u0627\u06cc\u06cc \u0645\u0627 \u0628\u0633\u06cc\u0627\u0631 \u0633\u0627\u062f\u0647 \u0627\u0633\u062a &#8211; \u0631\u06a9\u0648\u0631\u062f \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0647 \u0648 \u0622\u0646 \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">EXPLAIN<\/span>\n<span class=\"k\">DELETE<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">order_items<\/span>\n<span class=\"k\">WHERE<\/span> <span class=\"n\">id<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1600000000<\/span><span class=\"p\">;<\/span>\n                                                          <span class=\"n\">info<\/span>\n<span class=\"c1\">-------------------------------------------------------------------------------------------------------------------------<\/span>\n  <span class=\"n\">distribution<\/span><span class=\"p\">:<\/span> <span class=\"k\">local<\/span>\n  <span class=\"n\">vectorized<\/span><span class=\"p\">:<\/span> <span class=\"k\">true<\/span>\n\n  <span class=\"err\">\u2022<\/span> <span class=\"k\">delete<\/span>\n  <span class=\"err\">\u2502<\/span> <span class=\"k\">from<\/span><span class=\"p\">:<\/span> <span class=\"n\">order_items<\/span>\n  <span class=\"err\">\u2502<\/span> <span class=\"n\">auto<\/span> <span class=\"k\">commit<\/span>\n  <span class=\"err\">\u2502<\/span>\n  <span class=\"err\">\u2514\u2500\u2500<\/span> <span class=\"err\">\u2022<\/span> <span class=\"n\">scan<\/span>\n        <span class=\"n\">estimated<\/span> <span class=\"k\">row<\/span> <span class=\"k\">count<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span> <span class=\"p\">(<\/span><span class=\"o\">&lt;<\/span><span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">01<\/span><span class=\"o\">%<\/span> <span class=\"k\">of<\/span> <span class=\"n\">the<\/span> <span class=\"k\">table<\/span><span class=\"p\">;<\/span> <span class=\"n\">stats<\/span> <span class=\"n\">collected<\/span> <span class=\"mi\">3<\/span> <span class=\"n\">hours<\/span> <span class=\"n\">ago<\/span><span class=\"p\">;<\/span> <span class=\"k\">using<\/span> <span class=\"n\">stats<\/span> <span class=\"n\">forecast<\/span> <span class=\"k\">for<\/span> <span class=\"mi\">3<\/span> <span class=\"n\">hours<\/span> <span class=\"n\">ago<\/span><span class=\"p\">)<\/span>\n        <span class=\"k\">table<\/span><span class=\"p\">:<\/span> <span class=\"n\">order_items<\/span><span class=\"o\">@<\/span><span class=\"n\">order_items_pkey<\/span>\n        <span class=\"n\">spans<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span><span class=\"o\">\/<\/span><span class=\"mi\">1600000000<\/span> <span class=\"o\">-<\/span> <span class=\"o\">\/<\/span><span class=\"mi\">1600000000<\/span><span class=\"p\">]<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06af\u0631 \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648\u06cc \u0645\u0634\u0627\u0628\u0647 DELETE \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0641\u06cc\u0644\u062f order_date \u0628\u0647 \u062c\u0627\u06cc PK \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u0645\u060c \u0645\u06cc \u0628\u06cc\u0646\u06cc\u0645 \u06a9\u0647 \u06cc\u06a9 \u0628\u0627\u0631 \u062f\u06cc\u06af\u0631 \u06cc\u06a9 index join \u062f\u0627\u0631\u06cc\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">EXPLAIN<\/span> <span class=\"k\">DELETE<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">order_items<\/span>\n<span class=\"k\">WHERE<\/span> <span class=\"n\">order_date<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1600000000<\/span><span class=\"p\">::<\/span><span class=\"nb\">timestamp<\/span><span class=\"p\">;<\/span>\n                                                                            <span class=\"n\">info<\/span>\n<span class=\"c1\">-------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>\n  <span class=\"n\">distribution<\/span><span class=\"p\">:<\/span> <span class=\"k\">local<\/span>\n  <span class=\"n\">vectorized<\/span><span class=\"p\">:<\/span> <span class=\"k\">true<\/span>\n\n  <span class=\"err\">\u2022<\/span> <span class=\"k\">delete<\/span>\n  <span class=\"err\">\u2502<\/span> <span class=\"k\">from<\/span><span class=\"p\">:<\/span> <span class=\"n\">order_items<\/span>\n  <span class=\"err\">\u2502<\/span> <span class=\"n\">auto<\/span> <span class=\"k\">commit<\/span>\n  <span class=\"err\">\u2502<\/span>\n  <span class=\"err\">\u2514\u2500\u2500<\/span> <span class=\"err\">\u2022<\/span> <span class=\"k\">index<\/span> <span class=\"k\">join<\/span>\n      <span class=\"err\">\u2502<\/span> <span class=\"n\">estimated<\/span> <span class=\"k\">row<\/span> <span class=\"k\">count<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span>\n      <span class=\"err\">\u2502<\/span> <span class=\"k\">table<\/span><span class=\"p\">:<\/span> <span class=\"n\">order_items<\/span><span class=\"o\">@<\/span><span class=\"n\">order_items_pkey<\/span>\n      <span class=\"err\">\u2502<\/span>\n      <span class=\"err\">\u2514\u2500\u2500<\/span> <span class=\"err\">\u2022<\/span> <span class=\"n\">scan<\/span>\n            <span class=\"n\">estimated<\/span> <span class=\"k\">row<\/span> <span class=\"k\">count<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span> <span class=\"p\">(<\/span><span class=\"o\">&lt;<\/span><span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">01<\/span><span class=\"o\">%<\/span> <span class=\"k\">of<\/span> <span class=\"n\">the<\/span> <span class=\"k\">table<\/span><span class=\"p\">;<\/span> <span class=\"n\">stats<\/span> <span class=\"n\">collected<\/span> <span class=\"mi\">3<\/span> <span class=\"n\">hours<\/span> <span class=\"n\">ago<\/span><span class=\"p\">;<\/span> <span class=\"k\">using<\/span> <span class=\"n\">stats<\/span> <span class=\"n\">forecast<\/span> <span class=\"k\">for<\/span> <span class=\"mi\">3<\/span> <span class=\"n\">hours<\/span> <span class=\"n\">ago<\/span><span class=\"p\">)<\/span>\n            <span class=\"k\">table<\/span><span class=\"p\">:<\/span> <span class=\"n\">order_items<\/span><span class=\"o\">@<\/span><span class=\"n\">order_items_order_date_idx<\/span>\n            <span class=\"n\">spans<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span><span class=\"o\">\/<\/span><span class=\"s1\">'2020-09-13 12:26:40'<\/span> <span class=\"o\">-<\/span> <span class=\"o\">\/<\/span><span class=\"s1\">'2020-09-13 12:26:40'<\/span><span class=\"p\">]<\/span>\n\n  <span class=\"k\">index<\/span> <span class=\"n\">recommendations<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span>\n  <span class=\"mi\">1<\/span><span class=\"p\">.<\/span> <span class=\"k\">type<\/span><span class=\"p\">:<\/span> <span class=\"k\">index<\/span> <span class=\"n\">replacement<\/span>\n     <span class=\"k\">SQL<\/span> <span class=\"n\">commands<\/span><span class=\"p\">:<\/span> <span class=\"k\">CREATE<\/span> <span class=\"k\">INDEX<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">order_items<\/span> <span class=\"p\">(<\/span><span class=\"n\">order_date<\/span><span class=\"p\">)<\/span> <span class=\"n\">STORING<\/span> <span class=\"p\">(<\/span><span class=\"n\">customer_id<\/span><span class=\"p\">,<\/span> <span class=\"n\">order_id<\/span><span class=\"p\">,<\/span> <span class=\"n\">product_id<\/span><span class=\"p\">);<\/span> <span class=\"k\">DROP<\/span> <span class=\"k\">INDEX<\/span> <span class=\"n\">order_items<\/span><span class=\"o\">@<\/span><span class=\"n\">order_items_order_date_idx<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0646\u06cc\u0627\u0632 \u0628\u0647 \u0627\u06cc\u0646 \u067e\u06cc\u0648\u0633\u062a\u0646 \u0634\u0627\u062e\u0635 \u062f\u0631 \u06a9\u0648\u0626\u0631\u06cc SELECT \u06a9\u0627\u0645\u0644\u0627\u064b \u0648\u0627\u0636\u062d \u0627\u0633\u062a\u060c \u0627\u0645\u0627 \u0686\u0631\u0627 \u062f\u0631 \u06a9\u0648\u0626\u0631\u06cc DELETE \u0628\u0647 \u0622\u0646 \u0646\u06cc\u0627\u0632 \u0627\u0633\u062a\u061f  \u067e\u0627\u0633\u062e \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0648\u0642\u062a\u06cc CRDB \u06cc\u06a9 \u0631\u06a9\u0648\u0631\u062f \u0631\u0627 \u062d\u0630\u0641 \u0645\u06cc\u200c\u06a9\u0646\u062f\u060c \u0628\u0627\u06cc\u062f \u0648\u0631\u0648\u062f\u06cc(\u0647\u0627\u06cc) \u0631\u0627 \u0627\u0632 \u0646\u0645\u0627\u06cc\u0647 \u0627\u0635\u0644\u06cc \u062d\u0630\u0641 \u06a9\u0646\u062f\u060c \u0627\u0645\u0627 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0628\u0627\u06cc\u062f \u0648\u0631\u0648\u062f\u06cc(\u0647\u0627\u06cc) \u0631\u0627 \u0627\u0632 \u062a\u0645\u0627\u0645 \u0646\u0645\u0627\u06cc\u0647\u200c\u0647\u0627\u06cc \u0645\u0631\u0628\u0648\u0637\u0647 \u062d\u0630\u0641 \u06a9\u0646\u062f.  \u0648 \u0628\u0631\u0627\u06cc \u062d\u0630\u0641 \u0648\u0631\u0648\u062f\u06cc\u200c\u0647\u0627\u06cc \u0641\u0647\u0631\u0633\u062a\u060c \u0628\u0647 \u06a9\u0644\u06cc\u062f\u0647\u0627\u06cc \u0641\u0647\u0631\u0633\u062a \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u062f.<\/p>\n<p>\u0628\u06cc\u0627\u06cc\u06cc\u062f \u062a\u0648\u0635\u06cc\u0647 \u0647\u0627\u06cc \u0628\u0647\u06cc\u0646\u0647 \u0633\u0627\u0632 \u0631\u0627 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u0645 \u0648 \u0627\u06cc\u0646 \u0634\u0627\u062e\u0635 &#8220;\u067e\u0648\u0634\u0634&#8221; \u062c\u062f\u06cc\u062f \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">CREATE<\/span> <span class=\"k\">INDEX<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">order_items<\/span> <span class=\"p\">(<\/span><span class=\"n\">order_date<\/span><span class=\"p\">)<\/span> <span class=\"n\">STORING<\/span> <span class=\"p\">(<\/span><span class=\"n\">customer_id<\/span><span class=\"p\">,<\/span> <span class=\"n\">order_id<\/span><span class=\"p\">,<\/span> <span class=\"n\">product_id<\/span><span class=\"p\">);<\/span>\n<span class=\"k\">DROP<\/span> <span class=\"k\">INDEX<\/span> <span class=\"n\">order_items<\/span><span class=\"o\">@<\/span><span class=\"n\">order_items_order_date_idx<\/span><span class=\"p\">;<\/span>                                                                                                                         \n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06af\u0631 \u062f\u0633\u062a\u0648\u0631 DELETE \u062e\u0648\u062f \u0631\u0627 \u062f\u0648\u0628\u0627\u0631\u0647 \u0628\u0627 \u0627\u06cc\u0646 \u0634\u0627\u062e\u0635 \u062c\u062f\u06cc\u062f \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u0645\u060c \u0645\u06cc \u0628\u06cc\u0646\u06cc\u0645 \u06a9\u0647 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u067e\u06cc\u0648\u0633\u062a\u0646 \u0628\u0647 \u0641\u0647\u0631\u0633\u062a \u062d\u0630\u0641 \u0634\u062f\u0647 \u0627\u0633\u062a.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">EXPLAIN<\/span> <span class=\"k\">DELETE<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">order_items<\/span>\n<span class=\"k\">WHERE<\/span> <span class=\"n\">order_date<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1600000000<\/span><span class=\"p\">::<\/span><span class=\"nb\">timestamp<\/span><span class=\"p\">;<\/span>                                                                                                  <span class=\"n\">info<\/span>\n<span class=\"c1\">-------------------------------------------------------------------------------------------------------------------------<\/span>\n  <span class=\"n\">distribution<\/span><span class=\"p\">:<\/span> <span class=\"k\">local<\/span>\n  <span class=\"n\">vectorized<\/span><span class=\"p\">:<\/span> <span class=\"k\">true<\/span>\n\n  <span class=\"err\">\u2022<\/span> <span class=\"k\">delete<\/span>\n  <span class=\"err\">\u2502<\/span> <span class=\"k\">from<\/span><span class=\"p\">:<\/span> <span class=\"n\">order_items<\/span>\n  <span class=\"err\">\u2502<\/span> <span class=\"n\">auto<\/span> <span class=\"k\">commit<\/span>\n  <span class=\"err\">\u2502<\/span>\n  <span class=\"err\">\u2514\u2500\u2500<\/span> <span class=\"err\">\u2022<\/span> <span class=\"n\">scan<\/span>\n        <span class=\"n\">estimated<\/span> <span class=\"k\">row<\/span> <span class=\"k\">count<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span> <span class=\"p\">(<\/span><span class=\"o\">&lt;<\/span><span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">01<\/span><span class=\"o\">%<\/span> <span class=\"k\">of<\/span> <span class=\"n\">the<\/span> <span class=\"k\">table<\/span><span class=\"p\">;<\/span> <span class=\"n\">stats<\/span> <span class=\"n\">collected<\/span> <span class=\"mi\">3<\/span> <span class=\"n\">hours<\/span> <span class=\"n\">ago<\/span><span class=\"p\">;<\/span> <span class=\"k\">using<\/span> <span class=\"n\">stats<\/span> <span class=\"n\">forecast<\/span> <span class=\"k\">for<\/span> <span class=\"mi\">3<\/span> <span class=\"n\">hours<\/span> <span class=\"n\">ago<\/span><span class=\"p\">)<\/span>\n        <span class=\"k\">table<\/span><span class=\"p\">:<\/span> <span class=\"n\">order_items<\/span><span class=\"o\">@<\/span><span class=\"n\">order_items_order_date_idx1<\/span>\n        <span class=\"n\">spans<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span><span class=\"o\">\/<\/span><span class=\"s1\">'2020-09-13 12:26:40'<\/span> <span class=\"o\">-<\/span> <span class=\"o\">\/<\/span><span class=\"s1\">'2020-09-13 12:26:40'<\/span><span class=\"p\">]<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0647\u0634\u062f\u0627\u0631: \u0627\u06cc\u0646 \u06cc\u06a9 \u062a\u06a9\u0646\u06cc\u06a9 \u0639\u0627\u0644\u06cc \u0628\u0631\u0627\u06cc \u06a9\u0645\u06a9 \u0628\u0647 \u062d\u0630\u0641 \u06a9\u0627\u0631\u0622\u0645\u062f \u0627\u0633\u062a.  \u0627\u06af\u0631 \u0628\u0647 \u0637\u0648\u0631 \u0645\u0646\u0638\u0645 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0642\u062f\u06cc\u0645\u06cc \u0631\u0627 \u062d\u0630\u0641 \u062f\u0633\u062a\u0647\u200c\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc\u200c\u062f\u0647\u06cc\u062f \u06cc\u0627 \u0633\u0648\u0627\u0628\u0642\u06cc \u0631\u0627 \u067e\u0627\u06a9\u0633\u0627\u0632\u06cc \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f \u06a9\u0647 \u062f\u0627\u0631\u0627\u06cc \u0648\u0636\u0639\u06cc\u062a \u00ab\u062d\u0630\u0641\u200c\u067e\u0630\u06cc\u0631\u00bb \u0647\u0633\u062a\u0646\u062f\u060c \u0627\u06cc\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0633\u06cc\u0627\u0631 \u06a9\u0645\u06a9 \u06a9\u0646\u062f &#8211; \u0628\u0647 \u062e\u0635\u0648\u0635 \u062f\u0631 \u062c\u062f\u0627\u0648\u0644 \u0648\u0627\u0642\u0639\u0627\u064b \u0628\u0632\u0631\u06af.  \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644\u060c \u062a\u0648\u062c\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u06a9\u0647 \u0627\u06af\u0631 \u0628\u0639\u062f\u0627\u064b \u0646\u0645\u0627\u06cc\u0647 \u062f\u06cc\u06af\u0631\u06cc \u0631\u0627 \u062f\u0631 \u062c\u062f\u0648\u0644 order_items \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f\u060c \u0628\u0627\u06cc\u062f \u0628\u0647 \u062e\u0627\u0637\u0631 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u06a9\u0647 \u0641\u06cc\u0644\u062f \u062a\u0627\u0632\u0647 \u0641\u0647\u0631\u0633\u062a\u200c\u0634\u062f\u0647 \u0631\u0627 \u062f\u0631 \u0641\u0647\u0631\u0633\u062a\u06cc \u06a9\u0647 \u0642\u0631\u0627\u0631 \u0627\u0633\u062a \u062f\u0631 \u062d\u0630\u0641\u200c\u0647\u0627\u06cc \u0634\u0645\u0627 \u0628\u0647 \u06a9\u0627\u0631 \u06af\u0631\u0641\u062a\u0647 \u0634\u0648\u062f\u060c \u0628\u06af\u0646\u062c\u0627\u0646\u06cc\u062f &#8211; \u062f\u0631 \u063a\u06cc\u0631 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a\u060c \u0627\u06cc\u0646 \u067e\u06cc\u0648\u0633\u062a\u0646 \u0628\u0647 \u0641\u0647\u0631\u0633\u062a \u062e\u0632\u0634 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0628\u0647 \u0628\u0631\u0646\u0627\u0645\u0647 \u062e\u0648\u062f \u0628\u0631\u06af\u0631\u062f\u06cc\u062f<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D8%AE%D9%84%D8%A7%D8%B5%D9%87\"><\/span>\n<p>  \u062e\u0644\u0627\u0635\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0646\u0645\u0627\u06cc\u0647 \u0647\u0627\u06cc \u067e\u0648\u0634\u0634\u06cc \u0627\u0628\u0632\u0627\u0631\u06cc \u0639\u0627\u0644\u06cc \u062f\u0631 CRDB \u0648 \u0633\u0627\u06cc\u0631 \u0633\u06cc\u0633\u062a\u0645 \u0647\u0627\u06cc DBMS \u0628\u0631\u0627\u06cc \u06a9\u0627\u0631\u0622\u0645\u062f\u062a\u0631 \u06a9\u0631\u062f\u0646 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u062e\u0627\u0635 \u0647\u0633\u062a\u0646\u062f.  \u062a\u0634\u062e\u06cc\u0635 \u0627\u06cc\u0646\u06a9\u0647 \u0686\u0647 \u0632\u0645\u0627\u0646\u06cc \u0628\u0627\u06cc\u062f \u0628\u0631\u0627\u06cc \u06a9\u0645\u06a9 \u0628\u0647 \u067e\u0631\u0633\u200c\u0648\u200c\u062c\u0648\u0647\u0627\u06cc SELECT \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u0646\u062f\u060c \u0646\u0633\u0628\u062a\u0627\u064b \u0622\u0633\u0627\u0646 \u0627\u0633\u062a\u060c \u0627\u0645\u0627 \u062f\u0631\u06a9 \u0627\u06cc\u0646\u06a9\u0647 \u0622\u0646\u0647\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0628\u0647 DELETE\u200c\u0647\u0627 \u0646\u06cc\u0632 \u06a9\u0645\u06a9 \u06a9\u0646\u0646\u062f\u060c \u06a9\u0645\u06cc \u063a\u06cc\u0631 \u0634\u0647\u0648\u062f\u06cc \u0627\u0633\u062a.  \u0627\u0645\u0627 \u0627\u06a9\u0646\u0648\u0646 \u0645\u06cc \u062f\u0627\u0646\u06cc\u062f\u060c \u062d\u0630\u0641 \u0628\u0633\u06cc\u0627\u0631 \u062e\u0648\u0634\u062d\u0627\u0644 \u06a9\u0646\u0646\u062f\u0647 \u0627\u0633\u062a!!<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0648\u0642\u062a\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062f\u0631 CockroachDB (CRDB) \u062d\u0630\u0641 \u0645\u06cc \u06a9\u0646\u0645\u060c \u062d\u0630\u0641 \u06a9\u0646\u062f \u0627\u0633\u062a\u060c \u0648 \u0686\u06af\u0648\u0646\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u0645 \u0633\u0631\u0639\u062a \u0622\u0646 \u0631\u0627 \u0627\u0641\u0632\u0627\u06cc\u0634 \u062f\u0647\u0645\u061f \u0627\u06cc\u0646 \u0645\u0648\u0636\u0648\u0639\u06cc \u0627\u0633\u062a \u06a9\u0647 \u06af\u0647\u06af\u0627\u0647 \u0645\u0637\u0631\u062d \u0645\u06cc \u0634\u0648\u062f\u060c \u0648 \u0641\u0648\u0642 \u0627\u0644\u0639\u0627\u062f\u0647 \u0634\u0647\u0648\u062f\u06cc \u0646\u06cc\u0633\u062a\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0641\u06a9\u0631 \u0645\u06cc \u06a9\u0646\u0645 \u0627\u0631\u0632\u0634 \u062a\u0648\u0636\u06cc\u062d \u0628\u06cc\u0634\u062a\u0631 \u0631\u0627 \u062f\u0627\u0631\u062f. \u0628\u0631\u067e\u0627\u06cc\u06cc \u0628\u0631\u0627\u06cc \u0628\u0631\u0631\u0633\u06cc \u0627\u06cc\u0646 \u0645\u0648\u0636\u0648\u0639\u060c \u0628\u06cc\u0627\u06cc\u06cc\u062f \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645 \u06a9\u0647 &hellip;<\/p>\n","protected":false},"author":2,"featured_media":12171,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-12170","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/12170","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=12170"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/12170\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/12171"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=12170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=12170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=12170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}