explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kmq

Settings
# exclusive inclusive rows x rows loops node
1. 0.598 283,126.713 ↓ 40.0 40 1

Sort (cost=18,707.25..18,707.26 rows=1 width=472) (actual time=283,126.475..283,126.713 rows=40 loops=1)

  • Output: __unnamed_subquery_0.alias_rownum, __unnamed_subquery_0.irai_no, __unnamed_subquery_0.status1, __unnamed_subquery_0.buhin_code, __unnamed_subquery_0.req_date, __unnamed_subquery_0.kaitokiboubi, __unnamed_subquery_0.ans_date, __unnamed_subquery_0.seq_no, __unnamed_subquery_0.status2, __unnamed_subquery_0.iraimoto_user_code, __unnamed_subquery_0.iraimoto_zigyohon_code, __unnamed_subquery_0.toricd, __unnamed_subquery_0.kokkaikbn, __unnamed_subquery_0.iraimoto_user_name, __unnamed_subquery_0.iraimoto_zigyohon_name, __unnamed_subquery_0.status, __unnamed_subquery_0.no_eda, __unnamed_subquery_0.file_type_nm, __unnamed_subquery_0.file_type, __unnamed_subquery_0.no_kansetu, __unnamed_subquery_0.buhin_name
  • Sort Key: __unnamed_subquery_0.alias_rownum
  • Sort Method: quicksort Memory: 35kB
2. 10.180 283,126.115 ↓ 40.0 40 1

Subquery Scan on __unnamed_subquery_0 (cost=18,699.20..18,707.24 rows=1 width=472) (actual time=283,035.512..283,126.115 rows=40 loops=1)

  • Output: __unnamed_subquery_0.alias_rownum, __unnamed_subquery_0.irai_no, __unnamed_subquery_0.status1, __unnamed_subquery_0.buhin_code, __unnamed_subquery_0.req_date, __unnamed_subquery_0.kaitokiboubi, __unnamed_subquery_0.ans_date, __unnamed_subquery_0.seq_no, __unnamed_subquery_0.status2, __unnamed_subquery_0.iraimoto_user_code, __unnamed_subquery_0.iraimoto_zigyohon_code, __unnamed_subquery_0.toricd, __unnamed_subquery_0.kokkaikbn, __unnamed_subquery_0.iraimoto_user_name, __unnamed_subquery_0.iraimoto_zigyohon_name, __unnamed_subquery_0.status, __unnamed_subquery_0.no_eda, __unnamed_subquery_0.file_type_nm, __unnamed_subquery_0.file_type, __unnamed_subquery_0.no_kansetu, __unnamed_subquery_0.buhin_name
  • Filter: ((__unnamed_subquery_0.alias_rownum >= 1) AND (__unnamed_subquery_0.alias_rownum <= 40))
  • Rows Removed by Filter: 1950
3. 33.060 283,115.935 ↓ 1,990.0 1,990 1

Nested Loop Left Join (cost=18,699.20..18,707.23 rows=1 width=472) (actual time=283,035.488..283,115.935 rows=1,990 loops=1)

  • Output: rownum, d105_chosadata.no_kanri, (NULL::text), d105_chosadata.cd_buhin, d105_chosadata.dt_irai, d105_chosadata.dt_kibokaito, d105_chosadata.dt_kaito, (NULL::text), (NULL::text), (NULL::text), (NULL::text), (NULL::text), (NULL::text), (DECODE( 'JP'::character varying , 'JP'::character varying , _dblink_rec021_1.user_name_jp , _dblink_rec021_1.user_name_en )), (DECODE( 'JP'::character varying , 'JP'::character varying , spd000.zigyohon_name_jp , spd000.zigyohon_name_en )), (CASE WHEN ((d105_chosadata.kb_status = ANY ('{1,2}'::numeric[])) AND (d105_chosadata.dt_tokusoku IS NOT NULL)) THEN '0'::text WHEN ((d105_chosadata.kb_status = ANY ('{1,2}'::numeric[])) AND (d105_chosadata.dt_tokusoku IS NULL)) THEN '1'::text WHEN (d105_chosadata.kb_status = ANY ('{3,9}'::numeric[])) THEN '2'::text ELSE ''::text END), d105_chosadata.no_eda, (CASE WHEN ((d105_chosadata.kb_status = '1'::numeric) OR (d105_chosadata.kb_status = '2'::numeric)) THEN CASE d105_chosadata.kb_kibofiletype WHEN '1'::numeric THEN concat('AIS ', '4.1') WHEN '2'::numeric THEN concat('MSDSplus ', '4.1') WHEN '3'::numeric THEN concat('JGP ', '4.31') WHEN '6'::numeric THEN concat('chemSHERPA ', '1.05.00') ELSE NULL::text END WHEN (d105_chosadata.nm_file1 IS NOT NULL) THEN concat('AIS ', nvl((substr((d110.cd_version)::text, '5'::numeric))::character varying, '4.1'::character varying)) WHEN (d105_chosadata.nm_file2 IS NOT NULL) THEN concat('MSDSplus ', nvl((substr((d112.cd_version)::text, '5'::numeric))::character varying, '4.1'::character varying)) WHEN (d105_chosadata.nm_file3 IS NOT NULL) THEN concat('JGP ', COALESCE(gpc100.fver, '4.31'::bpchar)) WHEN (d105_chosadata.nm_file6 IS NOT NULL) THEN concat('chemSHERPA ', nvl(d116.cd_version, '1.05.00'::character varying)) WHEN (substr(((d105_chosadata.kb_kibofiletype)::text || (d115_upload.cd_filetype)::text), '-1'::numeric, '1'::numeric) = '9'::text) THEN 'JGP 3.00'::text ELSE NULL::text END), (substr(((d105_chosadata.kb_kibofiletype)::text || (d115_upload.cd_filetype)::text), '-1'::numeric, '1'::numeric)), d105_chosadata.no_kansetu, m023_hinmokutxt.nm_hinmoku_ja
  • Inner Unique: true
