{"id":26684,"date":"2025-07-29T06:15:23","date_gmt":"2025-07-29T03:15:23","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/"},"modified":"2025-07-29T06:15:23","modified_gmt":"2025-07-29T03:15:23","slug":"postgresql-sutundaki-toplamin-yuzdesini-hesaplama","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/","title":{"rendered":"PostgreSQL: S\u00fct\u00fcndaki Toplam\u0131n Y\u00fczdesini Hesaplama"},"content":{"rendered":"<p># PostgreSQL&#8217;de Toplam\u0131n Y\u00fczdesini Hesaplama: Ad\u0131m Ad\u0131m K\u0131lavuz<\/p>\n<p>PostgreSQL veritaban\u0131n\u0131zda toplam de\u011ferlere g\u00f6re y\u00fczdeleri hesaplaman\u0131z m\u0131 gerekiyor?  \u00d6rne\u011fin, her \u00fcr\u00fcn\u00fcn toplam sat\u0131\u015flardaki pay\u0131n\u0131 veya her b\u00f6lgenin toplam m\u00fc\u015fteri say\u0131s\u0131ndaki oran\u0131n\u0131 bulmak istiyor olabilirsiniz. Bu makale, PostgreSQL&#8217;de bu hesaplamalar\u0131 yapman\u0131n farkl\u0131 y\u00f6ntemlerini, performans optimizasyonunu ve olas\u0131 sorunlar\u0131 ad\u0131m ad\u0131m a\u00e7\u0131klayarak size uzman seviyesinde bir rehber sunacakt\u0131r.  Veri analizi ve raporlama s\u00fcre\u00e7lerinizi iyile\u015ftirmek i\u00e7in ihtiyac\u0131n\u0131z olan t\u00fcm bilgileri bulacaks\u0131n\u0131z.<\/p>\n<p><strong>PostgreSQL&#8217;de Y\u00fczde Hesaplaman\u0131n Temelleri<\/strong><\/p>\n<p>PostgreSQL&#8217;de toplam\u0131n y\u00fczdesini hesaplamak i\u00e7in temel SQL fonksiyonlar\u0131n\u0131 kullan\u0131r\u0131z.  Bunlar\u0131n ba\u015f\u0131nda <code class=\"language-\">SUM()<\/code>, <code class=\"language-\">COUNT()<\/code>, ve <code class=\"language-\">AVG()<\/code> gibi agrega fonksiyonlar\u0131 gelir.  Ayr\u0131ca, y\u00fczdeleri hesaplamak i\u00e7in standart aritmetik operat\u00f6rleri (<code class=\"language-\">\/<\/code> ve <code class=\"language-\">*<\/code>) ve <code class=\"language-\">ROUND()<\/code> fonksiyonu (sonucu yuvarlamak i\u00e7in) kullan\u0131r\u0131z.  Temel olarak, bir s\u00fctunun toplam\u0131n\u0131 bulur, her sat\u0131r\u0131n de\u011ferini bu toplama b\u00f6ler ve sonucu 100 ile \u00e7arpar\u0131z.<\/p>\n<p>\u00d6rne\u011fin, basit bir <code class=\"language-\">sales<\/code> tablomuz oldu\u011funu d\u00fc\u015f\u00fcnelim:<\/p>\n<p>| product | sales |<br \/>\n|&#8212;|&#8212;|<br \/>\n| A | 100 |<br \/>\n| B | 200 |<br \/>\n| C | 300 |<\/p>\n<p>Bu tablodaki her \u00fcr\u00fcn\u00fcn toplam sat\u0131\u015flardaki y\u00fczdesini hesaplamak i\u00e7in a\u015fa\u011f\u0131daki sorguyu kullanabiliriz:<\/p>\n<pre class=\"language-sql\"><code>SELECT\n    product,\n    sales,\n    (sales::numeric \/ SUM(sales::numeric) OVER ()) * 100 AS sales_percentage\nFROM\n    sales;<\/code><\/pre>\n<p>Bu sorgu, <code class=\"language-\">SUM(sales::numeric) OVER ()<\/code> ile t\u00fcm sat\u0131\u015flar\u0131n toplam\u0131n\u0131 hesaplar ve her sat\u0131r i\u00e7in bu toplama g\u00f6re y\u00fczdesini belirler.  <code class=\"language-\">::numeric<\/code> d\u00f6n\u00fc\u015f\u00fcm\u00fc, tam say\u0131 b\u00f6lmesinden kaynaklanabilecek olas\u0131 yuvarlama hatalar\u0131n\u0131 \u00f6nlemek i\u00e7in kullan\u0131lm\u0131\u015ft\u0131r.  <code class=\"language-\">OVER()<\/code> pencere fonksiyonu, t\u00fcm sat\u0131rlar \u00fczerinde toplam\u0131 hesaplamam\u0131z\u0131 sa\u011flar.<\/p>\n<p><strong>PostgreSQL&#8217;de Y\u00fczde Hesaplama: Uygulamal\u0131 K\u0131lavuz<\/strong><\/p>\n<p>\u015eimdi, farkl\u0131 karma\u015f\u0131kl\u0131k seviyelerine sahip \u00f6rneklerle konuyu daha detayl\u0131 inceleyelim.<\/p>\n<p><strong># Yeni Ba\u015flayanlar \u0130\u00e7in Ad\u0131m Ad\u0131m A\u00e7\u0131klama: Basit Kod \u00d6rne\u011fi<\/strong><\/p>\n<p>Bir \u00f6\u011frenci notlar\u0131 tablosunda her \u00f6\u011frencinin s\u0131n\u0131f ortalamas\u0131na g\u00f6re y\u00fczdesini hesaplayal\u0131m:<\/p>\n<pre class=\"language-sql\"><code>CREATE TABLE student_grades (\n    student_name TEXT,\n    grade INTEGER\n);\n\nINSERT INTO student_grades (student_name, grade) VALUES\n('Ahmet', 80),\n('Ay\u015fe', 90),\n('Mehmet', 75),\n('Fatma', 85);\n\nSELECT\n    student_name,\n    grade,\n    (grade::numeric \/ AVG(grade::numeric) OVER ()) * 100 AS grade_percentage\nFROM\n    student_grades;<\/code><\/pre>\n<p>Bu kod, \u00f6ncelikle <code class=\"language-\">student_grades<\/code> tablosunu olu\u015fturur ve verileri ekler. Ard\u0131ndan, <code class=\"language-\">AVG(grade::numeric) OVER()<\/code> ile t\u00fcm notlar\u0131n ortalamas\u0131n\u0131 hesaplar ve her \u00f6\u011frencinin notunun bu ortalamaya g\u00f6re y\u00fczdesini hesaplar.<\/p>\n<p><strong># Orta Seviye: Ger\u00e7ek Hayat \u00d6rne\u011fi ve Optimizasyon \u0130pu\u00e7lar\u0131<\/strong><\/p>\n<p>Bir e-ticaret \u015firketinde, her \u00fcr\u00fcn kategorisinin toplam sat\u0131\u015flardaki pay\u0131n\u0131 hesaplamam\u0131z gerekiyor.  \u00dcr\u00fcnler ve sat\u0131\u015flar\u0131 i\u00e7eren bir <code class=\"language-\">products<\/code> tablosu oldu\u011funu varsayal\u0131m:<\/p>\n<pre class=\"language-sql\"><code>CREATE TABLE products (\n    product_id INTEGER PRIMARY KEY,\n    category TEXT,\n    sales_amount NUMERIC\n);\n\n-- ... (Veri ekleme i\u015flemleri) ...<\/code><\/pre>\n<p>A\u015fa\u011f\u0131daki sorgu, her kategorinin toplam sat\u0131\u015flardaki y\u00fczdesini hesaplar:<\/p>\n<pre class=\"language-sql\"><code>SELECT\n    category,\n    SUM(sales_amount) AS total_sales_category,\n    (SUM(sales_amount)::numeric \/ SUM(SUM(sales_amount)) OVER ()) * 100 AS percentage\nFROM\n    products\nGROUP BY\n    category;<\/code><\/pre>\n<p>Bu sorgu, <code class=\"language-\">GROUP BY<\/code> kullanarak kategorilere g\u00f6re sat\u0131\u015flar\u0131 toplar ve daha sonra her kategorinin toplam sat\u0131\u015flara g\u00f6re y\u00fczdesini hesaplar.  Performans\u0131 art\u0131rmak i\u00e7in uygun indeksler olu\u015fturmak \u00f6nemlidir.  \u00d6rne\u011fin, <code class=\"language-\">category<\/code> ve <code class=\"language-\">sales_amount<\/code> s\u00fctunlar\u0131na indeks eklemek sorgu performans\u0131n\u0131 iyile\u015ftirebilir.<\/p>\n<p><strong># \u0130leri D\u00fczey: Performans Analizi ve Edge Case&#8217;ler<\/strong><\/p>\n<p>\u00c7ok b\u00fcy\u00fck veri k\u00fcmeleriyle \u00e7al\u0131\u015f\u0131rken, yukar\u0131daki sorgular\u0131n performans\u0131 d\u00fc\u015febilir.  Bu durumda, materyalize g\u00f6r\u00fcn\u00fcmler (<code class=\"language-\">MATERIALIZED VIEW<\/code>) kullanarak \u00f6nceden hesaplanm\u0131\u015f y\u00fczdeleri saklamak performans\u0131 \u00f6nemli \u00f6l\u00e7\u00fcde art\u0131rabilir.  Ayr\u0131ca, <code class=\"language-\">WITH<\/code> deyimi kullanarak sorgular\u0131 daha okunabilir ve optimize edilebilir hale getirebiliriz.<\/p>\n<p>\u00d6rne\u011fin:<\/p>\n<pre class=\"language-sql\"><code>WITH CategorySales AS (\n    SELECT\n        category,\n        SUM(sales_amount) AS total_sales_category\n    FROM\n        products\n    GROUP BY\n        category\n),\nTotalSales AS (\n    SELECT SUM(total_sales_category) AS grand_total FROM CategorySales\n)\nSELECT\n    cs.category,\n    cs.total_sales_category,\n    (cs.total_sales_category::numeric \/ ts.grand_total) * 100 AS percentage\nFROM\n    CategorySales cs\nCROSS JOIN\n    TotalSales ts;<\/code><\/pre>\n<p>Bu yakla\u015f\u0131m, \u00f6ncelikle kategorilere g\u00f6re toplam sat\u0131\u015flar\u0131 hesaplar ve daha sonra bu toplam\u0131 genel toplamla kar\u015f\u0131la\u015ft\u0131r\u0131r.  Bu, b\u00fcy\u00fck veri k\u00fcmeleri i\u00e7in daha verimli olabilir.  Ayr\u0131ca, s\u0131f\u0131r de\u011ferleri ve bo\u015f kategorileri ele almak i\u00e7in ek kontroller eklemek gerekebilir.  <code class=\"language-\">CASE<\/code> deyimi veya <code class=\"language-\">COALESCE()<\/code> fonksiyonu bu gibi durumlarda yard\u0131mc\u0131 olabilir.<\/p>\n<p><strong>PostgreSQL&#8217;de Y\u00fczde Hesaplama: \u00d6\u011frenme Yol Haritas\u0131<\/strong><\/p>\n<p><strong>Yeni Ba\u015flayan:<\/strong>  Basit bir tablo \u00fczerinde,  <code class=\"language-\">AVG()<\/code> veya <code class=\"language-\">SUM()<\/code> fonksiyonlar\u0131n\u0131 kullanarak toplam\u0131n y\u00fczdesini hesaplamak.  Yukar\u0131daki basit \u00f6\u011frenci notlar\u0131 \u00f6rne\u011fi ideal bir ba\u015flang\u0131\u00e7 noktas\u0131d\u0131r.<\/p>\n<p><strong>Orta Seviye:<\/strong>  Ger\u00e7ek d\u00fcnya senaryolar\u0131 (\u00f6rne\u011fin, e-ticaret verileri) \u00fczerinde, <code class=\"language-\">GROUP BY<\/code> ve pencere fonksiyonlar\u0131n\u0131 kullanarak y\u00fczdeleri hesaplamak.  \u0130ndeksleme ve sorgu optimizasyonu tekniklerini uygulamak.<\/p>\n<p><strong>\u0130leri Seviye:<\/strong>  \u00c7ok b\u00fcy\u00fck veri k\u00fcmeleri i\u00e7in materyalize g\u00f6r\u00fcn\u00fcmler ve <code class=\"language-\">WITH<\/code> deyimini kullanarak performans\u0131 optimize etmek.  S\u0131f\u0131r de\u011ferleri ve bo\u015f verileri ele almak i\u00e7in <code class=\"language-\">CASE<\/code> deyimi ve <code class=\"language-\">COALESCE()<\/code> fonksiyonunu kullanmak.  Performans analizi ara\u00e7lar\u0131n\u0131 kullanarak sorgu performans\u0131n\u0131 izlemek ve iyile\u015ftirmek.<\/p>\n<p><strong>Sonu\u00e7<\/strong><\/p>\n<p>PostgreSQL&#8217;de toplam\u0131n y\u00fczdesini hesaplamak i\u00e7in \u00e7e\u015fitli y\u00f6ntemler mevcuttur.  Se\u00e7ti\u011finiz y\u00f6ntem, veri k\u00fcmenizin b\u00fcy\u00fckl\u00fc\u011f\u00fc ve karma\u015f\u0131kl\u0131\u011f\u0131na ba\u011fl\u0131d\u0131r.  Bu makalede sunulan ad\u0131mlar ve \u00f6rnekler, farkl\u0131 karma\u015f\u0131kl\u0131k seviyelerindeki sorunlar\u0131 \u00e7\u00f6zmenize yard\u0131mc\u0131 olacakt\u0131r.  Veri analizi ve raporlamada daha etkili olmak i\u00e7in bu teknikleri uygulaman\u0131z ve s\u00fcrekli olarak \u00f6\u011frenmenizi tavsiye ederim.  Daha fazla bilgi i\u00e7in [fatihsoysal.com](https:\/\/fatihsoysal.com) adresini ziyaret edebilirsiniz.<\/p>\n<p><strong>S\u0131k\u00e7a Sorulan Sorular:<\/strong><\/p>\n<p>1. <strong>Y\u00fczde hesaplamalar\u0131nda yuvarlama hatalar\u0131 nas\u0131l \u00f6nlenir?<\/strong> <code class=\"language-\">NUMERIC<\/code> veri tipi kullanarak ve <code class=\"language-\">ROUND()<\/code> fonksiyonu ile yuvarlayarak yuvarlama hatalar\u0131n\u0131 minimize edebilirsiniz.<\/p>\n<p>2. <strong>\u00c7ok b\u00fcy\u00fck veri k\u00fcmeleri i\u00e7in performans\u0131 nas\u0131l art\u0131rabilirim?<\/strong> Materyalize g\u00f6r\u00fcn\u00fcmler, indeksleme ve sorgu optimizasyonu teknikleri kullan\u0131n.<\/p>\n<p>3. <strong>S\u0131f\u0131r de\u011ferleriyle nas\u0131l ba\u015fa \u00e7\u0131kabilirim?<\/strong> <code class=\"language-\">CASE<\/code> deyimi veya <code class=\"language-\">COALESCE()<\/code> fonksiyonu kullanarak s\u0131f\u0131r de\u011ferlerini ele alabilirsiniz.<\/p>\n<p>4. <strong>Bo\u015f kategorilerle nas\u0131l ba\u015fa \u00e7\u0131kabilirim?<\/strong> <code class=\"language-\">COALESCE()<\/code> fonksiyonu veya <code class=\"language-\">CASE<\/code> deyimi kullanarak bo\u015f kategorileri y\u00f6netebilirsiniz.<\/p>\n<p>5. <strong>Pencere fonksiyonlar\u0131 nedir ve ne zaman kullan\u0131l\u0131r?<\/strong> Pencere fonksiyonlar\u0131, bir veri k\u00fcmesinin alt k\u00fcmelerinde agrega i\u015flemlerini ger\u00e7ekle\u015ftirmenizi sa\u011flar.  Toplam\u0131n y\u00fczdesini hesaplamak gibi durumlarda olduk\u00e7a kullan\u0131\u015fl\u0131d\u0131rlar.<\/p>\n<p>Yazar: Fatih Soysal<\/p>\n","protected":false},"excerpt":{"rendered":"# PostgreSQL&#8217;de Toplam\u0131n Y\u00fczdesini Hesaplama: Ad\u0131m Ad\u0131m K\u0131lavuz PostgreSQL veritaban\u0131n\u0131zda toplam de\u011ferlere g\u00f6re y\u00fczdeleri hesaplaman\u0131z m\u0131 gerekiyor? \u00d6rne\u011fin,&hellip;","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[644],"tags":[],"class_list":{"0":"post-26684","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-postgresql","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PostgreSQL: S\u00fct\u00fcndaki Toplam\u0131n Y\u00fczdesini Hesaplama<\/title>\n<meta name=\"description\" content=\"Hi\u00e7bir etiketi bulunamad\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL: S\u00fct\u00fcndaki Toplam\u0131n Y\u00fczdesini Hesaplama\" \/>\n<meta property=\"og:description\" content=\"Hi\u00e7bir etiketi bulunamad\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-29T03:15:23+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"PostgreSQL: S\u00fct\u00fcndaki Toplam\u0131n Y\u00fczdesini Hesaplama\",\"datePublished\":\"2025-07-29T03:15:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/\"},\"wordCount\":898,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/\",\"name\":\"PostgreSQL: S\u00fct\u00fcndaki Toplam\u0131n Y\u00fczdesini Hesaplama\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-07-29T03:15:23+00:00\",\"description\":\"Hi\u00e7bir etiketi bulunamad\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL: S\u00fct\u00fcndaki Toplam\u0131n Y\u00fczdesini Hesaplama\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PostgreSQL: S\u00fct\u00fcndaki Toplam\u0131n Y\u00fczdesini Hesaplama","description":"Hi\u00e7bir etiketi bulunamad\u0131.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/","og_locale":"tr_TR","og_type":"article","og_title":"PostgreSQL: S\u00fct\u00fcndaki Toplam\u0131n Y\u00fczdesini Hesaplama","og_description":"Hi\u00e7bir etiketi bulunamad\u0131.","og_url":"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-07-29T03:15:23+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"5 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"PostgreSQL: S\u00fct\u00fcndaki Toplam\u0131n Y\u00fczdesini Hesaplama","datePublished":"2025-07-29T03:15:23+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/"},"wordCount":898,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["PostgreSQL"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/","url":"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/","name":"PostgreSQL: S\u00fct\u00fcndaki Toplam\u0131n Y\u00fczdesini Hesaplama","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-07-29T03:15:23+00:00","description":"Hi\u00e7bir etiketi bulunamad\u0131.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-sutundaki-toplamin-yuzdesini-hesaplama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL: S\u00fct\u00fcndaki Toplam\u0131n Y\u00fczdesini Hesaplama"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/26684","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=26684"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/26684\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=26684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=26684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=26684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}