Alter command getting stuck on a table
Shrikant Bhende <[email protected]> Tue, 7 Jan 2020 14:58:36 +0530
| Newsgroups | gmane.comp.db.postgresql.admin |
|---|---|
| Message-ID | <CAMTQpJALSF2EvBqmdYCqKnXx-o2VQZ4+KRn1TsstudQukC0Ryg@mail.gmail.com> |
--000000000000487cc5059b896c9f
Content-Type: text/plain; charset="UTF-8"
Hello,
I am trying to add a column to a table but it's not working, I have also
tried reindex and drop on the same table but those commands are also
getting stuck.
Below is the table structure and lock details
Table
"csp_details.gcp_compute_pricing"
Column | Type
| Collation | Nullable | Default
---------------------------------------------------------+-----------------------------+-----------+----------+-------------------------------------------------------------
id | bigint
| | not null |
nextval('csp_details.gcp_compute_pricing_id_seq'::regclass)
instance_type | character
varying(255) | | |
hourly_rate_full_lowest_price_with_full_sustained_usage | real
| | |
hourly_rate_typical_price | real
| | |
hourly_rate_full_price_without_sustained_usage | real
| | |
hourly_rate_preemptible_price_per_hour | real
| | |
region | character
varying(255) | | |
platform | character
varying(255) | | |
last_updated_timestamp | timestamp
without time zone | | | now()
current_generation | boolean
| | | false
Indexes:
"gcp_compute_pricing_pkey" PRIMARY KEY, btree (id)
PG_stat_activity O/P
-[ RECORD 1
]----+---------------------------------------------------------------------------------------------
datid | 24823
datname | vmware
pid | 6672
usesysid | 10
usename | postgres
application_name | psql
client_addr |
client_hostname |
client_port | -1
backend_start | 2020-01-07 08:31:39.26237+00
xact_start | 2020-01-07 08:36:21.025266+00
query_start | 2020-01-07 08:36:21.025266+00
state_change | 2020-01-07 08:36:21.025273+00
wait_event_type | Lock
wait_event | relation
state | active
backend_xid | 388218816
backend_xmin | 388175669
query | alter table csp_details.gcp_compute_pricing add
one_yr_commitment_price_hourly_rate real;
backend_type | client backend
-[ RECORD 2
]----+-----------------------------------------------------------------------------------------
On this table normal vacuum is working but when I tried for VACUUM FULL it
was not working, I have tried to take pg_dump in case there's any
corruption, pg_dump is working fine.
Thanks
--000000000000487cc5059b896c9f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
<div dir=3D"ltr">Hello,<div><br></div><div>I am trying to add a column to a=
table but it's not working, I have also tried reindex and drop on the =
same table but those commands are also getting stuck.</div><div><br></div><=
div>Below is the table structure and lock details=C2=A0</div><div>
<p class=3D"gmail-p1" style=3D"margin:0px;font-variant-numeric:normal;font-=
variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:no=
rmal;font-family:"Helvetica Neue";min-height:14px"><br></p>
<p class=3D"gmail-p2" style=3D"margin:0px;font-variant-numeric:normal;font-=
variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:no=
rmal;font-family:"Helvetica Neue""><span class=3D"gmail-Apple-con=
verted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 </span>Table "csp_details.gcp_compute_pricing=
"</p>
<p class=3D"gmail-p2" style=3D"margin:0px;font-variant-numeric:normal;font-=
variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:no=
rmal;font-family:"Helvetica Neue""><span class=3D"gmail-Apple-con=
verted-space">=C2=A0=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>Column<span class=3D"gmail-Apple-conver=
ted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>|<span class=3D"gmail-Apple-converted-sp=
ace">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>Type <span class=3D"g=
mail-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </spa=
n>| Collation | Nullable | <span class=3D"gmail-Apple-converted-space">=C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 </span>Default<span class=3D"gmail-Apple-converted-space">=C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0</span></p>
<p class=3D"gmail-p2" style=3D"margin:0px;font-variant-numeric:normal;font-=
variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:no=
rmal;font-family:"Helvetica Neue"">------------------------------=
---------------------------+-----------------------------+-----------+-----=
-----+-------------------------------------------------------------</p>
<p class=3D"gmail-p2" style=3D"margin:0px;font-variant-numeric:normal;font-=
variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:no=
rmal;font-family:"Helvetica Neue""><span class=3D"gmail-Apple-con=
verted-space">=C2=A0</span>id<span class=3D"gmail-Apple-converted-space">=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>| bigint<span class=3D"gma=
il-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>| <span class=3D"gmail-Apple-converted-s=
pace">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>| not null | nextval('c=
sp_details.gcp_compute_pricing_id_seq'::regclass)</p>
<p class=3D"gmail-p2" style=3D"margin:0px;font-variant-numeric:normal;font-=
variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:no=
rmal;font-family:"Helvetica Neue""><span class=3D"gmail-Apple-con=
verted-space">=C2=A0</span>instance_type <span class=3D"gmail-Apple-convert=
ed-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 </span>| character varying(255)<span class=3D"gmail-Apple-conver=
ted-space">=C2=A0 =C2=A0 =C2=A0 </span>| <span class=3D"gmail-Apple-convert=
ed-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>|<span class=3D"gmail-A=
pple-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>|<span clas=
s=3D"gmail-Apple-converted-space">=C2=A0</span></p>
<p class=3D"gmail-p2" style=3D"margin:0px;font-variant-numeric:normal;font-=
variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:no=
rmal;font-family:"Helvetica Neue""><span class=3D"gmail-Apple-con=
verted-space">=C2=A0</span>hourly_rate_full_lowest_price_with_full_sustaine=
d_usage | real<span class=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>|=
<span class=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 </span>|<span class=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 </span>|<span class=3D"gmail-Apple-converted-space">=
=C2=A0</span></p>
<p class=3D"gmail-p2" style=3D"margin:0px;font-variant-numeric:normal;font-=
variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:no=
rmal;font-family:"Helvetica Neue""><span class=3D"gmail-Apple-con=
verted-space">=C2=A0</span>hourly_rate_typical_price <span class=3D"gmail-A=
pple-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>| real<span cla=
ss=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>| <span class=3D"gmail=
-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>|<span cl=
ass=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </sp=
an>|<span class=3D"gmail-Apple-converted-space">=C2=A0</span></p>
<p class=3D"gmail-p2" style=3D"margin:0px;font-variant-numeric:normal;font-=
variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:no=
rmal;font-family:"Helvetica Neue""><span class=3D"gmail-Apple-con=
verted-space">=C2=A0</span>hourly_rate_full_price_without_sustained_usage<s=
pan class=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 </span>| real<span class=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </spa=
n>| <span class=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0=
=C2=A0 </span>|<span class=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 </span>|<span class=3D"gmail-Apple-converted-space">=
=C2=A0</span></p>
<p class=3D"gmail-p2" style=3D"margin:0px;font-variant-numeric:normal;font-=
variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:no=
rmal;font-family:"Helvetica Neue""><span class=3D"gmail-Apple-con=
verted-space">=C2=A0</span>hourly_rate_preemptible_price_per_hour<span clas=
s=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
=C2=A0 =C2=A0 =C2=A0 </span>| real<span class=3D"gmail-Apple-converted-spa=
ce">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 </span>| <span class=3D"gmail-Apple-converted-space">=C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>|<span class=3D"gmail-Apple-converted-sp=
ace">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>|<span class=3D"gmail-Apple-=
converted-space">=C2=A0</span></p>
<p class=3D"gmail-p2" style=3D"margin:0px;font-variant-numeric:normal;font-=
variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:no=
rmal;font-family:"Helvetica Neue""><span class=3D"gmail-Apple-con=
verted-space">=C2=A0</span>region<span class=3D"gmail-Apple-converted-space=
">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>| character varying(255)<span class=3D"g=
mail-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 </span>| <span class=3D"gm=
ail-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>|<span=
class=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <=
/span>|<span class=3D"gmail-Apple-converted-space">=C2=A0</span></p>
<p class=3D"gmail-p2" style=3D"margin:0px;font-variant-numeric:normal;font-=
variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:no=
rmal;font-family:"Helvetica Neue""><span class=3D"gmail-Apple-con=
verted-space">=C2=A0</span>platform<span class=3D"gmail-Apple-converted-spa=
ce">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 </span>| character varying(255)<span class=3D"gmai=
l-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 </span>| <span class=3D"gmail=
-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>|<span cl=
ass=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </sp=
an>|<span class=3D"gmail-Apple-converted-space">=C2=A0</span></p>
<p class=3D"gmail-p2" style=3D"margin:0px;font-variant-numeric:normal;font-=
variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:no=
rmal;font-family:"Helvetica Neue""><span class=3D"gmail-Apple-con=
verted-space">=C2=A0</span>last_updated_timestamp<span class=3D"gmail-Apple=
-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>| tim=
estamp without time zone | <span class=3D"gmail-Apple-converted-space">=C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>|<span class=3D"gmail-Apple-converte=
d-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>| now()</p>
<p class=3D"gmail-p2" style=3D"margin:0px;font-variant-numeric:normal;font-=
variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:no=
rmal;font-family:"Helvetica Neue""><span class=3D"gmail-Apple-con=
verted-space">=C2=A0</span>current_generation<span class=3D"gmail-Apple-con=
verted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <=
/span>| boolean <span class=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>| <span clas=
s=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </span=
>|<span class=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 </span>| false</p>
<p class=3D"gmail-p2" style=3D"margin:0px;font-variant-numeric:normal;font-=
variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:no=
rmal;font-family:"Helvetica Neue"">Indexes:</p>
<p class=3D"gmail-p2" style=3D"margin:0px;font-variant-numeric:normal;font-=
variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:no=
rmal;font-family:"Helvetica Neue""><span class=3D"gmail-Apple-con=
verted-space">=C2=A0 =C2=A0 </span>"gcp_compute_pricing_pkey" PRI=
MARY KEY, btree (id)</p>
<p class=3D"gmail-p1" style=3D"margin:0px;font-variant-numeric:normal;font-=
variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:no=
rmal;font-family:"Helvetica Neue";min-height:14px"><br></p>
<p class=3D"gmail-p1" style=3D"margin:0px;font-variant-numeric:normal;font-=
variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:no=
rmal;font-family:"Helvetica Neue";min-height:14px"><br></p><p cla=
ss=3D"gmail-p1" style=3D"margin:0px;font-variant-numeric:normal;font-varian=
t-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;f=
ont-family:"Helvetica Neue";min-height:14px"><br></p><p class=3D"=
gmail-p1" style=3D"margin:0px;font-variant-numeric:normal;font-variant-east=
-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-fa=
mily:"Helvetica Neue";min-height:14px"><br></p><p class=3D"gmail-=
p1" style=3D"margin:0px;font-variant-numeric:normal;font-variant-east-asian=
:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:&=
quot;Helvetica Neue";min-height:14px">PG_stat_activity O/P</p><p class=
=3D"gmail-p1" style=3D"margin:0px;font:12px "Helvetica Neue";min-=
height:14px"><br></p><p class=3D"gmail-p2" style=3D"margin:0px;font:12px &q=
uot;Helvetica Neue"">-[ RECORD 1 ]----+-------------------------------=
--------------------------------------------------------------</p><p class=
=3D"gmail-p2" style=3D"margin:0px;font:12px "Helvetica Neue"">dat=
id<span class=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 </span>| 24823</p><p class=3D"gmail-p2" style=3D"margin:0px;f=
ont:12px "Helvetica Neue"">datname<span class=3D"gmail-Apple-conv=
erted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>| vmware</p><p class=
=3D"gmail-p2" style=3D"margin:0px;font:12px "Helvetica Neue"">pid=
<span class=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 </span>| 6672</p><p class=3D"gmail-p2" style=3D"margin:0p=
x;font:12px "Helvetica Neue"">usesysid <span class=3D"gmail-Apple=
-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>| 10</p><p class=3D"gm=
ail-p2" style=3D"margin:0px;font:12px "Helvetica Neue"">usename<s=
pan class=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 </span>| postgres</p><p class=3D"gmail-p2" style=3D"margin:0px;font:12p=
x "Helvetica Neue"">application_name | psql</p><p class=3D"gmail-=
p2" style=3D"margin:0px;font:12px "Helvetica Neue"">client_addr<s=
pan class=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 </span>|<spa=
n class=3D"gmail-Apple-converted-space">=C2=A0</span></p><p class=3D"gmail-=
p2" style=3D"margin:0px;font:12px "Helvetica Neue"">client_hostna=
me<span class=3D"gmail-Apple-converted-space">=C2=A0 </span>|<span class=3D=
"gmail-Apple-converted-space">=C2=A0</span></p><p class=3D"gmail-p2" style=
=3D"margin:0px;font:12px "Helvetica Neue"">client_port<span class=
=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 </span>| -1</p><p cla=
ss=3D"gmail-p2" style=3D"margin:0px;font:12px "Helvetica Neue"">b=
ackend_start<span class=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 </spa=
n>| 2020-01-07 08:31:39.26237+00</p><p class=3D"gmail-p2" style=3D"margin:0=
px;font:12px "Helvetica Neue"">xact_start <span class=3D"gmail-Ap=
ple-converted-space">=C2=A0 =C2=A0 =C2=A0 </span>| 2020-01-07 08:36:21.0252=
66+00</p><p class=3D"gmail-p2" style=3D"margin:0px;font:12px "Helvetic=
a Neue"">query_start<span class=3D"gmail-Apple-converted-space">=C2=A0=
=C2=A0 =C2=A0 </span>| 2020-01-07 08:36:21.025266+00</p><p class=3D"gmail-=
p2" style=3D"margin:0px;font:12px "Helvetica Neue"">state_change =
<span class=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 </span>| 2020-01-=
07 08:36:21.025273+00</p><p class=3D"gmail-p2" style=3D"margin:0px;font:12p=
x "Helvetica Neue"">wait_event_type<span class=3D"gmail-Apple-con=
verted-space">=C2=A0 </span>| Lock</p><p class=3D"gmail-p2" style=3D"margin=
:0px;font:12px "Helvetica Neue"">wait_event <span class=3D"gmail-=
Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 </span>| relation</p><p class=
=3D"gmail-p2" style=3D"margin:0px;font:12px "Helvetica Neue"">sta=
te<span class=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 </span>| active</p><p class=3D"gmail-p2" style=3D"margin:0px;=
font:12px "Helvetica Neue"">backend_xid<span class=3D"gmail-Apple=
-converted-space">=C2=A0 =C2=A0 =C2=A0 </span>| 388218816</p><p class=3D"gm=
ail-p2" style=3D"margin:0px;font:12px "Helvetica Neue"">backend_x=
min <span class=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 </span>| 3881=
75669</p><p class=3D"gmail-p2" style=3D"margin:0px;font:12px "Helvetic=
a Neue"">query<span class=3D"gmail-Apple-converted-space">=C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </span>| alter table csp_details.gcp_comput=
e_pricing add one_yr_commitment_price_hourly_rate real;</p><p class=3D"gmai=
l-p2" style=3D"margin:0px;font:12px "Helvetica Neue"">backend_typ=
e <span class=3D"gmail-Apple-converted-space">=C2=A0 =C2=A0 </span>| client=
backend</p><p class=3D"gmail-p1" style=3D"margin:0px;font-variant-numeric:=
normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;li=
ne-height:normal;font-family:"Helvetica Neue";min-height:14px">
</p><p class=3D"gmail-p2" style=3D"margin:0px;font-variant-numeric:normal;f=
ont-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-heigh=
t:normal;font-family:"Helvetica Neue"">-[ RECORD 2 ]----+--------=
---------------------------------------------------------------------------=
------</p><p class=3D"gmail-p2" style=3D"margin:0px;font-variant-numeric:no=
rmal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line=
-height:normal;font-family:"Helvetica Neue""><br></p><p class=3D"=
gmail-p2" style=3D"margin:0px;font-variant-numeric:normal;font-variant-east=
-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-fa=
mily:"Helvetica Neue"">On this table normal vacuum is working but=
when I tried for VACUUM FULL it was not working, I have tried to take pg_d=
ump in case there's any corruption, pg_dump is working fine.</p><p clas=
s=3D"gmail-p2" style=3D"margin:0px;font-variant-numeric:normal;font-variant=
-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;fo=
nt-family:"Helvetica Neue""><br></p><p class=3D"gmail-p2" style=
=3D"margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;f=
ont-stretch:normal;font-size:12px;line-height:normal;font-family:"Helv=
etica Neue"">Thanks=C2=A0</p></div></div>
--000000000000487cc5059b896c9f--