4. 45.481 283,045.065 ↓ 1,990.0 1,990 1

Sort (cost=18,698.77..18,698.77 rows=1 width=444) (actual time=283,035.365..283,045.065 rows=1,990 loops=1)

  • Output: d105_chosadata.no_kanri, NULL::text, d105_chosadata.cd_buhin, d105_chosadata.dt_irai, d105_chosadata.dt_kibokaito, d105_chosadata.dt_kaito, NULL::text, NULL::text, NULL::text, NULL::text, NULL::text, NULL::text, (DECODE( 'JP'::character varying , 'JP'::character varying , _dblink_rec021_1.user_name_jp , _dblink_rec021_1.user_name_en )), (DECODE( 'JP'::character varying , 'JP'::character varying , spd000.zigyohon_name_jp , spd000.zigyohon_name_en )), (CASE WHEN ((d105_chosadata.kb_status = ANY ('{1,2}'::numeric[])) AND (d105_chosadata.dt_tokusoku IS NOT NULL)) THEN '0'::text WHEN ((d105_chosadata.kb_status = ANY ('{1,2}'::numeric[])) AND (d105_chosadata.dt_tokusoku IS NULL)) THEN '1'::text WHEN (d105_chosadata.kb_status = ANY ('{3,9}'::numeric[])) THEN '2'::text ELSE ''::text END), d105_chosadata.no_eda, (CASE WHEN ((d105_chosadata.kb_status = '1'::numeric) OR (d105_chosadata.kb_status = '2'::numeric)) THEN CASE d105_chosadata.kb_kibofiletype WHEN '1'::numeric THEN concat('AIS ', '4.1') WHEN '2'::numeric THEN concat('MSDSplus ', '4.1') WHEN '3'::numeric THEN concat('JGP ', '4.31') WHEN '6'::numeric THEN concat('chemSHERPA ', '1.05.00') ELSE NULL::text END WHEN (d105_chosadata.nm_file1 IS NOT NULL) THEN concat('AIS ', nvl((substr((d110.cd_version)::text, '5'::numeric))::character varying, '4.1'::character varying)) WHEN (d105_chosadata.nm_file2 IS NOT NULL) THEN concat('MSDSplus ', nvl((substr((d112.cd_version)::text, '5'::numeric))::character varying, '4.1'::character varying)) WHEN (d105_chosadata.nm_file3 IS NOT NULL) THEN concat('JGP ', COALESCE(gpc100.fver, '4.31'::bpchar)) WHEN (d105_chosadata.nm_file6 IS NOT NULL) THEN concat('chemSHERPA ', nvl(d116.cd_version, '1.05.00'::character varying)) WHEN (substr(((d105_chosadata.kb_kibofiletype)::text || (d115_upload.cd_filetype)::text), '-1'::numeric, '1'::numeric) = '9'::text) THEN 'JGP 3.00'::text ELSE NULL::text END), (substr(((d105_chosadata.kb_kibofiletype)::text || (d115_upload.cd_filetype)::text), '-1'::numeric, '1'::numeric)), d105_chosadata.no_kansetu
  • Sort Key: (CASE WHEN ((d105_chosadata.kb_status = ANY ('{1,2}'::numeric[])) AND (d105_chosadata.dt_tokusoku IS NOT NULL)) THEN '0'::text WHEN ((d105_chosadata.kb_status = ANY ('{1,2}'::numeric[])) AND (d105_chosadata.dt_tokusoku IS NULL)) THEN '1'::text WHEN (d105_chosadata.kb_status = ANY ('{3,9}'::numeric[])) THEN '2'::text ELSE ''::text END), d105_chosadata.dt_kibokaito, d105_chosadata.no_kanri
  • Sort Method: quicksort Memory: 558kB
5. 99.303 282,999.584 ↓ 1,990.0 1,990 1

