From: | Ronaldlee Ejalu <ejaluronaldlee(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | SQL State 42P01 |
Date: | 2015-06-10 18:49:43 |
Message-ID: | CAGFFjRhLoDLBkhg5jCPR6okduT-7jzeDxS_1vCxgC+ofHH_heQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi all,
I have this query I am executing against a postgres database instance 9.3,
<Code>
SELECT relname
, seq_scan-idx_scan AS too_much_seq
, case when seq_scan-idx_scan>0 THEN 'Missing Index?' ELSE 'OK' END
, pg_relation_size(relname::regclass) AS rel_size
, seq_scan, idx_scan
FROM pg_stat_all_tables
WHERE schemaname='atg' AND pg_relation_size(relname::regclass)>80000
/*AND relname NOT IN ('iml_returns'
,'purch_order'
, 'rpt_dates'
,'paypal_analysis_validation'
, 'ntv_data_mv_cte'
,'sg_atg_test','sg_atg_set','personalized_skul',
'month_sku_rollup', 'on_order_sku_rollup', 'back_order_sku')*/
ORDER BY too_much_seq DESC;</Code>
This checks to see if there are more sequence scans than index scan.
When I execute the query it complains of the existing relations not being
in existence with a SQL state:42P01.
Is there a way I can resolve this.
Thanks,
Ron
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2015-06-10 19:20:19 | Re: SQL State 42P01 |
Previous Message | Saravanakumar Ramasamy | 2015-06-10 14:57:19 | invalid byte sequence for encoding "UTF8" |