{"id":75678,"date":"2020-03-27T19:42:27","date_gmt":"2020-03-27T17:42:27","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/o-chem-molchit-explain-i-kak-ego-razgovorit"},"modified":"2020-03-27T19:42:27","modified_gmt":"2020-03-27T17:42:27","slug":"o-chem-molchit-explain-i-kak-ego-razgovorit","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/o-chem-molchit-explain-i-kak-ego-razgovorit","title":{"rendered":"P\u00ebr \u00e7far\u00eb nuk flet EXPLAIN, dhe si ta b\u00ebjm\u00eb at\u00eb t\u00eb flas\u00eb","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Nj\u00eb pyetje klasike me t\u00eb cil\u00ebn zhvilluesi i drejtohet DBA-s\u00eb s\u00eb tij ose pronarit t\u00eb biznesit \u2014 konsulenti p\u00ebr PostgreSQL, pothuajse gjithmon\u00eb ting\u00ebllon e nj\u00ebjt\u00eb: <i>\u00abPse k\u00ebrkesat ekzekutohen kaq ngadal\u00eb n\u00eb baz\u00ebn e t\u00eb dh\u00ebnave?\u00bb<\/i><\/p>\n<p>Nj\u00eb grup tradicional shkaksh faktor\u00ebsh:<\/p>\n<ul>\n<li><b>algoritmi joefikas<\/b><br \/>\nkur vendosni t\u00eb b\u00ebni JOIN disa CTE me disa dhjet\u00ebra mij\u00ebra regjistra<\/li>\n<li><b>statistika joaktuale<\/b><br \/>\nn\u00ebse shp\u00ebrndarja faktike e t\u00eb dh\u00ebnave n\u00eb tabel\u00eb tashm\u00eb \u00ebsht\u00eb ndjesh\u00ebm e ndryshme nga ajo q\u00eb \u00ebsht\u00eb mbledhur m\u00eb par\u00eb nga ANALYZE<\/li>\n<li><b>\"bllokim\" n\u00eb burime<\/b><br \/>\ndhe tashm\u00eb nuk ka mjaft kapacitete kompjuterike CPU, duke e \u00e7uar n\u00eb nj\u00eb rritje t\u00eb vazhdueshme t\u00eb memorie ose disku q\u00eb nuk arrin t\u00eb p\u00ebrmbush\u00eb t\u00eb gjitha \"k\u00ebrkesat\" e DB-s\u00eb<\/li>\n<li><b>e bllokimeve<\/b> nga proceset konkurrente<\/li>\n<\/ul>\n<p>\nDhe n\u00ebse bllokimet merren dhe analizan relativisht me v\u00ebshtir\u00ebsi, p\u00ebr gjith\u00eb t\u00eb tjerat na mjafton <b>plani i k\u00ebrkes\u00ebs<\/b>, i cili mund t\u00eb merret me an\u00eb t\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/postgrespro.ru\/docs\/postgresql\/12\/using-explain\">kryerjes EXPLAIN<\/a><\/noindex> (<i>\u00ebsht\u00eb shum\u00eb m\u00eb mir\u00eb, sigurisht, t\u00eb p\u00ebrdorim menj\u00ebher\u00eb EXPLAIN (ANALYZE, BUFFERS) \u2026<\/i>) ose <noindex><a rel=\"nofollow\" href=\"https:\/\/postgrespro.ru\/docs\/postgresql\/12\/auto-explain\">moduli auto_explain<\/a><\/noindex>.<\/p>\n<p>Por, si\u00e7 thuhet n\u00eb t\u00eb nj\u00ebjt\u00ebn dokumentacion, <\/p>\n<blockquote><p>\u00abT\u00eb kuptosh planin \u00ebsht\u00eb nj\u00eb art, dhe p\u00ebr ta zot\u00ebruar at\u00eb, nevojitet nj\u00eb p\u00ebrvoj\u00eb e caktuar, \u2026\u00bb<\/p><\/blockquote>\n<p> Por mund t\u00eb kalosh pa t\u00eb, n\u00ebse p\u00ebrdor nj\u00eb mjet t\u00eb duhur!<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><br \/>\nSi duket zakonisht plani i k\u00ebrkes\u00ebs? Ashtu si kjo:<\/p>\n<pre><code class=\"plaintext\">Skani i Indeksit duke p\u00ebrdorur pg_class_relname_nsp_index n\u00eb pg_class (koha faktike=0.049..0.050 rreshta=1 cikle=1)\n  Kushti i Indeksit: (relname = $1)\n  Filtri: (oid = $0)\n  Blloqet: goditje t\u00eb ndara=4\n  Plani i fillimit 1 (kthen $0,$1)\n    -&gt;  Kufizimi (koha faktike=0.019..0.020 rreshta=1 cikle=1)\n          Blloqet: goditje t\u00eb ndara=1\n          -&gt;  Skani Sekuencial n\u00eb pg_class pg_class_1 (koha faktike=0.015..0.015 rreshta=1 cikle=1)\n                Filtri: (relkind = 'r'::\"char\")\n                Rreshtat e hequr nga Filtri: 5\n                Blloqet: goditje t\u00eb ndara=1<\/code><\/pre>\n<p>\nose k\u00ebshtu:<\/p>\n<pre><code class=\"plaintext\">\"Shtimi  (kosto=868.60..878.95 rreshta=2 gjer\u00ebsi=233) (koha faktike=0.024..0.144 rreshta=2 cikle=1)\"\n\"  Blloqet: goditje t\u00eb ndara=3\"\n\"  CTE cl\"\n\"    -&gt;  Skani Sekuencial n\u00eb pg_class  (kosto=0.00..868.60 rreshta=9972 gjer\u00ebsi=537) (koha faktike=0.016..0.042 rreshta=101 cikle=1)\"\n\"          Blloqet: goditje t\u00eb ndara=3\"\n\"  -&gt;  Kufizimi  (kosto=0.00..0.10 rreshta=1 gjer\u00ebsi=233) (koha faktike=0.023..0.024 rreshta=1 cikle=1)\"\n\"        Blloqet: goditje t\u00eb ndara=1\"\n\"        -&gt;  Skani CTE n\u00eb cl  (kosto=0.00..997.20 rreshta=9972 gjer\u00ebsi=233) (koha faktike=0.021..0.021 rreshta=1 cikle=1)\"\n\"              Blloqet: goditje t\u00eb ndara=1\"\n\"  -&gt;  Kufizimi  (kosto=10.00..10.10 rreshta=1 gjer\u00ebsi=233) (koha faktike=0.117..0.118 rreshta=1 cikle=1)\"\n\"        Blloqet: goditje t\u00eb ndara=2\"\n\"        -&gt;  Skani CTE n\u00eb cl cl_1  (kosto=0.00..997.20 rreshta=9972 gjer\u00ebsi=233) (koha faktike=0.001..0.104 rreshta=101 cikle=1)\"\n\"              Blloqet: goditje t\u00eb ndara=2\"\n\"Koha e Planifikimit: 0.634 ms\"\n\"Koha e Ekzekutimit: 0.248 ms\"<\/code><\/pre>\n<p>\nPor leximi i planit si tekst \u00abn\u00eb let\u00ebr\u00bb \u00ebsht\u00eb shum\u00eb i v\u00ebshtir\u00eb dhe i paqart\u00eb:<\/p>\n<ul>\n<li>n\u00eb nyj\u00eb shfaqet <b>shuma sipas burimeve t\u00eb n\u00ebnp\u00ebrgjith\u00eb<\/b><br \/>\ndo t\u00eb thot\u00eb q\u00eb p\u00ebr t\u00eb kuptuar sa koh\u00eb u desh p\u00ebr t\u00eb ekzekutuar nj\u00eb nyje t\u00eb caktuar, ose sa t\u00eb dh\u00ebna u lexuan nga e dh\u00ebna n\u00eb disk \u2014 duhet t\u00eb zbres\u00ebsh nj\u00eb nga tjetrin<\/li>\n<li>koha e nyj\u00ebs duhet <b>t\u00eb shum\u00ebzohet me loops<\/b><br \/>\npo, zbritja nuk \u00ebsht\u00eb operacioni m\u00eb i v\u00ebshtir\u00eb q\u00eb duhet b\u00ebr\u00eb \u2018n\u00eb mendje\u2019 \u2014 pasi koha e ekzekutimit jepet e mesatarizuar p\u00ebr nj\u00eb ekzekutim t\u00eb nyj\u00ebs, dhe ato mund t\u00eb jen\u00eb qindra<\/li>\n<li>pra, e gjith\u00eb kjo bashk\u00eb pengon p\u00ebrgjigjen n\u00eb pyetjen kryesore \u2014 kush \u00ebsht\u00eb <b>\u2018nyja m\u00eb e dob\u00ebt\u2019<\/b>?<\/li>\n<\/ul>\n<p>\nKur p\u00ebrpoq\u00ebm t\u00eb shpjegonim t\u00eb gjitha k\u00ebto disa qindra zhvilluesve tan\u00eb, kuptuam se nga jasht\u00eb duket n\u00eb k\u00ebt\u00eb m\u00ebnyr\u00eb:<\/p>\n<p><img decoding=\"async\" alt=\"P\u00ebr \u00e7far\u00eb nuk flet EXPLAIN, dhe si ta b\u00ebjm\u00eb at\u00eb t\u00eb flas\u00eb\" src=\"\/wp-content\/uploads\/2020\/03\/abb07e902639b5ec245851aa4a0edb58.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nPra, na nevojitet...<\/p>\n<h2>Mjeti<\/h2>\n<p>\nN\u00eb t\u00eb, p\u00ebrpiqemi t\u00eb mbledhim t\u00eb gjitha mekanizmat kryesor\u00eb q\u00eb ndihmojn\u00eb sipas planit dhe k\u00ebrkes\u00ebs p\u00ebr t\u00eb kuptuar, \u2018kush \u00ebsht\u00eb fajtori dhe \u00e7far\u00eb t\u00eb b\u00ebjm\u00eb\u2019. Po ashtu, d\u00ebshirojm\u00eb t\u00eb ndajm\u00eb pjes\u00eb t\u00eb p\u00ebrvoj\u00ebs son\u00eb me komunitetin.<br \/>\nMir\u00eb se vini dhe shfryt\u00ebzojeni \u2014 <noindex><a rel=\"nofollow\" href=\"https:\/\/explain.tensor.ru\/\">explain.tensor.ru<\/a><\/noindex> <\/p>\n<h3>Qart\u00ebsia e planeve<\/h3>\n<p>\nA \u00ebsht\u00eb e leht\u00eb t\u00eb kuptohet plani kur duket k\u00ebshtu?<\/p>\n<pre><code class=\"plaintext\">Seq Scan on pg_class (actual time=0.009..1.304 rows=6609 loops=1)\\n  Buffers: shared hit=263\\nPlanning Time: 0.108 ms\\nExecution Time: 1.800 ms\n<\/code><\/pre>\n<p>\nJo shum\u00eb.<\/p>\n<p>Por k\u00ebshtu, <b>n\u00eb nj\u00eb form\u00eb t\u00eb p\u00ebrmbledhur<\/b>, kur treguesit kryesor\u00eb jan\u00eb t\u00eb ndar\u00eb \u2014 tashm\u00eb \u00ebsht\u00eb shum\u00eb m\u00eb e qart\u00eb:<\/p>\n<p><img decoding=\"async\" alt=\"P\u00ebr \u00e7far\u00eb nuk flet EXPLAIN, dhe si ta b\u00ebjm\u00eb at\u00eb t\u00eb flas\u00eb\" src=\"\/wp-content\/uploads\/2020\/03\/18404ce800de847f1934ac2c7fef10be.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nPor n\u00ebse plani \u00ebsht\u00eb m\u00eb i komplikuar \u2014 n\u00eb ndihm\u00eb vjen <b>grafiku i shp\u00ebrndarjes s\u00eb koh\u00ebs<\/b> p\u00ebr nyjat:<\/p>\n<p><img decoding=\"async\" alt=\"P\u00ebr \u00e7far\u00eb nuk flet EXPLAIN, dhe si ta b\u00ebjm\u00eb at\u00eb t\u00eb flas\u00eb\" src=\"\/wp-content\/uploads\/2020\/03\/ca9fdd07278801e4f3ad15e997efc1a0.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nPor, p\u00ebr variantet m\u00eb t\u00eb komplikuara, n\u00eb ndihm\u00eb vjen <b>diagrami i ekzekutimit<\/b>:<\/p>\n<p><img decoding=\"async\" alt=\"P\u00ebr \u00e7far\u00eb nuk flet EXPLAIN, dhe si ta b\u00ebjm\u00eb at\u00eb t\u00eb flas\u00eb\" src=\"\/wp-content\/uploads\/2020\/03\/c03f358858206d7ccae20fd8142baa8c.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nP\u00ebr shembull, ndodhin situata t\u00eb mjaftueshme jo triviale, kur plani mund t\u00eb ket\u00eb m\u00eb shum\u00eb se nj\u00eb rr\u00ebnj\u00eb t\u00eb faktike:<\/p>\n<p><img decoding=\"async\" alt=\"P\u00ebr \u00e7far\u00eb nuk flet EXPLAIN, dhe si ta b\u00ebjm\u00eb at\u00eb t\u00eb flas\u00eb\" src=\"\/wp-content\/uploads\/2020\/03\/ea4f3f498737e9cc3f8f40c16a5bd1d7.png\" style=\"display:block;margin: 0 auto;\" \/><img decoding=\"async\" alt=\"P\u00ebr \u00e7far\u00eb nuk flet EXPLAIN, dhe si ta b\u00ebjm\u00eb at\u00eb t\u00eb flas\u00eb\" src=\"\/wp-content\/uploads\/2020\/03\/267273e8491d6b4403442672612c33ff.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<\/p>\n<h3>K\u00ebshillat strukturore<\/h3>\n<p>\nPor n\u00ebse e gjith\u00eb struktura e planit dhe vendet e saj t\u00eb dob\u00ebta jan\u00eb tashm\u00eb t\u00eb renditura dhe t\u00eb dukshme \u2014 pse t\u00eb mos i ndri\u00e7ojm\u00eb ato p\u00ebr zhvilluesin dhe t'i shpjegojm\u00eb \u2018n\u00eb nj\u00eb gjuh\u00eb t\u00eb thjesht\u00eb\u2019?<\/p>\n<p><img decoding=\"async\" alt=\"P\u00ebr \u00e7far\u00eb nuk flet EXPLAIN, dhe si ta b\u00ebjm\u00eb at\u00eb t\u00eb flas\u00eb\" src=\"\/wp-content\/uploads\/2020\/03\/0e7157a09f7f5707e769cc1d6a8f3af8.png\" style=\"display:block;margin: 0 auto;\" \/>K\u00ebto lloje rekomandimesh kemi mbledhur tashm\u00eb disa dhjet\u00ebra.<\/p>\n<h3>Profiler i rreshtit t\u00eb k\u00ebrkes\u00ebs<\/h3>\n<p>\nTani, n\u00ebse mbi planin e analizuar ngeshen k\u00ebrkesa origjinale, mund t\u00eb shihni sa koh\u00eb ka shkuar p\u00ebr \u00e7do operator t\u00eb ve\u00e7ant\u00eb \u2014 af\u00ebrsisht k\u00ebshtu:<\/p>\n<p><img decoding=\"async\" alt=\"P\u00ebr \u00e7far\u00eb nuk flet EXPLAIN, dhe si ta b\u00ebjm\u00eb at\u00eb t\u00eb flas\u00eb\" src=\"\/wp-content\/uploads\/2020\/03\/0766d331798d529363d10006ace211f3.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n\u2026 ose madje k\u00ebshtu:<\/p>\n<p><img decoding=\"async\" alt=\"P\u00ebr \u00e7far\u00eb nuk flet EXPLAIN, dhe si ta b\u00ebjm\u00eb at\u00eb t\u00eb flas\u00eb\" src=\"\/wp-content\/uploads\/2020\/03\/4efd23d84792c5a7f54b40e86ff17353.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<\/p>\n<h3>Z\u00ebvend\u00ebsimi i parametrave n\u00eb k\u00ebrkes\u00eb<\/h3>\n<p>\nN\u00ebse \u2018keni lidhur\u2019 me planin jo vet\u00ebm k\u00ebrkes\u00ebn, por edhe parametrat e saj nga rreshti DETAIL t\u00eb regjistrit, at\u00ebher\u00eb mund ta kopjoni at\u00eb gjithashtu n\u00eb nj\u00eb nga variantet:<\/p>\n<ul>\n<li>me z\u00ebvend\u00ebsimin e vlerave n\u00eb k\u00ebrkes\u00eb<br \/>\np\u00ebr ekzekutim t\u00eb drejtp\u00ebrdrejt n\u00eb baz\u00ebn tuaj dhe m\u00eb pas profilimin e saj<\/p>\n<pre><code class=\"sql\">SELECT 'const', 'param'::text;<\/code><\/pre>\n<\/li>\n<li>me z\u00ebvend\u00ebsimin e vlerave p\u00ebrmes PREPARE\/EXECUTE<br \/>\np\u00ebr t\u00eb emuluar funksionimin e planifikuesit, kur pjesa parametrike mund t\u00eb injorohet \u2014 p.sh., gjat\u00eb pun\u00ebs me tabela t\u00eb ndara<\/p>\n<pre><code class=\"sql\">DEALLOCATE ALL;\\nPREPARE q(text) AS SELECT 'const', $1::text;\\nEXECUTE q('param'::text);\n<\/code><\/pre>\n<\/li>\n<\/ul>\n<p><\/p>\n<h3>Arkivi i planeve<\/h3>\n<p>\nShtoni, analizoni, ndahuni me koleg\u00ebt! Planet do t\u00eb q\u00ebndrojn\u00eb n\u00eb arkiv dhe do t\u00eb mund t\u00eb ktheheni te ato m\u00eb von\u00eb: <noindex><a rel=\"nofollow\" href=\"https:\/\/explain.tensor.ru\/archive\/\">explain.tensor.ru\/archive<\/a><\/noindex><\/p>\n<p>Por n\u00ebse nuk d\u00ebshironi q\u00eb plani juaj t\u00eb shfaqet nga t\u00eb tjer\u00ebt, mos harroni t\u00eb sh\u00ebnoni kutin\u00eb \u2018mos e publikoni n\u00eb arkiv\u2019.<\/p>\n<p>N\u00eb artikujt e ardhsh\u00ebm do t\u00eb flas p\u00ebr ato sfida dhe zgjidhje q\u00eb shfaqen gjat\u00eb analiz\u00ebs s\u00eb planit.<br \/>\n<br \/>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/tensor\/blog\/477624\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041a\u043b\u0430\u0441\u0441\u0438\u0447\u0435\u0441\u043a\u0438\u0439 \u0432\u043e\u043f\u0440\u043e\u0441, \u0441 \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a \u043f\u0440\u0438\u0445\u043e\u0434\u0438\u0442 \u043a \u0441\u0432\u043e\u0435\u043c\u0443 DBA \u0438\u043b\u0438 \u0432\u043b\u0430\u0434\u0435\u043b\u0435\u0446 \u0431\u0438\u0437\u043d\u0435\u0441\u0430 \u2014 \u043a \u043a\u043e\u043d\u0441\u0443\u043b\u044c\u0442\u0430\u043d\u0442\u0443 \u043f\u043e PostgreSQL, \u043f\u043e\u0447\u0442\u0438 \u0432\u0441\u0435\u0433\u0434\u0430 \u0437\u0432\u0443\u0447\u0438\u0442 \u043e\u0434\u0438\u043d\u0430\u043a\u043e\u0432\u043e: \u00ab\u041f\u043e\u0447\u0435\u043c\u0443 \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u044e\u0442\u0441\u044f \u043d\u0430 \u0431\u0430\u0437\u0435 \u0442\u0430\u043a \u0434\u043e\u043b\u0433\u043e?\u00bb \u0422\u0440\u0430\u0434\u0438\u0446\u0438\u043e\u043d\u043d\u044b\u0439 \u043d\u0430\u0431\u043e\u0440 \u043f\u0440\u0438\u0447\u0438\u043d: \u043d\u0435\u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u044b\u0439 \u0430\u043b\u0433\u043e\u0440\u0438\u0442\u043c \u043a\u043e\u0433\u0434\u0430 \u0432\u044b \u0440\u0435\u0448\u0438\u043b\u0438 \u0441\u0434\u0435\u043b\u0430\u0442\u044c JOIN \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u0445 CTE \u043f\u043e \u043f\u0430\u0440\u0435 \u0434\u0435\u0441\u044f\u0442\u043a\u043e\u0432 \u0442\u044b\u0441\u044f\u0447 \u0437\u0430\u043f\u0438\u0441\u0435\u0439 \u043d\u0435\u0430\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u0430\u044f \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u043a\u0430 \u0435\u0441\u043b\u0438 \u0444\u0430\u043a\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0435 \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 \u0443\u0436\u0435 \u0441\u0438\u043b\u044c\u043d\u043e [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":75679,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-75678","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041a\u043b\u0430\u0441\u0441\u0438\u0447\u0435\u0441\u043a\u0438\u0439 \u0432\u043e\u043f\u0440\u043e\u0441, \u0441 \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a \u043f\u0440\u0438\u0445\u043e\u0434\u0438\u0442 \u043a \u0441\u0432\u043e\u0435\u043c\u0443 DBA \u0438\u043b\u0438 \u0432\u043b\u0430\u0434\u0435\u043b\u0435\u0446 \u0431\u0438\u0437\u043d\u0435\u0441\u0430 \u2014 \u043a \u043a\u043e\u043d\u0441\u0443\u043b\u044c\u0442\u0430\u043d\u0442\u0443 \u043f\u043e PostgreSQL, \u043f\u043e\u0447\u0442\u0438 \u0432\u0441\u0435\u0433\u0434\u0430 \u0437\u0432\u0443\u0447\u0438\u0442 \u043e\u0434\u0438\u043d\u0430\u043a\u043e\u0432\u043e: \u00ab\u041f\u043e\u0447\u0435\u043c\u0443 \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u044e\u0442\u0441\u044f \u043d\u0430 \u0431\u0430\u0437\u0435 \u0442\u0430\u043a \u0434\u043e\u043b\u0433\u043e?\u00bb .\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/o-chem-molchit-explain-i-kak-ego-razgovorit\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u041e \u0447\u0435\u043c \u043c\u043e\u043b\u0447\u0438\u0442 EXPLAIN, \u0438 \u043a\u0430\u043a \u0435\u0433\u043e \u0440\u0430\u0437\u0433\u043e\u0432\u043e\u0440\u0438\u0442\u044c | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041a\u043b\u0430\u0441\u0441\u0438\u0447\u0435\u0441\u043a\u0438\u0439 \u0432\u043e\u043f\u0440\u043e\u0441, \u0441 \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a \u043f\u0440\u0438\u0445\u043e\u0434\u0438\u0442 \u043a \u0441\u0432\u043e\u0435\u043c\u0443 DBA \u0438\u043b\u0438 \u0432\u043b\u0430\u0434\u0435\u043b\u0435\u0446 \u0431\u0438\u0437\u043d\u0435\u0441\u0430 \u2014 \u043a \u043a\u043e\u043d\u0441\u0443\u043b\u044c\u0442\u0430\u043d\u0442\u0443 \u043f\u043e PostgreSQL, \u043f\u043e\u0447\u0442\u0438 \u0432\u0441\u0435\u0433\u0434\u0430 \u0437\u0432\u0443\u0447\u0438\u0442 \u043e\u0434\u0438\u043d\u0430\u043a\u043e\u0432\u043e: \u00ab\u041f\u043e\u0447\u0435\u043c\u0443 \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u044e\u0442\u0441\u044f \u043d\u0430 \u0431\u0430\u0437\u0435 \u0442\u0430\u043a \u0434\u043e\u043b\u0433\u043e?\u00bb .\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/o-chem-molchit-explain-i-kak-ego-razgovorit\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-03-27T17:42:27+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-03-27T17:42:27+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47P\u00ebr \u00e7far\u00eb hesht EXPLAIN, dhe si ta b\u00ebjm\u00eb at\u00eb t\u00eb flas\u00eb | ProHoster","description":"Pyetja klasike me t\u00eb cil\u00ebn nj\u00eb zhvillues i drejtohet DBA-s\u00eb s\u00eb tij ose nj\u00eb pronar biznesi - nj\u00eb konsultant p\u00ebr PostgreSQL, pothuajse gjithmon\u00eb ting\u00ebllon nj\u00ebsoj: 'Pse k\u00ebrkesat ekzekutohen p\u00ebr kaq gjat\u00eb n\u00eb baz\u00ebn e t\u00eb dh\u00ebnave?'.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/o-chem-molchit-explain-i-kak-ego-razgovorit","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u041e \u0447\u0435\u043c \u043c\u043e\u043b\u0447\u0438\u0442 EXPLAIN, \u0438 \u043a\u0430\u043a \u0435\u0433\u043e \u0440\u0430\u0437\u0433\u043e\u0432\u043e\u0440\u0438\u0442\u044c | ProHoster","og:description":"\u041a\u043b\u0430\u0441\u0441\u0438\u0447\u0435\u0441\u043a\u0438\u0439 \u0432\u043e\u043f\u0440\u043e\u0441, \u0441 \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a \u043f\u0440\u0438\u0445\u043e\u0434\u0438\u0442 \u043a \u0441\u0432\u043e\u0435\u043c\u0443 DBA \u0438\u043b\u0438 \u0432\u043b\u0430\u0434\u0435\u043b\u0435\u0446 \u0431\u0438\u0437\u043d\u0435\u0441\u0430 \u2014 \u043a \u043a\u043e\u043d\u0441\u0443\u043b\u044c\u0442\u0430\u043d\u0442\u0443 \u043f\u043e PostgreSQL, \u043f\u043e\u0447\u0442\u0438 \u0432\u0441\u0435\u0433\u0434\u0430 \u0437\u0432\u0443\u0447\u0438\u0442 \u043e\u0434\u0438\u043d\u0430\u043a\u043e\u0432\u043e: \u00ab\u041f\u043e\u0447\u0435\u043c\u0443 \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u044e\u0442\u0441\u044f \u043d\u0430 \u0431\u0430\u0437\u0435 \u0442\u0430\u043a \u0434\u043e\u043b\u0433\u043e?\u00bb .","og:url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/o-chem-molchit-explain-i-kak-ego-razgovorit","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-03-27T17:42:27+00:00","article:modified_time":"2020-03-27T17:42:27+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"75678","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 17:51:29","updated":"2022-09-30 01:03:00","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/75678","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=75678"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/75678\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/75679"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=75678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=75678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=75678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}