Nested Loop Left Join (cost=18,664.75..18,698.76 rows=1 width=444) (actual time=226.794..282,999.584 rows=1,990 loops=1)

  • Output: d105_chosadata.no_kanri, NULL::text, d105_chosadata.cd_buhin, d105_chosadata.dt_irai, d105_chosadata.dt_kibokaito, d105_chosadata.dt_kaito, NULL::text, NULL::text, NULL::text, NULL::text, NULL::text, NULL::text, DECODE( 'JP'::character varying , 'JP'::character varying , _dblink_rec021_1.user_name_jp , _dblink_rec021_1.user_name_en ), DECODE( 'JP'::character varying , 'JP'::character varying , spd000.zigyohon_name_jp , spd000.zigyohon_name_en ), CASE WHEN ((d105_chosadata.kb_status = ANY ('{1,2}'::numeric[])) AND (d105_chosadata.dt_tokusoku IS NOT NULL)) THEN '0'::text WHEN ((d105_chosadata.kb_status = ANY ('{1,2}'::numeric[])) AND (d105_chosadata.dt_tokusoku IS NULL)) THEN '1'::text WHEN (d105_chosadata.kb_status = ANY ('{3,9}'::numeric[])) THEN '2'::text ELSE ''::text END, d105_chosadata.no_eda, CASE WHEN ((d105_chosadata.kb_status = '1'::numeric) OR (d105_chosadata.kb_status = '2'::numeric)) THEN CASE d105_chosadata.kb_kibofiletype WHEN '1'::numeric THEN concat('AIS ', '4.1') WHEN '2'::numeric THEN concat('MSDSplus ', '4.1') WHEN '3'::numeric THEN concat('JGP ', '4.31') WHEN '6'::numeric THEN concat('chemSHERPA ', '1.05.00') ELSE NULL::text END WHEN (d105_chosadata.nm_file1 IS NOT NULL) THEN concat('AIS ', nvl((substr((d110.cd_version)::text, '5'::numeric))::character varying, '4.1'::character varying)) WHEN (d105_chosadata.nm_file2 IS NOT NULL) THEN concat('MSDSplus ', nvl((substr((d112.cd_version)::text, '5'::numeric))::character varying, '4.1'::character varying)) WHEN (d105_chosadata.nm_file3 IS NOT NULL) THEN concat('JGP ', COALESCE(gpc100.fver, '4.31'::bpchar)) WHEN (d105_chosadata.nm_file6 IS NOT NULL) THEN concat('chemSHERPA ', nvl(d116.cd_version, '1.05.00'::character varying)) WHEN (substr(((d105_chosadata.kb_kibofiletype)::text || (d115_upload.cd_filetype)::text), '-1'::numeric, '1'::numeric) = '9'::text) THEN 'JGP 3.00'::text ELSE NULL::text END, substr(((d105_chosadata.kb_kibofiletype)::text || (d115_upload.cd_filetype)::text), '-1'::numeric, '1'::numeric), d105_chosadata.no_kansetu
  • Inner Unique: true
6. 44.742 282,858.491 ↓ 1,990.0 1,990 1

Nested Loop Left Join (cost=18,664.47..18,697.89 rows=1 width=1,344) (actual time=226.706..282,858.491 rows=1,990 loops=1)

  • Output: d105_chosadata.no_kanri, d105_chosadata.cd_buhin, d105_chosadata.dt_irai, d105_chosadata.dt_kibokaito, d105_chosadata.dt_kaito, d105_chosadata.kb_status, d105_chosadata.dt_tokusoku, d105_chosadata.no_eda, d105_chosadata.kb_kibofiletype, d105_chosadata.nm_file1, d105_chosadata.nm_file2, d105_chosadata.nm_file3, d105_chosadata.nm_file6, d105_chosadata.no_kansetu, spd000.zigyohon_name_jp, spd000.zigyohon_name_en, _dblink_rec021_1.user_name_jp, _dblink_rec021_1.user_name_en, d115_upload.cd_filetype, d110.cd_version, d112.cd_version, gpc100.fver
  • Inner Unique: true
7. 46.538 282,760.019 ↓ 1,990.0 1,990 1

Nested Loop Left Join (cost=18,664.05..18,692.28 rows=1 width=1,338) (actual time=226.644..282,760.019 rows=1,990 loops=1)

  • Output: d105_chosadata.no_kanri, d105_chosadata.cd_buhin, d105_chosadata.dt_irai, d105_chosadata.dt_kibokaito, d105_chosadata.dt_kaito, d105_chosadata.kb_status, d105_chosadata.dt_tokusoku, d105_chosadata.no_eda, d105_chosadata.kb_kibofiletype, d105_chosadata.nm_file1, d105_chosadata.nm_file2, d105_chosadata.nm_file3, d105_chosadata.nm_file6, d105_chosadata.no_kansetu, spd000.zigyohon_name_jp, spd000.zigyohon_name_en, _dblink_rec021_1.user_name_jp, _dblink_rec021_1.user_name_en, d115_upload.cd_filetype, d110.cd_version, d112.cd_version
  • Inner Unique: true
8. 47.479 282,671.691 ↓ 1,990.0 1,990 1

Nested Loop Left Join (cost=18,663.77..18,691.75 rows=1 width=1,330) (actual time=226.598..282,671.691 rows=1,990 loops=1)

  • Output: d105_chosadata.no_kanri, d105_chosadata.cd_buhin, d105_chosadata.dt_irai, d105_chosadata.dt_kibokaito, d105_chosadata.dt_kaito, d105_chosadata.kb_status, d105_chosadata.dt_tokusoku, d105_chosadata.no_eda, d105_chosadata.kb_kibofiletype, d105_chosadata.nm_file1, d105_chosadata.nm_file2, d105_chosadata.nm_file3, d105_chosadata.nm_file6, d105_chosadata.no_kansetu, spd000.zigyohon_name_jp, spd000.zigyohon_name_en, _dblink_rec021_1.user_name_jp, _dblink_rec021_1.user_name_en, d115_upload.cd_filetype, d110.cd_version
  • Inner Unique: true
