SQL State 42P01

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

Responses

Browse pgsql-admin by date

  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"