\d+ tablea Partitioned table "mct.tablea" Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description -------------------+-----------------------------+-----------+----------+-----------+----------+-------------+--------------+------------- mmm_id | bigint | | not null | | plain | | | clu_id | bigint | | | | plain | | | dddd_id | bigint | | | | plain | | | zzz_id | bigint | | | | plain | | | ssr_id | bigint | | | | plain | | | ssr_type | bigint | | | | plain | | | mmm_stat | integer | | | | plain | | | time | timestamp without time zone | | not null | | plain | | | protocol | integer | | | | plain | | | uuun | character varying(20) | | | | extended | | | lastmodifiedtime | timestamp without time zone | | | sysdate() | plain | | | mmm_sss_id | bigint | | | | plain | | | remote_addr | character varying(20) | | | | extended | | | Partition key: RANGE ("time") Indexes: "tablea_pkey" PRIMARY KEY, btree (mmm_id, "time") "tablea_idx1" btree (zzz_id, mmm_sss_id, mmm_stat) "tablea_idx2" btree (mmm_sss_id) Publications: "xxxx_24503" Triggers: xxxxx AFTER DELETE ON tablea FOR EACH ROW WHEN (USER !~~ 'SPLEX%'::text) EXECUTE FUNCTION trigger_fct_xxxxxx() tr_tablea_update BEFORE UPDATE ON tablea FOR EACH ROW WHEN (USER !~~ 'SPLEX%'::text) EXECUTE FUNCTION trigger_fct_tr_xxxxx tus_update() Partitions: tablea_p1970 FOR VALUES FROM ('1970-01-01 00:00:00') TO ('2023-09-07 00:00:00'), tablea_p20250319 FOR VALUES FROM ('2025-03-19 00:00:00') TO ('2025-03-20 00:00:00'), tablea_p20250320 FOR VALUES FROM ('2025-03-20 00:00:00') TO ('2025-03-21 00:00:00'), tablea_p20250321 FOR VALUES FROM ('2025-03-21 00:00:00') TO ('2025-03-22 00:00:00'), tablea_p20250322 FOR VALUES FROM ('2025-03-22 00:00:00') TO ('2025-03-23 00:00:00'), tablea_p20250323 FOR VALUES FROM ('2025-03-23 00:00:00') TO ('2025-03-24 00:00:00'), tablea_p20250324 FOR VALUES FROM ('2025-03-24 00:00:00') TO ('2025-03-25 00:00:00'), tablea_p20250325 FOR VALUES FROM ('2025-03-25 00:00:00') TO ('2025-03-26 00:00:00'), tablea_p20250326 FOR VALUES FROM ('2025-03-26 00:00:00') TO ('2025-03-27 00:00:00'), tablea_p20250327 FOR VALUES FROM ('2025-03-27 00:00:00') TO ('2025-03-28 00:00:00'), tablea_p20250328 FOR VALUES FROM ('2025-03-28 00:00:00') TO ('2025-03-29 00:00:00'), tablea_p20250329 FOR VALUES FROM ('2025-03-29 00:00:00') TO ('2025-03-30 00:00:00'), tablea_p20250330 FOR VALUES FROM ('2025-03-30 00:00:00') TO ('2025-03-31 00:00:00'), tablea_p20250331 FOR VALUES FROM ('2025-03-31 00:00:00') TO ('2025-04-01 00:00:00'), tablea_p20250401 FOR VALUES FROM ('2025-04-01 00:00:00') TO ('2025-04-02 00:00:00'), tablea_p20250402 FOR VALUES FROM ('2025-04-02 00:00:00') TO ('2025-04-03 00:00:00'), tablea_p20250403 FOR VALUES FROM ('2025-04-03 00:00:00') TO ('2025-04-04 00:00:00'), tablea_p20250404 FOR VALUES FROM ('2025-04-04 00:00:00') TO ('2025-04-05 00:00:00'), tablea_p20250405 FOR VALUES FROM ('2025-04-05 00:00:00') TO ('2025-04-06 00:00:00'), tablea_p20250406 FOR VALUES FROM ('2025-04-06 00:00:00') TO ('2025-04-07 00:00:00'), tablea_p20250407 FOR VALUES FROM ('2025-04-07 00:00:00') TO ('2025-04-08 00:00:00'), tablea_p20250408 FOR VALUES FROM ('2025-04-08 00:00:00') TO ('2025-04-09 00:00:00'), tablea_p20250409 FOR VALUES FROM ('2025-04-09 00:00:00') TO ('2025-04-10 00:00:00'), tablea_p20250410 FOR VALUES FROM ('2025-04-10 00:00:00') TO ('2025-04-11 00:00:00'), tablea_p20250411 FOR VALUES FROM ('2025-04-11 00:00:00') TO ('2025-04-12 00:00:00'), tablea_p20250412 FOR VALUES FROM ('2025-04-12 00:00:00') TO ('2025-04-13 00:00:00'), tablea_p20250413 FOR VALUES FROM ('2025-04-13 00:00:00') TO ('2025-04-14 00:00:00'), tablea_p20250414 FOR VALUES FROM ('2025-04-14 00:00:00') TO ('2025-04-15 00:00:00'), tablea_p20250415 FOR VALUES FROM ('2025-04-15 00:00:00') TO ('2025-04-16 00:00:00'), tablea_p20250416 FOR VALUES FROM ('2025-04-16 00:00:00') TO ('2025-04-17 00:00:00') \d+ tableb Table "tableb" Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Descr iption ------------------+-----------------------------+-----------+----------+-------------------------+----------+-------------+--------------+------------------- --------------------- sss_id | bigint | | not null | | plain | | | zzz_id | bigint | | not null | | plain | | | sss_ip | character varying(80) | | not null | | extended | | | sss_type | bigint | | not null | | plain | | | sss_hostname | character varying(80) | | | | extended | | | sss_field1 | character varying(256) | | | | extended | | | sss_field2 | character varying(256) | | | | extended | | | server_field3 | bigint | | | 0 | plain | | | lastmodifiedtime | timestamp without time zone | | | sysdate() | plain | | | sss_field4 | character varying(512) | | | | extended | | | sss_field5 | character varying(512) | | | | extended | | | sss_field6 | bigint | | | 0 | plain | | | key_sss | integer | | | 1 | plain | | | ssstype | character varying(32) | | | | extended | | | keyword | character varying(256) | | | | extended | | | is_from_ab | smallint | | | 0 | plain | | | rrr_id | bigint | | | 0 | plain | | | instance_type | bigint | | | 0 | plain | | | cc_id | character varying(255) | | | | extended | | | pool_sys_id | character varying(50) | | | ''::character varying | extended | | | memo | character varying(255) | | | '{}'::character varying | extended | | | vvv | smallint | | | 0 | plain | | | real_ip | character varying(100) | | | ''::character varying | extended | | | vvv_name | character varying(100) | | | | extended | | | pool_id | bigint | | | | plain | | | ttt_info | character varying(100) | | | | extended | | | label | character varying | | | '{}'::character varying | extended | | | exp_mmm | integer | | | 0 | plain | | | Indexes: "tableb_pkey" PRIMARY KEY, btree (sss_id) "idx_serverip" btree (sss_ip) "idxvserver" btree (zzz_id, sss_type) Foreign-key constraints: "tableb_zzz_fk" FOREIGN KEY (zzz_id) REFERENCES tablez(zzzz_id) Referenced by: TABLE "xxxx_setting" CONSTRAINT "xxxxxx_fk" FOREIGN KEY (sss_id) REFERENCES tableb(sss_id) TABLE "yyyyy" CONSTRAINT "yyyyyy_fk" FOREIGN KEY (ssss_id) REFERENCES tableb(sss_id) Publications: "pggmct_24503" Triggers: xxxx_update BEFORE UPDATE ON xxxxx FOR EACH ROW WHEN (USER !~~ 'SPLEX%'::text) EXECUTE FUNCTION trigger_fct_tr_xxxx() Replica Identity: FULL Access method: heap \d+ tablec Partitioned table "mct.tablec" Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description ------------------+-----------------------------+-----------+----------+-----------+----------+-------------+------- -------+------------- ccc_id | bigint | | not null | | plain | | | sss_id | bigint | | | | plain | | | cccments | character varying(1024) | | not null | | extended | | | tablec_time | timestamp without time zone | | not null | sysdate() | plain | | | tablec_field1 | integer | | not null | 0 | plain | | | lastmodifiedtime | timestamp without time zone | | | sysdate() | plain | | | Partition key: RANGE (tablec_time) Indexes: "tablec_pkey" PRIMARY KEY, btree (comment_id, tablec_time) "sss_id_idx" btree (sss_id) Triggers: tr_tablec_update BEFORE UPDATE ON tablec FOR EACH ROW WHEN (USER !~~ 'SPLEX%'::text) EXECUTE FUNCTION trigge r_fct_tr_tablec_update() Partitions: tablec_p1970 FOR VALUES FROM ('1970-01-01 00:00:00') TO ('2023-09-07 00:00:00'), tablec_p20250319 FOR VALUES FROM ('2025-03-19 00:00:00') TO ('2025-03-20 00:00:00'), tablec_p20250320 FOR VALUES FROM ('2025-03-20 00:00:00') TO ('2025-03-21 00:00:00'), tablec_p20250321 FOR VALUES FROM ('2025-03-21 00:00:00') TO ('2025-03-22 00:00:00'), tablec_p20250322 FOR VALUES FROM ('2025-03-22 00:00:00') TO ('2025-03-23 00:00:00'), tablec_p20250323 FOR VALUES FROM ('2025-03-23 00:00:00') TO ('2025-03-24 00:00:00'), tablec_p20250324 FOR VALUES FROM ('2025-03-24 00:00:00') TO ('2025-03-25 00:00:00'), tablec_p20250325 FOR VALUES FROM ('2025-03-25 00:00:00') TO ('2025-03-26 00:00:00'), tablec_p20250326 FOR VALUES FROM ('2025-03-26 00:00:00') TO ('2025-03-27 00:00:00'), tablec_p20250327 FOR VALUES FROM ('2025-03-27 00:00:00') TO ('2025-03-28 00:00:00'), tablec_p20250328 FOR VALUES FROM ('2025-03-28 00:00:00') TO ('2025-03-29 00:00:00'), tablec_p20250329 FOR VALUES FROM ('2025-03-29 00:00:00') TO ('2025-03-30 00:00:00'), tablec_p20250330 FOR VALUES FROM ('2025-03-30 00:00:00') TO ('2025-03-31 00:00:00'), tablec_p20250331 FOR VALUES FROM ('2025-03-31 00:00:00') TO ('2025-04-01 00:00:00'), tablec_p20250401 FOR VALUES FROM ('2025-04-01 00:00:00') TO ('2025-04-02 00:00:00'), tablec_p20250402 FOR VALUES FROM ('2025-04-02 00:00:00') TO ('2025-04-03 00:00:00'), tablec_p20250403 FOR VALUES FROM ('2025-04-03 00:00:00') TO ('2025-04-04 00:00:00'), tablec_p20250404 FOR VALUES FROM ('2025-04-04 00:00:00') TO ('2025-04-05 00:00:00'), tablec_p20250405 FOR VALUES FROM ('2025-04-05 00:00:00') TO ('2025-04-06 00:00:00'), tablec_p20250406 FOR VALUES FROM ('2025-04-06 00:00:00') TO ('2025-04-07 00:00:00'), tablec_p20250407 FOR VALUES FROM ('2025-04-07 00:00:00') TO ('2025-04-08 00:00:00'), tablec_p20250408 FOR VALUES FROM ('2025-04-08 00:00:00') TO ('2025-04-09 00:00:00'), tablec_p20250409 FOR VALUES FROM ('2025-04-09 00:00:00') TO ('2025-04-10 00:00:00'), tablec_p20250410 FOR VALUES FROM ('2025-04-10 00:00:00') TO ('2025-04-11 00:00:00'), tablec_p20250411 FOR VALUES FROM ('2025-04-11 00:00:00') TO ('2025-04-12 00:00:00'), tablec_p20250412 FOR VALUES FROM ('2025-04-12 00:00:00') TO ('2025-04-13 00:00:00'), tablec_p20250413 FOR VALUES FROM ('2025-04-13 00:00:00') TO ('2025-04-14 00:00:00'), tablec_p20250414 FOR VALUES FROM ('2025-04-14 00:00:00') TO ('2025-04-15 00:00:00'), tablec_p20250415 FOR VALUES FROM ('2025-04-15 00:00:00') TO ('2025-04-16 00:00:00'), tablec_p20250416 FOR VALUES FROM ('2025-04-16 00:00:00') TO ('2025-04-17 00:00:00') QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------- Sort (cost=9054.03..9107.10 rows=21225 width=980) (actual time=388717.679..388723.642 rows=11 loops=1) Sort Key: cc.ccc_id Sort Method: quicksort Memory: 45kB Buffers: shared hit=19406236 read=1583894 dirtied=9 written=4190 I/O Timings: read=36703.795 write=58.618 -> Merge Join (cost=112.75..2174.05 rows=21225 width=980) (actual time=388713.431..388719.421 rows=11 loops=1) Merge Cond: (cc.sss_id = aa.mmm_id) Buffers: shared hit=19406236 read=1583894 dirtied=9 written=4190 I/O Timings: read=36703.795 write=58.618 -> Merge Append (cost=7.99..16975829.82 rows=97820562 width=903) (actual time=7.886..383344.932 rows=96215798 loops=1) Sort Key: cc.ind2 Buffers: shared hit=19406200 read=1583893 dirtied=9 written=4190 I/O Timings: read=36703.274 write=58.618 -> Index Scan using tablec_p1970_sss_id_idx on tablec_p1970 cc_1 (cost=0.12..2.34 rows=1 width=532) (actual time=0.006..0.007 rows=0 loops=1) Buffers: shared hit=1 -> Index Scan using tablec_p20250318_sss_id_idx on tablec_p20250318 cc_2 (cost=0.29..24517.70 rows=158631 width=861) (actual time=0.2 19..407.243 rows=15455 loops=1) Buffers: shared hit=3229 read=262 I/O Timings: read=38.162 -> Index Scan using tablec_p20250319_sss_id_idx on tablec_p20250319 cc_3 (cost=0.29..24929.48 rows=157041 width=861) (actual time=0.0 08..414.683 rows=16361 loops=1) Buffers: shared hit=3498 read=222 I/O Timings: read=24.644 -> Index Scan using tablec_p20250320_sss_id_idx on tablec_p20250320 cc_4 (cost=0.29..26183.42 rows=162959 width=868) (actual time=0.3 58..386.108 rows=18463 loops=1) Buffers: shared hit=3797 read=221 I/O Timings: read=29.677 -> Index Scan using tablec_p20250321_sss_id_idx on tablec_p20250321 cc_5 (cost=0.29..25258.03 rows=158288 width=866) (actual time=0.2 47..422.228 rows=17652 loops=1) Buffers: shared hit=3649 read=258 I/O Timings: read=37.714 -> Index Scan using tablec_p20250322_sss_id_idx on tablec_p20250322 cc_6 (cost=0.42..26301.22 rows=185312 width=837) (actual time=0.0 07..88.273 rows=3582 loops=1) Buffers: shared hit=680 read=19 I/O Timings: read=2.968 -> Index Scan using tablec_p20250323_sss_id_idx on tablec_p20250323 cc_7 (cost=0.42..60137.20 rows=370927 width=918) (actual time=0.7 50..652.735 rows=19659 loops=1) Buffers: shared hit=3832 read=263 I/O Timings: read=42.237 -> Index Scan using tablec_p20250324_sss_id_idx on tablec_p20250324 cc_8 (cost=0.29..24645.04 rows=153782 width=862) (actual time=0.6 42..442.535 rows=18488 loops=1) Buffers: shared hit=3530 read=328 I/O Timings: read=41.069 -> Index Scan using tablec_p20250325_sss_id_idx on tablec_p20250325 cc_9 (cost=0.29..22930.03 rows=144129 width=854) (actual time=0.7 57..355.577 rows=15002 loops=1) Buffers: shared hit=2908 read=195 I/O Timings: read=25.421 -> Index Scan using tablec_p20250326_sss_id_idx on tablec_p20250326 cc_10 (cost=0.29..22642.78 rows=144273 width=847) (actual time=0. 542..397.982 rows=16996 loops=1) Buffers: shared hit=3342 read=307 I/O Timings: read=39.785 -> Index Scan using tablec_p20250327_sss_id_idx on tablec_p20250327 cc_11 (cost=0.29..23007.96 rows=143080 width=848) (actual time=0. 479..333.069 rows=18090 loops=1) Buffers: shared hit=3499 read=290 I/O Timings: read=27.177 -> Index Scan using tablec_p20250328_sss_id_idx on tablec_p20250328 cc_12 (cost=0.44..3027818.84 rows=21053820 width=904) (actual tim e=0.010..51767.500 rows=21045366 loops=1) Buffers: shared hit=3891912 read=625578 written=2452 I/O Timings: read=15198.004 write=31.926 -> Index Scan using tablec_p20250329_sss_id_idx on tablec_p20250329 cc_13 (cost=0.44..4542850.00 rows=31569066 width=908) (actual tim e=0.493..34196.241 rows=31570870 loops=1) Buffers: shared hit=6181410 read=624887 written=745 I/O Timings: read=2279.724 write=13.038 -> Index Scan using tablec_p20250330_sss_id_idx on tablec_p20250330 cc_14 (cost=0.44..4343188.38 rows=30268060 width=902) (actual tim e=0.009..204102.864 rows=30298328 loops=1) Buffers: shared hit=6575789 read=225742 written=236 I/O Timings: read=13574.608 write=3.893 -> Index Scan using tablec_p20250331_sss_id_idx on tablec_p20250331 cc_15 (cost=0.43..1757701.95 rows=12160953 width=902) (actual tim e=0.982..78204.583 rows=12177280 loops=1) Buffers: shared hit=2533546 read=99131 written=757 I/O Timings: read=5231.356 write=9.761 -> Index Scan using tablec_p20250401_sss_id_idx on tablec_p20250401 cc_16 (cost=0.42..134605.16 rows=990226 width=847) (actual time=0 .008..2424.281 rows=964217 loops=1) Buffers: shared hit=191564 read=6190 dirtied=9 I/O Timings: read=110.728 -> Index Scan using tablec_p20250402_sss_id_idx on tablec_p20250402 cc_17 (cost=0.12..2.34 rows=1 width=532) (actual time=0.003..0.00 3 rows=0 loops=1) Buffers: shared hit=1 -> Index Scan using tablec_p20250403_sss_id_idx on tablec_p20250403 cc_18 (cost=0.12..2.34 rows=1 width=532) (actual time=0.002..0.00 2 rows=0 loops=1) Buffers: shared hit=1 -> Index Scan using tablec_p20250404_sss_id_idx on tablec_p20250404 cc_19 (cost=0.12..2.34 rows=1 width=532) (actual time=0.247..0.24 7 rows=0 loops=1) Buffers: shared hit=1 -> Index Scan using tablec_p20250405_sss_id_idx on tablec_p20250405 cc_20 (cost=0.12..2.34 rows=1 width=532) (actual time=0.002..0.00 2 rows=0 loops=1) Buffers: shared hit=1 -> Index Scan using tablec_p20250406_sss_id_idx on tablec_p20250406 cc_21 (cost=0.12..2.34 rows=1 width=532) (actual time=0.442..0.44 5 rows=0 loops=1) Buffers: shared hit=1 -> Index Scan using tablec_p20250407_sss_id_idx on tablec_p20250407 cc_22 (cost=0.12..2.34 rows=1 width=532) (actual time=0.002..0.00 2 rows=0 loops=1) Buffers: shared hit=1 -> Index Scan using tablec_p20250408_sss_id_idx on tablec_p20250408 cc_23 (cost=0.12..2.34 rows=1 width=532) (actual time=0.002..0.00 2 rows=0 loops=1) Buffers: shared hit=1 -> Index Scan using tablec_p20250409_sss_id_idx on tablec_p20250409 cc_24 (cost=0.12..2.34 rows=1 width=532) (actual time=0.433..0.43 3 rows=0 loops=1) Buffers: shared hit=1 -> Index Scan using tablec_p20250410_sss_id_idx on tablec_p20250410 cc_25 (cost=0.12..2.34 rows=1 width=532) (actual time=0.002..0.00 2 rows=0 loops=1) Buffers: shared hit=1 -> Index Scan using tablec_p20250411_sss_id_idx on tablec_p20250411 cc_26 (cost=0.12..2.34 rows=1 width=532) (actual time=0.002..0.00 3 rows=0 loops=1) Buffers: shared hit=1 -> Index Scan using tablec_p20250412_sss_id_idx on tablec_p20250412 cc_27 (cost=0.12..2.34 rows=1 width=532) (actual time=0.252..0.25 2 rows=0 loops=1) Buffers: shared hit=1 -> Index Scan using tablec_p20250413_sss_id_idx on tablec_p20250413 cc_28 (cost=0.12..2.34 rows=1 width=532) (actual time=0.333..0.33 3 rows=0 loops=1) Buffers: shared hit=1 -> Index Scan using tablec_p20250414_sss_id_idx on tablec_p20250414 cc_29 (cost=0.12..2.34 rows=1 width=532) (actual time=0.323..0.32 4 rows=0 loops=1) Buffers: shared hit=1 -> Index Scan using tablec_p20250415_sss_id_idx on tablec_p20250415 cc_30 (cost=0.12..2.34 rows=1 width=532) (actual time=0.315..0.67 8 rows=0 loops=1) Buffers: shared hit=1 -> Sort (cost=56.94..57.01 rows=30 width=61) (actual time=7.127..12.496 rows=1 loops=1) Sort Key: aa.mmm_id Sort Method: quicksort Memory: 25kB Buffers: shared hit=36 read=1 I/O Timings: read=0.521 -> Nested Loop (cost=0.72..56.20 rows=30 width=61) (actual time=6.216..12.488 rows=1 loops=1) Buffers: shared hit=36 read=1 I/O Timings: read=0.521 -> Append (cost=0.29..40.09 rows=30 width=28) (actual time=5.704..11.974 rows=1 loops=1) Buffers: shared hit=32 read=1 I/O Timings: read=0.521 -> Index Scan using tablea_p1970_mmm_sss_id_idx on tablea_p1970 aa_1 (cost=0.29..2.51 rows=1 width= 28) (actual time=0.921..0.922 rows=0 loops=1) Index Cond: (mmm_sss_id = $1) Buffers: shared hit=2 -> Index Scan using tablea_p20250318_mmm_sss_id_idx on tablea_p20250318 aa_2 (cost=0.28..2.50 rows= 1 width=28) (actual time=0.005..0.010 rows=0 loops=1) Index Cond: (mmm_sss_id = $1) Buffers: shared hit=2 -> Index Scan using tablea_p20250319_mmm_sss_id_idx on tablea_p20250319 aa_3 (cost=0.28..2.50 rows= 1 width=28) (actual time=0.004..0.250 rows=0 loops=1) Index Cond: (mmm_sss_id = $1) Buffers: shared hit=2 -> Index Scan using tablea_p20250320_mmm_sss_id_idx on tablea_p20250320 aa_4 (cost=0.28..2.50 rows= 1 width=28) (actual time=0.430..0.431 rows=0 loops=1) Index Cond: (mmm_sss_id = $1) Buffers: shared hit=2 -> Index Scan using tablea_p20250321_mmm_sss_id_idx on tablea_p20250321 aa_5 (cost=0.28..2.50 rows= 1 width=28) (actual time=0.004..0.006 rows=0 loops=1) Index Cond: (mmm_sss_id = $1) Buffers: shared hit=2 -> Index Scan using tablea_p20250322_mmm_sss_id_idx on tablea_p20250322 aa_6 (cost=0.28..2.50 rows= 1 width=28) (actual time=0.004..0.271 rows=0 loops=1) Index Cond: (mmm_sss_id = $1) Buffers: shared hit=2 -> Index Scan using tablea_p20250323_mmm_sss_id_idx on tablea_p20250323 aa_7 (cost=0.28..2.50 rows= 1 width=28) (actual time=0.004..0.005 rows=0 loops=1) Index Cond: (mmm_sss_id = $1) Buffers: shared hit=2 -> Index Scan using tablea_p20250324_mmm_sss_id_idx on tablea_p20250324 aa_8 (cost=0.28..2.50 rows= 1 width=28) (actual time=0.505..0.857 rows=0 loops=1) Index Cond: (mmm_sss_id = $1) Buffers: shared hit=2 -> Index Scan using tablea_p20250325_mmm_sss_id_idx on tablea_p20250325 aa_9 (cost=0.28..2.50 rows= 1 width=28) (actual time=0.430..0.431 rows=0 loops=1) Index Cond: (mmm_sss_id = $1) Buffers: shared hit=2 -> Index Scan using tablea_p20250326_mmm_sss_id_idx on tablea_p20250326 aa_10 (cost=0.28..2.50 rows =1 width=28) (actual time=0.368..0.820 rows=0 loops=1) Index Cond: (mmm_sss_id = $1) Buffers: shared hit=2 -> Index Scan using tablea_p20250327_mmm_sss_id_idx on tablea_p20250327 aa_11 (cost=0.28..2.50 rows =1 width=28) (actual time=0.662..0.664 rows=0 loops=1) Index Cond: (mmm_sss_id = $1) Buffers: shared hit=2 -> Index Scan using tablea_p20250328_mmm_sss_id_idx on tablea_p20250328 aa_12 (cost=0.28..2.50 rows =1 width=28) (actual time=0.310..0.311 rows=0 loops=1) Index Cond: (mmm_sss_id = $1) Buffers: shared hit=2 -> Index Scan using tablea_p20250329_mmm_sss_id_idx on tablea_p20250329 aa_13 (cost=0.28..2.50 rows =1 width=28) (actual time=0.424..0.712 rows=0 loops=1) Index Cond: (mmm_sss_id = $1) Buffers: shared hit=2 -> Index Scan using tablea_p20250330_mmm_sss_id_idx on tablea_p20250330 aa_14 (cost=0.28..2.49 rows =1 width=28) (actual time=0.682..0.683 rows=0 loops=1) Index Cond: (mmm_sss_id = $1) Buffers: shared hit=2 -> Index Scan using tablea_p20250331_mmm_sss_id_idx on tablea_p20250331 aa_15 (cost=0.27..2.49 rows =1 width=28) (actual time=0.943..1.262 rows=1 loops=1) Index Cond: (mmm_sss_id = $1) Buffers: shared hit=2 read=1 I/O Timings: read=0.521 -> Index Scan using tablea_p20250401_mmm_sss_id_idx on tablea_p20250401 aa_16 (cost=0.27..2.49 rows =1 width=28) (actual time=0.414..0.414 rows=0 loops=1) Index Cond: (mmm_sss_id = $1) Buffers: shared hit=2 -> Seq Scan on tablea_p20250402 aa_17 (cost=0.00..0.00 rows=1 width=28) (actual time=0.005..0.005 rows=0 loops=1) Filter: (mmm_sss_id = $1) -> Seq Scan on tablea_p20250403 aa_18 (cost=0.00..0.00 rows=1 width=28) (actual time=0.266..0.267 rows=0 loops=1) Filter: (mmm_sss_id = $1) -> Seq Scan on tablea_p20250404 aa_19 (cost=0.00..0.00 rows=1 width=28) (actual time=0.002..0.002 rows=0 loops=1) Filter: (mmm_sss_id = $1) -> Seq Scan on tablea_p20250405 aa_20 (cost=0.00..0.00 rows=1 width=28) (actual time=0.002..0.002 rows=0 loops=1) Filter: (mmm_sss_id = $1) -> Seq Scan on tablea_p20250406 aa_21 (cost=0.00..0.00 rows=1 width=28) (actual time=0.153..0.507 rows=0 loops=1) Filter: (mmm_sss_id = $1) -> Seq Scan on tablea_p20250407 aa_22 (cost=0.00..0.00 rows=1 width=28) (actual time=0.002..0.002 rows=0 loops=1) Filter: (mmm_sss_id = $1) -> Seq Scan on tablea_p20250408 aa_23 (cost=0.00..0.00 rows=1 width=28) (actual time=0.002..0.002 rows=0 loops=1) Filter: (mmm_sss_id = $1) -> Seq Scan on tablea_p20250409 aa_24 (cost=0.00..0.00 rows=1 width=28) (actual time=0.002..0.003 rows=0 loops=1) Filter: (mmm_sss_id = $1) -> Seq Scan on tablea_p20250410 aa_25 (cost=0.00..0.00 rows=1 width=28) (actual time=0.042..0.042 rows=0 loops=1) Filter: (mmm_sss_id = $1) -> Seq Scan on tablea_p20250411 aa_26 (cost=0.00..0.00 rows=1 width=28) (actual time=0.002..0.002 rows=0 loops=1) Filter: (mmm_sss_id = $1) -> Seq Scan on tablea_p20250412 aa_27 (cost=0.00..0.00 rows=1 width=28) (actual time=0.002..0.066 rows=0 loops=1) Filter: (mmm_sss_id = $1) -> Seq Scan on tablea_p20250413 aa_28 (cost=0.00..0.00 rows=1 width=28) (actual time=0.002..0.002 rows=0 loops=1) Filter: (mmm_sss_id = $1) -> Seq Scan on tablea_p20250414 aa_29 (cost=0.00..0.00 rows=1 width=28) (actual time=0.002..0.002 rows=0 loops=1) Filter: (mmm_sss_id = $1) -> Seq Scan on tablea_p20250415 aa_30 (cost=0.00..0.00 rows=1 width=28) (actual time=0.002..0.002 rows=0 loops=1) Filter: (mmm_sss_id = $1) -> Memoize (cost=0.43..2.65 rows=1 width=41) (actual time=0.509..0.510 rows=1 loops=1) Cache Key: aa.sss_id Cache Mode: logical Hits: 0 Misses: 1 Evictions: 0 Overflows: 0 Memory Usage: 1kB Buffers: shared hit=4 -> Index Scan using tableb_pkey on tableb bb (cost=0.42..2.64 rows=1 width=41) (actual time=0.504..0.504 rows=1 loops=1) Index Cond: (sss_id = aa.sss_id) Buffers: shared hit=4 Planning Time: 7.588 ms Execution Time: 388786.455 ms (186 rows)