9. 61.682 282,560.532 ↓ 1,990.0 1,990 1

Nested Loop Left Join (cost=18,663.35..18,687.90 rows=1 width=1,322) (actual time=226.536..282,560.532 rows=1,990 loops=1)

  • Output: d105_chosadata.no_kanri, d105_chosadata.cd_buhin, d105_chosadata.dt_irai, d105_chosadata.dt_kibokaito, d105_chosadata.dt_kaito, d105_chosadata.kb_status, d105_chosadata.dt_tokusoku, d105_chosadata.no_eda, d105_chosadata.kb_kibofiletype, d105_chosadata.nm_file1, d105_chosadata.nm_file2, d105_chosadata.nm_file3, d105_chosadata.nm_file6, d105_chosadata.no_kansetu, spd000.zigyohon_name_jp, spd000.zigyohon_name_en, _dblink_rec021_1.user_name_jp, _dblink_rec021_1.user_name_en, d115_upload.cd_filetype
10. 92,883.459 282,363.530 ↓ 1,990.0 1,990 1

Nested Loop Left Join (cost=18,662.93..18,681.15 rows=1 width=1,317) (actual time=226.148..282,363.530 rows=1,990 loops=1)

  • Output: d105_chosadata.no_kanri, d105_chosadata.cd_buhin, d105_chosadata.dt_irai, d105_chosadata.dt_kibokaito, d105_chosadata.dt_kaito, d105_chosadata.kb_status, d105_chosadata.dt_tokusoku, d105_chosadata.no_eda, d105_chosadata.kb_kibofiletype, d105_chosadata.nm_file1, d105_chosadata.nm_file2, d105_chosadata.nm_file3, d105_chosadata.nm_file6, d105_chosadata.no_kansetu, spd000.zigyohon_name_jp, spd000.zigyohon_name_en, _dblink_rec021_1.user_name_jp, _dblink_rec021_1.user_name_en
  • Join Filter: ((_dblink_rec021_1.user_id)::text = (d105_chosadata.id_irai)::text)
  • Rows Removed by Join Filter: 18541136
11. 50.930 495.741 ↓ 1,990.0 1,990 1

Nested Loop Left Join (cost=18,647.93..18,656.03 rows=1 width=293) (actual time=179.780..495.741 rows=1,990 loops=1)

  • Output: d105_chosadata.no_kanri, d105_chosadata.cd_buhin, d105_chosadata.dt_irai, d105_chosadata.dt_kibokaito, d105_chosadata.dt_kaito, d105_chosadata.kb_status, d105_chosadata.dt_tokusoku, d105_chosadata.no_eda, d105_chosadata.kb_kibofiletype, d105_chosadata.nm_file1, d105_chosadata.nm_file2, d105_chosadata.nm_file3, d105_chosadata.nm_file6, d105_chosadata.no_kansetu, d105_chosadata.id_irai, spd000.zigyohon_name_jp, spd000.zigyohon_name_en
12. 54.831 389.091 ↓ 1,990.0 1,990 1

Nested Loop (cost=18,647.79..18,655.86 rows=1 width=221) (actual time=179.726..389.091 rows=1,990 loops=1)

  • Output: d105_chosadata.no_kanri, d105_chosadata.cd_buhin, d105_chosadata.dt_irai, d105_chosadata.dt_kibokaito, d105_chosadata.dt_kaito, d105_chosadata.kb_status, d105_chosadata.dt_tokusoku, d105_chosadata.no_eda, d105_chosadata.kb_kibofiletype, d105_chosadata.nm_file1, d105_chosadata.nm_file2, d105_chosadata.nm_file3, d105_chosadata.nm_file6, d105_chosadata.no_kansetu, d105_chosadata.cd_jigyohonbu_hch, d105_chosadata.kb_jigyonaigai_hch, d105_chosadata.id_irai
  • Inner Unique: true
13. 42.979 236.750 ↓ 1,990.0 1,990 1

GroupAggregate (cost=18,647.36..18,647.38 rows=1 width=48) (actual time=179.665..236.750 rows=1,990 loops=1)

  • Output: d105_chosadata_1.no_kanri, d105_chosadata_1.no_eda, max(d105_chosadata_1.no_kansetu)
  • Group Key: d105_chosadata_1.no_kanri, d105_chosadata_1.no_eda
14. 26.168 193.771 ↓ 1,990.0 1,990 1

Sort (cost=18,647.36..18,647.36 rows=1 width=19) (actual time=179.630..193.771 rows=1,990 loops=1)

  • Output: d105_chosadata_1.no_kanri, d105_chosadata_1.no_eda, d105_chosadata_1.no_kansetu
  • Sort Key: d105_chosadata_1.no_kanri, d105_chosadata_1.no_eda
  • Sort Method: quicksort Memory: 204kB
