1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570
|
WITH
jennifer_0 AS (select
sample_0.cfgowner as c0,
sample_0.cfgowner as c1,
sample_0.cfgname as c2
from
pg_catalog.pg_ts_config as sample_0 tablesample bernoulli (5.6)
where false
limit 88),
jennifer_1 AS (select
subq_0.c2 as c0,
subq_0.c4 as c1,
case when (cast(null as inet) << (select pg_catalog.min(client_addr) from pg_catalog.pg_stat_activity)
)
or (cast(null as macaddr) >= cast(null as macaddr)) then subq_0.c2 else subq_0.c2 end
as c2,
subq_0.c0 as c3,
subq_0.c4 as c4,
subq_0.c2 as c5,
subq_0.c2 as c6
from
(select
ref_0.adrelid as c0,
ref_0.adrelid as c1,
ref_0.adnum as c2,
ref_0.adrelid as c3,
ref_0.adnum as c4
from
pg_catalog.pg_attrdef as ref_0
where (cast(null as bpchar) ~<=~ cast(null as bpchar))
or (EXISTS (
select
ref_0.adbin as c0,
ref_0.adbin as c1,
(select pg_catalog.stddev(adnum) from pg_catalog.pg_attrdef)
as c2,
ref_0.adnum as c3,
sample_1.description as c4,
ref_0.adrelid as c5,
ref_0.adrelid as c6,
sample_1.classoid as c7,
ref_0.adbin as c8,
ref_0.adrelid as c9,
(select roname from pg_catalog.pg_replication_origin limit 1 offset 73)
as c10,
sample_1.description as c11,
ref_0.adbin as c12
from
pg_catalog.pg_shdescription as sample_1 tablesample system (2)
where cast(null as int8) = 41
limit 159))) as subq_0
where EXISTS (
select
38 as c0
from
pg_catalog.pg_description as sample_2 tablesample bernoulli (4.9) ,
lateral (select
ref_1.umserver as c0,
subq_1.c0 as c1,
sample_2.objoid as c2,
sample_2.objsubid as c3,
subq_1.c0 as c4
from
pg_catalog.pg_user_mapping as ref_1,
lateral (select
ref_1.umserver as c0,
sample_2.objoid as c1,
sample_3.maptokentype as c2,
(select tablespaces_total from pg_catalog.pg_stat_progress_basebackup limit 1 offset 93)
as c3,
(select pg_catalog.stddev(stxstattarget) from pg_catalog.pg_statistic_ext)
as c4
from
pg_catalog.pg_ts_config_map as sample_3 tablesample system (1)
where subq_0.c2 < subq_0.c4
limit 51) as subq_1
where (select client_addr from pg_catalog.pg_stat_replication limit 1 offset 5)
< (select client_addr from pg_catalog.pg_stat_activity limit 1 offset 3)
limit 101) as subq_2
where false
limit 37)),
jennifer_2 AS (select
(select subsynccommit from pg_catalog.pg_subscription limit 1 offset 6)
as c0,
ref_2.roname as c1,
sample_4.srvtype as c2,
(select column_name from information_schema.column_domain_usage limit 1 offset 5)
as c3,
ref_2.roname as c4,
subq_4.c1 as c5,
subq_4.c0 as c6,
pg_catalog.variance(
cast(pg_catalog.hashfloat8(
cast(cast(null as float8) as float8)) as int4)) over (partition by ref_6.option_name,ref_6.option_name order by ref_6.foreign_server_catalog) as c7,
subq_4.c1 as c8
from
pg_catalog.pg_foreign_server as sample_4 tablesample system (1.7)
right join pg_catalog.pg_replication_origin as ref_2
on (EXISTS (
select
ref_2.roname as c0,
ref_2.roident as c1,
(select pg_catalog.stddev_pop(staattnum) from pg_catalog.pg_statistic)
as c2,
ref_3.udt_schema as c3
from
information_schema.attributes as ref_3
where (false)
and (false)))
inner join (select
subq_3.c0 as c0,
ref_4.inhrelid as c1,
subq_3.c0 as c2
from
pg_catalog.pg_inherits as ref_4,
lateral (select
ref_5.calls as c0,
ref_4.inhrelid as c1
from
pg_catalog.pg_stat_user_functions as ref_5
where cast(null as box) @> cast(null as point)
limit 125) as subq_3
where (cast(null as jsonb) <> cast(null as jsonb))
and (ref_4.inhparent is NULL)
limit 144) as subq_4
on ((select last_vacuum from pg_catalog.pg_stat_user_tables limit 1 offset 1)
= cast(null as "timestamp"))
left join information_schema.user_mapping_options as ref_6
on (pg_catalog.int4(
cast(subq_4.c2 as int8)) = (select objsubid from pg_catalog.pg_description limit 1 offset 1)
)
where (true)
or (EXISTS (
select
sample_4.srvversion as c0,
ref_2.roname as c1
from
pg_catalog.pg_stat_replication_slots as ref_7
where ((cast(null as box) && cast(null as box))
or (sample_4.srvname !~ sample_4.srvtype))
and (false)
limit 123))),
jennifer_3 AS (select
ref_10.subowner as c0,
ref_9.cfgnamespace as c1,
ref_11.indexrelid as c2,
subq_5.c0 as c3
from
debug.foo as ref_8
inner join pg_catalog.pg_ts_config as ref_9
on (cast(null as timestamptz) < cast(null as date))
inner join pg_catalog.pg_subscription as ref_10
on ((cast(null as tsquery) < cast(null as tsquery))
and ((cast(null as anymultirange) <= cast(null as anymultirange))
or ((select pg_catalog.min(amprocnum) from pg_catalog.pg_amproc)
<> (select pg_catalog.sum(encoding) from pg_catalog.pg_database)
)))
inner join public.t as sample_5 tablesample bernoulli (4.1)
left join pg_catalog.pg_index as ref_11
on ((select pg_catalog.min(stats_reset) from public.pg_stat_statements_info)
<> cast(null as date))
left join (select
ref_12.confl_tablespace as c0,
ref_12.confl_snapshot as c1
from
pg_catalog.pg_stat_database_conflicts as ref_12
where (ref_12.datid is NULL)
and (ref_12.confl_deadlock is not NULL)) as subq_5
right join pg_catalog.pg_attribute as sample_6 tablesample system (3.6)
on (EXISTS (
select
subq_5.c1 as c0,
sample_6.attinhcount as c1,
subq_5.c1 as c2,
ref_13.setting as c3,
subq_6.c0 as c4,
sample_6.attislocal as c5,
subq_6.c0 as c6,
subq_5.c1 as c7,
ref_13.seqno as c8
from
pg_catalog.pg_file_settings as ref_13,
lateral (select
subq_5.c0 as c0
from
pg_catalog.pg_extension as sample_7 tablesample bernoulli (2)
where cast(null as box) >= cast(null as box)
limit 174) as subq_6
where (select last_update from debug.foo limit 1 offset 2)
<> (select last_update from debug.foo limit 1 offset 38)
))
on ((false)
or ((cast(null as "time") < cast(null as "time"))
or ((sample_6.attfdwoptions is not NULL)
and (true))))
on (ref_8.itemid is not NULL)
where EXISTS (
select
sample_6.attnum as c0,
ref_9.cfgname as c1,
sample_6.attndims as c2,
sample_6.attmissingval as c3,
37 as c4
from
pg_catalog.pg_inherits as sample_8 tablesample system (7.3)
where false)
limit 138),
jennifer_4 AS (select
ref_14.adrelid as c0,
ref_14.adnum as c1,
ref_14.adrelid as c2,
ref_14.adrelid as c3,
ref_14.adbin as c4,
ref_14.adbin as c5
from
pg_catalog.pg_attrdef as ref_14
where cast(nullif(pg_catalog.pg_backend_pid(),
13) as int4) <> (select pid from pg_catalog.pg_stat_subscription limit 1 offset 2)
),
jennifer_5 AS (select
subq_7.c8 as c0,
pg_catalog.pg_collation_for(
cast(cast(nullif(cast(nullif(cast(null as "any"),
case when (select pg_catalog.min(passwd) from pg_catalog.pg_user)
< cast(null as name) then cast(null as "any") else cast(null as "any") end
) as "any"),
cast(null as "any")) as "any") as "any")) as c1,
pg_catalog.string_agg(
cast((select data from pg_catalog.pg_largeobject limit 1 offset 5)
as bytea),
cast((select data from pg_catalog.pg_largeobject limit 1 offset 28)
as bytea)) over (partition by subq_7.c0,subq_7.c8 order by subq_7.c5) as c2
from
(select
sample_10.inhdetachpending as c0,
case when cast(null as bytea) <> (select tgargs from pg_catalog.pg_trigger limit 1 offset 3)
then sample_10.inhdetachpending else sample_10.inhdetachpending end
as c1,
sample_10.inhparent as c2,
sample_10.inhseqno as c3,
sample_9.polrelid as c4,
sample_9.polqual as c5,
sample_10.inhseqno as c6,
pg_catalog.txid_current_snapshot() as c7,
sample_9.polroles as c8
from
pg_catalog.pg_policy as sample_9 tablesample system (0.7)
right join pg_catalog.pg_inherits as sample_10 tablesample system (7.3)
on (cast(null as bpchar) < cast(null as bpchar))
where cast(null as anyrange) @> case when ((cast(null as date) = (select download_time from debug.downloaded_images limit 1 offset 5)
)
or (sample_9.polrelid is not NULL))
or (cast(null as "bit") > cast(null as "bit")) then cast(null as anyrange) else cast(null as anyrange) end
) as subq_7
where (subq_7.c5 is not NULL)
and (cast(coalesce(pg_catalog.pg_switch_wal(),
case when cast(null as circle) &< cast(null as circle) then pg_catalog.pg_switch_wal() else pg_catalog.pg_switch_wal() end
) as pg_lsn) >= pg_catalog.pg_replication_origin_session_progress(
cast(subq_7.c1 as bool)))
limit 103),
jennifer_6 AS (select
subq_10.c1 as c0,
subq_10.c1 as c1,
pg_catalog.inet_server_addr() as c2,
subq_10.c0 as c3
from
(select
ref_15.utc_offset as c0,
subq_9.c3 as c1
from
pg_catalog.pg_timezone_abbrevs as ref_15,
lateral (select
ref_16.with_check as c0,
ref_16.qual as c1,
subq_8.c0 as c2,
ref_16.tablename as c3
from
pg_catalog.pg_policies as ref_16,
lateral (select
ref_15.utc_offset as c0,
ref_16.policyname as c1
from
pg_catalog.pg_auth_members as sample_11 tablesample system (3.2)
where cast(null as record) <= cast(null as record)
limit 114) as subq_8
where cast(null as macaddr) > cast(null as macaddr)
limit 99) as subq_9
where EXISTS (
select
ref_15.abbrev as c0,
ref_17.amtype as c1,
ref_15.is_dst as c2,
ref_17.amhandler as c3,
ref_17.amtype as c4,
ref_15.utc_offset as c5,
ref_15.utc_offset as c6,
subq_9.c0 as c7,
ref_18.table_schema as c8,
(select initprivs from pg_catalog.pg_init_privs limit 1 offset 4)
as c9,
ref_17.amhandler as c10,
subq_9.c1 as c11,
ref_17.amtype as c12,
ref_17.amname as c13,
ref_18.specific_catalog as c14,
ref_15.abbrev as c15,
ref_17.amtype as c16
from
pg_catalog.pg_am as ref_17
right join information_schema.routine_table_usage as ref_18
on (cast(null as int8) < cast(null as int8))
where cast(null as bytea) <> (select data from pg_catalog.pg_largeobject limit 1 offset 1)
limit 57)
limit 134) as subq_10
where pg_catalog.hashint4(
cast((select pg_catalog.min(objsubid) from pg_catalog.pg_shdepend)
as int4)) < pg_catalog.int82mi(
cast(pg_catalog.pg_stat_get_tuples_hot_updated(
cast(case when cast(null as line) ?-| cast(null as line) then (select pg_catalog.min(datid) from pg_catalog.pg_stat_progress_create_index)
else (select pg_catalog.min(datid) from pg_catalog.pg_stat_progress_create_index)
end
as oid)) as int8),
cast(cast(null as int2) as int2))
limit 178),
jennifer_7 AS (select
(select id from public.t limit 1 offset 3)
as c0,
pg_catalog.boolle(
cast(pg_catalog.textgename(
cast((select abbrev from pg_catalog.pg_timezone_abbrevs limit 1 offset 4)
as text),
cast((select srvname from pg_catalog.pg_foreign_server limit 1 offset 1)
as name)) as bool),
cast(pg_catalog.pg_rotate_logfile_old() as bool)) as c1,
subq_11.c2 as c2,
subq_11.c5 as c3,
subq_11.c3 as c4,
pg_catalog.oidvectorin(
cast(case when cast(nullif((select proargtypes from pg_catalog.pg_proc limit 1 offset 28)
,
cast(null as oidvector)) as oidvector) < cast(coalesce(cast(null as oidvector),
cast(null as oidvector)) as oidvector) then cast(null as cstring) else cast(null as cstring) end
as cstring)) as c5,
subq_11.c3 as c6,
pg_catalog.format(
cast((select subconninfo from pg_catalog.pg_subscription limit 1 offset 1)
as text)) as c7,
subq_11.c4 as c8,
subq_11.c3 as c9,
(select table_name from information_schema.constraint_column_usage limit 1 offset 2)
as c10,
case when (true)
and (cast(null as box) ~= cast(null as box)) then subq_11.c3 else subq_11.c3 end
as c11,
subq_11.c4 as c12,
subq_11.c3 as c13
from
(select
ref_19.foreign_server_name as c0,
(select pg_catalog.min(utc_offset) from pg_catalog.pg_timezone_abbrevs)
as c1,
sample_12.umuser as c2,
ref_19.srvowner as c3,
sample_12.umoptions as c4,
sample_12.umserver as c5
from
pg_catalog.pg_user_mapping as sample_12 tablesample system (0.2)
inner join information_schema._pg_user_mappings as ref_19
on (sample_12.umuser = ref_19.umuser )
where cast(null as anymultirange) >> cast(null as anyrange)) as subq_11
where (select procost from pg_catalog.pg_proc limit 1 offset 66)
= (select pg_catalog.max(stanullfrac) from pg_catalog.pg_statistic)
limit 106),
jennifer_8 AS (select
subq_12.c5 as c0,
pg_catalog.int4multirange() as c1
from
(select
sample_13.prrelid as c0,
sample_13.prpubid as c1,
sample_13.prpubid as c2,
sample_13.prpubid as c3,
sample_13.prpubid as c4,
sample_13.prrelid as c5,
sample_13.prpubid as c6,
(select foreign_server_name from information_schema.foreign_server_options limit 1 offset 4)
as c7,
sample_13.prpubid as c8
from
pg_catalog.pg_publication_rel as sample_13 tablesample system (7)
where pg_catalog.current_query() ~~* (select name from pg_catalog.pg_stat_slru limit 1 offset 5)
limit 104) as subq_12
where (subq_12.c8 is NULL)
and ((((cast(null as circle) >= cast(null as circle))
and ((true)
and (cast(null as timestamptz) = cast(null as "timestamp"))))
and (false))
or (EXISTS (
select
subq_12.c7 as c0,
(select toast_blks_hit from pg_catalog.pg_statio_all_tables limit 1 offset 6)
as c1,
subq_12.c2 as c2,
subq_12.c3 as c3,
ref_20.typalign as c4,
ref_20.typsend as c5,
55 as c6,
44 as c7,
subq_12.c0 as c8,
ref_20.typowner as c9,
ref_20.typcategory as c10,
ref_20.typelem as c11,
subq_12.c8 as c12
from
pg_catalog.pg_type as ref_20
where ((false)
and (cast(null as point) ~= cast(null as point)))
or (cast(null as uuid) >= cast(null as uuid))
limit 104)))
limit 65),
jennifer_9 AS (select
(select pg_catalog.var_pop(wal_write_time) from pg_catalog.pg_stat_wal)
as c0,
(select event_object_table from information_schema.triggered_update_columns limit 1 offset 3)
as c1,
ref_21.option_name as c2,
pg_catalog.float8abs(
cast(case when cast(null as "char") >= cast(null as "char") then (select total_time from pg_catalog.pg_stat_user_functions limit 1 offset 1)
else (select total_time from pg_catalog.pg_stat_user_functions limit 1 offset 1)
end
as float8)) as c3,
ref_21.option_name as c4,
ref_21.option_name as c5,
ref_21.option_value as c6,
ref_21.option_name as c7,
ref_21.authorization_identifier as c8,
case when ((EXISTS (
select
subq_13.c0 as c0,
sample_14.ftoptions as c1
from
pg_catalog.pg_foreign_table as sample_14 tablesample system (9.2) ,
lateral (select
sample_15.objid as c0,
sample_14.ftoptions as c1,
sample_15.dbid as c2,
sample_15.dbid as c3
from
pg_catalog.pg_shdepend as sample_15 tablesample system (6.3)
where cast(null as lseg) ?# cast(null as lseg)
limit 82) as subq_13
where ((select itemid from debug.foo limit 1 offset 28)
< (select extversion from pg_catalog.pg_extension limit 1 offset 3)
)
or (subq_13.c1 < subq_13.c1)
limit 76))
or ((ref_21.foreign_server_name is not NULL)
or (ref_21.option_name is NULL)))
or (ref_21.authorization_identifier is NULL) then ref_21.option_name else ref_21.option_name end
as c9,
(select idx_tup_fetch from pg_catalog.pg_stat_sys_tables limit 1 offset 4)
as c10
from
information_schema.user_mapping_options as ref_21
where EXISTS (
select
ref_24.umuser as c0
from
pg_catalog.pg_constraint as sample_16 tablesample bernoulli (3.4)
inner join information_schema.check_constraints as ref_22
on (true)
left join pg_catalog.pg_depend as sample_17 tablesample system (8.6)
on (cast(null as anyrange) <= cast(null as anyrange))
inner join pg_catalog.pg_matviews as ref_23
left join pg_catalog.pg_user_mapping as ref_24
on ((cast(null as money) < cast(null as money))
or (ref_23.definition ^@ (select subconninfo from pg_catalog.pg_subscription limit 1 offset 3)
))
on ((ref_23.matviewname is NULL)
and (sample_16.conffeqop is NULL))
where (false)
and (sample_17.objid is NULL)))
select
subq_17.c0 as c0,
subq_17.c0 as c1,
pg_catalog.timezone(
cast(
pg_catalog.max(
cast((select external_id from pg_catalog.pg_replication_origin_status limit 1 offset 6)
as text)) over (partition by sample_19.stxoid,subq_17.c0 order by subq_14.c6) as text),
cast(cast(coalesce(cast(null as "timestamp"),
case when cast(null as anymultirange) <@ cast(null as anyrange) then cast(null as "timestamp") else cast(null as "timestamp") end
) as "timestamp") as "timestamp")) as c2,
pg_catalog.pg_advisory_unlock_all() as c3,
subq_14.c3 as c4,
subq_17.c0 as c5,
sample_19.stxoid as c6,
sample_19.stxdexpr as c7,
case when false then
pg_catalog.string_agg(
cast(cast(null as bytea) as bytea),
cast(pg_catalog.json_send(
cast((select pg_catalog.json_agg(evtowner) from pg_catalog.pg_event_trigger)
as json)) as bytea)) over (partition by sample_19.stxdexpr,subq_14.c2 order by sample_19.stxoid) else
pg_catalog.string_agg(
cast(cast(null as bytea) as bytea),
cast(pg_catalog.json_send(
cast((select pg_catalog.json_agg(evtowner) from pg_catalog.pg_event_trigger)
as json)) as bytea)) over (partition by sample_19.stxdexpr,subq_14.c2 order by sample_19.stxoid) end
as c8,
pg_catalog.pg_replication_origin_xact_reset() as c9,
subq_17.c0 as c10
from
(select
sample_18.spcname as c0,
26 as c1,
(select foreign_server_catalog from information_schema.foreign_servers limit 1 offset 1)
as c2,
49 as c3,
sample_18.spcname as c4,
(select pg_catalog.variance(typlen) from pg_catalog.pg_type)
as c5,
sample_18.spcowner as c6,
sample_18.spcowner as c7
from
pg_catalog.pg_tablespace as sample_18 tablesample system (1.6)
where (27 <> cast(null as int8))
and (sample_18.spcowner is NULL)
limit 160) as subq_14
left join pg_catalog.pg_statistic_ext_data as sample_19 tablesample system (8.3)
on (case when cast(null as date) = cast(null as date) then cast(null as "time") else cast(null as "time") end
< cast(null as "time")),
lateral (select
subq_14.c0 as c0
from
(select distinct
(select data from pg_catalog.pg_largeobject limit 1 offset 3)
as c0
from
pg_catalog.pg_publication_rel as sample_20 tablesample bernoulli (0.7) ,
lateral (select
sample_21.opcmethod as c0,
sample_19.stxdmcv as c1,
sample_19.stxddependencies as c2
from
pg_catalog.pg_opclass as sample_21 tablesample bernoulli (5.1)
where false
limit 113) as subq_15
where subq_14.c0 < subq_14.c4
limit 119) as subq_16
where false) as subq_17
where cast(null as anyrange) > case when (select owner from pg_catalog.pg_prepared_xacts limit 1 offset 3)
~~ cast(null as text) then cast(null as anyrange) else cast(null as anyrange) end
limit 106
|