{"width":"100%","provider_name":"Hatena Blog","title":"\u3010PostgreSQL\u3011 \u5168\u30c6\u30fc\u30d6\u30eb\u306e\u4ef6\u6570\u3092\u8868\u793a\u3055\u305b\u308b\u65b9\u6cd5","height":"190","provider_url":"https://hatena.blog","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/a/a1026302/20220614/20220614145904.png","categories":["DB","DB-PostgreSQL"],"type":"rich","url":"https://a1026302.hatenablog.com/entry/2021/06/10/141841","version":"1.0","blog_title":"\u3082\u306e\u3065\u304f\u308a\u306e\u30d6\u30ed\u30b0","author_name":"a1026302","description":"Postgres SQL\u306b\u306b\u767b\u9332\u3055\u308c\u3066\u3044\u308b\u30c6\u30fc\u30d6\u30eb\u540d\u3068\u3001\u305d\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u767b\u9332\u3055\u308c\u3066\u3044\u308b\u30ec\u30b3\u30fc\u30c9\u6570\u3092\u4e00\u89a7\u306b\u3057\u3066\u8868\u793a\u3059\u308b\u65b9\u6cd5\u3067\u3059\u3002 \u30c6\u30fc\u30d6\u30eb\u4e00\u89a7\u3068\u305d\u306e\u30c7\u30fc\u30bf\u4ef6\u6570\u3092\u8868\u793a\u3059\u308b SQL\u305d\u306e1 SQL\u305d\u306e2 \u53c2\u8003 pg_stat_user_tables pg_class \u30c6\u30fc\u30d6\u30eb\u4e00\u89a7\u3068\u305d\u306e\u30c7\u30fc\u30bf\u4ef6\u6570\u3092\u8868\u793a\u3059\u308b SQL\u305d\u306e1 select relname, n_live_tup from pg_stat_user_tables where schemaname='public'; SQL\u305d\u306e2 SELECT T2.relname , T2.reltuples FROM pg_stat_user_tables \u2026","author_url":"https://blog.hatena.ne.jp/a1026302/","published":"2021-06-10 14:18:41","blog_url":"https://a1026302.hatenablog.com/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fa1026302.hatenablog.com%2Fentry%2F2021%2F06%2F10%2F141841\" title=\"\u3010PostgreSQL\u3011 \u5168\u30c6\u30fc\u30d6\u30eb\u306e\u4ef6\u6570\u3092\u8868\u793a\u3055\u305b\u308b\u65b9\u6cd5 - \u3082\u306e\u3065\u304f\u308a\u306e\u30d6\u30ed\u30b0\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}