15. 42.228 167.603 ↓ 1,990.0 1,990 1

Nested Loop (cost=9,541.51..18,647.35 rows=1 width=19) (actual time=41.268..167.603 rows=1,990 loops=1)

  • Output: d105_chosadata_1.no_kanri, d105_chosadata_1.no_eda, d105_chosadata_1.no_kansetu
16. 22.774 73.635 ↓ 1.8 1,990 1

GroupAggregate (cost=9,541.08..9,560.73 rows=1,123 width=43) (actual time=41.185..73.635 rows=1,990 loops=1)

  • Output: d105_chosadata_2.no_kanri, max(d105_chosadata_2.no_eda)
  • Group Key: d105_chosadata_2.no_kanri
17. 28.216 50.861 ↓ 1.8 1,993 1

Sort (cost=9,541.08..9,543.89 rows=1,123 width=16) (actual time=41.141..50.861 rows=1,993 loops=1)

  • Output: d105_chosadata_2.no_kanri, d105_chosadata_2.no_eda
  • Sort Key: d105_chosadata_2.no_kanri
  • Sort Method: quicksort Memory: 142kB
18. 22.645 22.645 ↓ 1.8 1,993 1

Index Scan using d105_idx_03 on reach02.d105_chosadata d105_chosadata_2 (cost=0.43..9,484.18 rows=1,123 width=16) (actual time=0.082..22.645 rows=1,993 loops=1)

  • Output: d105_chosadata_2.no_kanri, d105_chosadata_2.no_eda
  • Index Cond: ((d105_chosadata_2.kb_torinaigai = '0'::bpchar) AND ((d105_chosadata_2.cd_torihiki)::text = '0000000022'::text))
  • Filter: (d105_chosadata_2.kb_status = ANY ('{1,2,3,9}'::numeric[]))
  • Rows Removed by Filter: 3488
19. 51.740 51.740 ↑ 1.0 1 1,990

Index Scan using d105_idx_02 on reach02.d105_chosadata d105_chosadata_1 (cost=0.43..8.07 rows=1 width=19) (actual time=0.021..0.026 rows=1 loops=1,990)

  • Output: d105_chosadata_1.no_kanri, d105_chosadata_1.no_eda, d105_chosadata_1.no_kansetu, d105_chosadata_1.cd_buhin, d105_chosadata_1.kb_torinaigai, d105_chosadata_1.cd_torihiki, d105_chosadata_1.kb_torinaigai_org, d105_chosadata_1.cd_torihiki_org, d105_chosadata_1.kb_jigyonaigai, d105_chosadata_1.cd_jigyohonbu, d105_chosadata_1.kb_jigyonaigai_hch, d105_chosadata_1.cd_jigyohonbu_hch, d105_chosadata_1.fl_iraizumi, d105_chosadata_1.kb_status, d105_chosadata_1.cd_lang, d105_chosadata_1.dt_irai, d105_chosadata_1.id_irai, d105_chosadata_1.kb_jigyonaigai_kan, d105_chosadata_1.cd_jigyohonbu_kan, d105_chosadata_1.id_kansetu, d105_chosadata_1.dt_kibokaito, d105_chosadata_1.kb_kibofiletype, d105_chosadata_1.jp_biko, d105_chosadata_1.eg_biko, d105_chosadata_1.dt_tokusoku, d105_chosadata_1.id_tokusoku, d105_chosadata_1.dt_kaito, d105_chosadata_1.id_kaito, d105_chosadata_1.dt_kakunin, d105_chosadata_1.id_kakunin, d105_chosadata_1.nm_file1, d105_chosadata_1.dt_kaito1, d105_chosadata_1.id_kaito1, d105_chosadata_1.nm_file2, d105_chosadata_1.dt_kaito2, d105_chosadata_1.id_kaito2, d105_chosadata_1.nm_file3, d105_chosadata_1.dt_kaito3, d105_chosadata_1.id_kaito3, d105_chosadata_1.nm_file4, d105_chosadata_1.dt_kaito4, d105_chosadata_1.id_kaito4, d105_chosadata_1.nm_file5, d105_chosadata_1.dt_kaito5, d105_chosadata_1.id_kaito5, d105_chosadata_1.jp_bumon_ira, d105_chosadata_1.en_bumon_ira, d105_chosadata_1.no_tel_ira, d105_chosadata_1.no_fax_ira, d105_chosadata_1.nm_maker, d105_chosadata_1.cd_kataban_mak, d105_chosadata_1.fl_handinput, d105_chosadata_1.fl_saichosa, d105_chosadata_1.fl_tankamst, d105_chosadata_1.kb_hachu, d105_chosadata_1.fl_michosa, d105_chosadata_1.kb_kaitonaigai, d105_chosadata_1.vc_yobi01, d105_chosadata_1.vc_yobi02, d105_chosadata_1.vc_yobi03, d105_chosadata_1.dt_update, d105_chosadata_1.id_update, d105_chosadata_1.ym_hachu, d105_chosadata_1.no_seq, d105_chosadata_1.cd_torihiki_stc, d105_chosadata_1.grup_key, d105_chosadata_1.nm_file6, d105_chosadata_1.dt_kaito6, d105_chosadata_1.id_kaito6
  • Index Cond: (d105_chosadata_1.no_kanri = d105_chosadata_2.no_kanri)
  • Filter: ((d105_chosadata_1.kb_torinaigai = '0'::bpchar) AND ((d105_chosadata_1.cd_torihiki)::text = '0000000022'::text) AND ((max(d105_chosadata_2.no_eda)) = d105_chosadata_1.no_eda))
  • Rows Removed by Filter: 0
