Видео

Keep watching

mynotesoracledba.medium.com/how-to-create-a-multi-branch-pipeline-job-in-jenkins-12ed358d920

Thank you

Thanks you so much bro✌

You can refer this blog wiki.postgresql.org/wiki/Disk_Usage

Thank you so much

Thank you so much🙏✌

Sure mam, will do✌

Share your email address

Thanks aysha✌🙏

Thanks jose🙏

Without them there is no family 😉

Thanks for your feed back✌

Can you pls elaborate your questions

@@raghuldrag I have customers -schema and having 5 tables with 5000 records for each table. Now I want to take customers schema with only 100 records from each table.

@@raghuldrag Table is having 1000 records but I want take backup only 200 records using pg_dump. Is it possible? Tell me how ?

@@mastimasti3898 you can do it but you should create one more table like create table sports as select * from sports_org where sports_name='cricket'; then do pgdump backup

Can u pls Specific more about what you want to achieve?

@@mynotesoracledba I have customer table.. i need to push the history logs of the table to temporal table and export as file...

so, can i use temporal tables for maintaining history logs?

is temporal tables valid only till the session...or can i prolong them

@@vijaybaskar6696 it is valid till the sessions

Thank you🙏

Thanks for you valuable feedback ✌

Thank you for your valuable time😊✌

Thank you bro 😊✌

Thanks bro✌

Hi Umashankar, Please find the query details SELECT current_database(), schemaname, tablename, /*reltuples::bigint, relpages::bigint, otta,*/ ROUND((CASE WHEN otta=0 THEN 0.0 ELSE sml.relpages::float/otta END)::numeric,1) AS tbloat, CASE WHEN relpages < otta THEN 0 ELSE bs*(sml.relpages-otta)::BIGINT END AS wastedbytes, iname, /*ituples::bigint, ipages::bigint, iotta,*/ ROUND((CASE WHEN iotta=0 OR ipages=0 THEN 0.0 ELSE ipages::float/iotta END)::numeric,1) AS ibloat, CASE WHEN ipages < iotta THEN 0 ELSE bs*(ipages-iotta) END AS wastedibytes FROM ( SELECT schemaname, tablename, cc.reltuples, cc.relpages, bs, CEIL((cc.reltuples*((datahdr+ma- (CASE WHEN datahdr%ma=0 THEN ma ELSE datahdr%ma END))+nullhdr2+4))/(bs-20::float)) AS otta, COALESCE(c2.relname,'?') AS iname, COALESCE(c2.reltuples,0) AS ituples, COALESCE(c2.relpages,0) AS ipages, COALESCE(CEIL((c2.reltuples*(datahdr-12))/(bs-20::float)),0) AS iotta -- very rough approximation, assumes all cols FROM ( SELECT ma,bs,schemaname,tablename, (datawidth+(hdr+ma-(case when hdr%ma=0 THEN ma ELSE hdr%ma END)))::numeric AS datahdr, (maxfracsum*(nullhdr+ma-(case when nullhdr%ma=0 THEN ma ELSE nullhdr%ma END))) AS nullhdr2 FROM ( SELECT schemaname, tablename, hdr, ma, bs, SUM((1-null_frac)*avg_width) AS datawidth, MAX(null_frac) AS maxfracsum, hdr+( SELECT 1+count(*)/8 FROM pg_stats s2 WHERE null_frac<>0 AND s2.schemaname = s.schemaname AND s2.tablename = s.tablename ) AS nullhdr FROM pg_stats s, ( SELECT (SELECT current_setting('block_size')::numeric) AS bs, CASE WHEN substring(v,12,3) IN ('8.0','8.1','8.2') THEN 27 ELSE 23 END AS hdr, CASE WHEN v ~ 'mingw32' THEN 8 ELSE 4 END AS ma FROM (SELECT version() AS v) AS foo ) AS constants GROUP BY 1,2,3,4,5 ) AS foo ) AS rs JOIN pg_class cc ON cc.relname = rs.tablename JOIN pg_namespace nn ON cc.relnamespace = nn.oid AND nn.nspname = rs.schemaname AND nn.nspname <> 'information_schema' LEFT JOIN pg_index i ON indrelid = cc.oid LEFT JOIN pg_class c2 ON c2.oid = i.indexrelid ) AS sml ORDER BY wastedbytes DESC