20. 97.510 97.510 ↑ 1.0 1 1,990

Index Scan using d105_idx_02 on reach02.d105_chosadata (cost=0.43..8.46 rows=1 width=221) (actual time=0.049..0.049 rows=1 loops=1,990)

  • Output: d105_chosadata.no_kanri, d105_chosadata.no_eda, d105_chosadata.no_kansetu, d105_chosadata.cd_buhin, d105_chosadata.kb_torinaigai, d105_chosadata.cd_torihiki, d105_chosadata.kb_torinaigai_org, d105_chosadata.cd_torihiki_org, d105_chosadata.kb_jigyonaigai, d105_chosadata.cd_jigyohonbu, d105_chosadata.kb_jigyonaigai_hch, d105_chosadata.cd_jigyohonbu_hch, d105_chosadata.fl_iraizumi, d105_chosadata.kb_status, d105_chosadata.cd_lang, d105_chosadata.dt_irai, d105_chosadata.id_irai, d105_chosadata.kb_jigyonaigai_kan, d105_chosadata.cd_jigyohonbu_kan, d105_chosadata.id_kansetu, d105_chosadata.dt_kibokaito, d105_chosadata.kb_kibofiletype, d105_chosadata.jp_biko, d105_chosadata.eg_biko, d105_chosadata.dt_tokusoku, d105_chosadata.id_tokusoku, d105_chosadata.dt_kaito, d105_chosadata.id_kaito, d105_chosadata.dt_kakunin, d105_chosadata.id_kakunin, d105_chosadata.nm_file1, d105_chosadata.dt_kaito1, d105_chosadata.id_kaito1, d105_chosadata.nm_file2, d105_chosadata.dt_kaito2, d105_chosadata.id_kaito2, d105_chosadata.nm_file3, d105_chosadata.dt_kaito3, d105_chosadata.id_kaito3, d105_chosadata.nm_file4, d105_chosadata.dt_kaito4, d105_chosadata.id_kaito4, d105_chosadata.nm_file5, d105_chosadata.dt_kaito5, d105_chosadata.id_kaito5, d105_chosadata.jp_bumon_ira, d105_chosadata.en_bumon_ira, d105_chosadata.no_tel_ira, d105_chosadata.no_fax_ira, d105_chosadata.nm_maker, d105_chosadata.cd_kataban_mak, d105_chosadata.fl_handinput, d105_chosadata.fl_saichosa, d105_chosadata.fl_tankamst, d105_chosadata.kb_hachu, d105_chosadata.fl_michosa, d105_chosadata.kb_kaitonaigai, d105_chosadata.vc_yobi01, d105_chosadata.vc_yobi02, d105_chosadata.vc_yobi03, d105_chosadata.dt_update, d105_chosadata.id_update, d105_chosadata.ym_hachu, d105_chosadata.no_seq, d105_chosadata.cd_torihiki_stc, d105_chosadata.grup_key, d105_chosadata.nm_file6, d105_chosadata.dt_kaito6, d105_chosadata.id_kaito6
  • Index Cond: ((d105_chosadata.no_kanri = d105_chosadata_1.no_kanri) AND (d105_chosadata.no_kansetu = (max(d105_chosadata_1.no_kansetu))))
  • Filter: ((d105_chosadata.kb_torinaigai = '0'::bpchar) AND ((d105_chosadata.cd_torihiki)::text = '0000000022'::text) AND (d105_chosadata_1.no_eda = d105_chosadata.no_eda))
  • Rows Removed by Filter: 0
21. 55.720 55.720 ↑ 1.0 1 1,990

Index Scan using idx1_spd000 on reach02.spd000 (cost=0.14..0.16 rows=1 width=85) (actual time=0.019..0.028 rows=1 loops=1,990)

  • Output: spd000.kousinbi, spd000.kousinjikan, spd000.zigyohon_code_f, spd000.zigyohon_name_jp, spd000.zigyohon_code, spd000.zigyohon_name_en, spd000.step_flg, spd000.step_hyozi_order
  • Index Cond: ((spd000.zigyohon_code)::text = (d105_chosadata.cd_jigyohonbu_hch)::text)
  • Filter: ((spd000.zigyohon_code_f)::bpchar = d105_chosadata.kb_jigyonaigai_hch)
22. 188,984.330 188,984.330 ↓ 931.8 9,318 1,990

Foreign Scan on _dblink_rec021_1 (cost=15.00..25.00 rows=10 width=1,070) (actual time=0.387..94.967 rows=9,318 loops=1,990)

  • Output: _dblink_rec021_1.kousinbi, _dblink_rec021_1.kousinjikan, _dblink_rec021_1.kousintan, _dblink_rec021_1.user_id, _dblink_rec021_1.user_name_jp, _dblink_rec021_1.user_name_en, _dblink_rec021_1.mail, _dblink_rec021_1.zyotyo_user_id, _dblink_rec021_1.dairi_user_id, _dblink_rec021_1.reg_user_id
  • Remote Query: SELECT NULL, NULL, NULL, user_id, user_name_jp, user_name_en, NULL, NULL, NULL, NULL FROM rec021
23. 135.320 135.320 ↑ 1.0 1 1,990

Index Only Scan using idx_d115_upload_pk on reach02.d115_upload (cost=0.42..6.73 rows=1 width=21) (actual time=0.062..0.068 rows=1 loops=1,990)

  • Output: d115_upload.no_kanri, d115_upload.no_eda, d115_upload.cd_filetype
  • Index Cond: ((d115_upload.no_kanri = d105_chosadata.no_kanri) AND (d115_upload.no_eda = d105_chosadata.no_eda))
  • Filter: (d115_upload.cd_filetype = ANY ('{1,2,3,6}'::numeric[]))
  • Rows Removed by Filter: 0
  • Heap Fetches: 2015
24. 63.680 63.680 ↑ 1.0 1 1,990

Index Scan using idx_d110_ais_h_pk on reach02.d110_ais_h d110 (cost=0.42..3.85 rows=1 width=24) (actual time=0.032..0.032 rows=1 loops=1,990)

  • Output: d110.no_kanri, d110.no_eda, d110.cd_buhin, d110.kb_torinaigai, d110.cd_torihiki, d110.kb_jigyonaigai, d110.cd_jigyohonbu, d110.cd_lang, d110.cd_version, d110.dt_hakko, d110.dt_kaitei, d110.vc_rireki, d110.id_gpsheet, d110.nm_kaisya_hak, d110.id_kaisya_hak, d110.id_kikan_hak, d110.id_kigyo_hak, d110.nm_bumon_hak, d110.nm_jyusyo_hak, d110.no_tel_hak, d110.no_fax_hak, d110.no_mail_hak, d110.nm_bumon_sak, d110.no_tel_sak, d110.no_sheetseiri, d110.vc_biko_tui, d110.nm_kaisya_sei, d110.nm_syohin, d110.cd_kataban, d110.nm_series, d110.vc_biko_hak, d110.nm_kaisya_ira, d110.id_kaisya_ira, d110.id_kikan_ira, d110.id_kigyo_ira, d110.nm_bumon_ira, d110.id_tanto_ira, d110.nm_jyusyo_ira, d110.no_tel_ira, d110.no_fax_ira, d110.no_mail_ira, d110.dt_teishutu, d110.vc_iraibiko1, d110.vc_iraibiko2, d110.vc_iraibiko3, d110.cd_buhin1, d110.cd_buhin2, d110.cd_buhin3, d110.cd_buhin4, d110.cd_buhin5, d110.cd_buhin6, d110.cd_kataban1, d110.cd_kataban2, d110.cd_kataban3, d110.cd_kataban4, d110.cd_kataban5, d110.cd_kataban6, d110.nm_hokokutanni, d110.nu_situryo, d110.nm_situryotanni, d110.fl_gadsl, d110.fl_jig, d110.fl_soseisengen, d110.vc_notes, d110.vc_yobi01, d110.vc_yobi02, d110.vc_yobi03, d110.vc_yobi04, d110.vc_yobi05, d110.vc_yobi06, d110.vc_yobi07, d110.vc_yobi08, d110.vc_yobi09, d110.vc_yobi10, d110.dt_update, d110.id_update, d110.cd_material_ver, d110.cd_substance_ver, d110.nm_kai_hak_natv, d110.cd_kataban_natv
  • Index Cond: ((d105_chosadata.no_kanri = d110.no_kanri) AND (d105_chosadata.no_eda = d110.no_eda))
25. 41.790 41.790 ↓ 0.0 0 1,990

Index Scan using idx_d112_msdsplus_h_pk on reach02.d112_msdsplus_h d112 (cost=0.28..0.53 rows=1 width=24) (actual time=0.021..0.021 rows=0 loops=1,990)

  • Output: d112.no_kanri, d112.no_eda, d112.cd_buhin, d112.kb_torinaigai, d112.cd_torihiki, d112.kb_jigyonaigai, d112.cd_jigyohonbu, d112.cd_lang, d112.no_seiri, d112.cd_version, d112.dt_hakko, d112.dt_kaitei, d112.vc_rireki, d112.id_gpsheet, d112.nm_kaisya_sei, d112.nm_kataban, d112.cd_kataban, d112.nm_syohin, d112.nm_kaisya_hak, d112.id_kikan_hak, d112.id_kigyo_hak, d112.id_kaisya_hak, d112.nm_jyusyo_hak, d112.nm_bumon_hak, d112.no_tel_hak, d112.no_fax_hak, d112.no_mail_hak, d112.nm_bumon_sak, d112.no_tel_sak, d112.vc_biko_hak, d112.fl_bushitu, d112.vc_jp01, d112.vc_jp02, d112.vc_jp03, d112.vc_eu01, d112.vc_eu02, d112.vc_eu03, d112.vc_eu04, d112.vc_eu05, d112.fl_ot01, d112.vc_ot01, d112.fl_ia01, d112.vc_ia01, d112.fl_ia02, d112.vc_ia02, d112.nm_kaisya_ira, d112.id_kaisya_ira, d112.id_kikan_ira, d112.id_kigyo_ira, d112.nm_bumon_ira, d112.id_tanto_ira, d112.nm_jyusyo_ira, d112.no_tel_ira, d112.no_fax_ira, d112.no_mail_ira, d112.dt_teishutu, d112.vc_iraibiko1, d112.vc_iraibiko2, d112.vc_iraibiko3, d112.cd_buhin1, d112.cd_buhin2, d112.cd_buhin3, d112.cd_buhin4, d112.cd_buhin5, d112.cd_buhin6, d112.cd_kataban1, d112.cd_kataban2, d112.cd_kataban3, d112.cd_kataban4, d112.cd_kataban5, d112.cd_kataban6, d112.vc_yobi01, d112.vc_yobi02, d112.vc_yobi03, d112.vc_yobi04, d112.vc_yobi05, d112.vc_yobi06, d112.vc_yobi07, d112.vc_yobi08, d112.vc_yobi09, d112.vc_yobi10, d112.dt_update, d112.id_update, d112.cd_substance_ver, d112.cd_kataban_natv, d112.nm_kai_hak_natv, d112.vc_eu06
  • Index Cond: ((d105_chosadata.no_kanri = d112.no_kanri) AND (d105_chosadata.no_eda = d112.no_eda))
26. 53.730 53.730 ↓ 0.0 0 1,990

Index Scan using idx_gpc100_kihon1_pk on reach02.gpc100_kihon1 gpc100 (cost=0.42..5.61 rows=1 width=22) (actual time=0.027..0.027 rows=0 loops=1,990)

  • Output: gpc100.no_kanri, gpc100.no_eda, gpc100.cd_buhin, gpc100.kb_torinaigai, gpc100.cd_torihiki, gpc100.kb_jigyonaigai, gpc100.cd_jigyohonbu, gpc100.gyoucd, gpc100.gengflg, gpc100.fver, gpc100.seiban, gpc100.kinyubi, gpc100.tyosittani, gpc100.kaisittani, gpc100.toolmei, gpc100.kaitobi, gpc100.kaitokeisiki, gpc100.dt_update, gpc100.id_update
  • Index Cond: ((d105_chosadata.no_kanri = gpc100.no_kanri) AND (d105_chosadata.no_eda = gpc100.no_eda))
27. 41.790 41.790 ↓ 0.0 0 1,990

Index Scan using idx_d116_chemsherpa_h_pk on reach02.d116_chemsherpa_h d116 (cost=0.28..0.78 rows=1 width=24) (actual time=0.021..0.021 rows=0 loops=1,990)

  • Output: d116.no_kanri, d116.no_eda, d116.cd_buhin, d116.kb_torinaigai, d116.cd_torihiki, d116.kb_jigyonaigai, d116.cd_jigyohonbu, d116.cd_lang, d116.nm_kaisya_hak, d116.nm_kaisya_hak_natv, d116.nm_tanto_hak, d116.nm_tanto_hak_natv, d116.vc_hak, d116.vc_hak_natv, d116.nm_syonin_hak, d116.nm_syonin_hak_natv, d116.no_mail_hak, d116.no_tel_hak, d116.cd_area_hak, d116.cd_dentatu_ira, d116.vc_iraisya_natv, d116.vc_iraisya, d116.cd_area_ira, d116.nm_kataban_ira, d116.cd_kataban_ira, d116.nm_kataban_sei, d116.cd_kataban_sei, d116.nm_maker_sei, d116.nu_situryo_sei, d116.nm_situryotanni_sei, d116.nm_series_sei, d116.nm_hokokutanni_sei, d116.vc_comment_sei, d116.dt_hakko_sei, d116.dt_kaitei_sei, d116.vc_rireki_sei, d116.cd_version, d116.vc_yobi01, d116.vc_yobi02, d116.vc_yobi03, d116.vc_yobi04, d116.vc_yobi05, d116.vc_yobi06, d116.vc_yobi07, d116.vc_yobi08, d116.vc_yobi09, d116.vc_yobi10, d116.dt_update, d116.id_update
  • Index Cond: ((d105_chosadata.no_kanri = d116.no_kanri) AND (d105_chosadata.no_eda = d116.no_eda))
28. 37.810 37.810 ↑ 1.0 1 1,990

Index Scan using idx_m023_hinmokutxt_pk on reach02.m023_hinmokutxt (cost=0.43..8.45 rows=1 width=33) (actual time=0.019..0.019 rows=1 loops=1,990)

  • Output: m023_hinmokutxt.cd_hinmoku, m023_hinmokutxt.nm_hinmoku_ja, m023_hinmokutxt.nm_hinmoku_en, m023_hinmokutxt.nm_hinmoku_cn, m023_hinmokutxt.dt_update, m023_hinmokutxt.id_update
  • Index Cond: ((d105_chosadata.cd_buhin)::text = (m023_hinmokutxt.cd_hinmoku)::text)