[
{
"Plan": {
"Node Type": "Limit",
"Parallel Aware": false,
"Startup Cost": 324392.08,
"Total Cost": 324444.08,
"Plan Rows": 200,
"Plan Width": 1131,
"Actual Startup Time": 7303.636,
"Actual Total Time": 7304.041,
"Actual Rows": 200,
"Actual Loops": 1,
"Output": [
"(concat(contragent_corporation.short_name, contragent_person.fname))",
"(concat(contragent_corporation.full_name, contragent_person.entrepreneur_full_name))",
"contragent_supplier.id",
"contragent_supplier.version",
"contragent_supplier.state",
"contragent_supplier.begin",
"contragent_supplier.\"end\"",
"contragent_supplier.created",
"contragent_supplier.modified",
"contragent_supplier.external_id",
"contragent_supplier.ent_id",
"contragent_supplier.direct_id",
"contragent_supplier.name",
"contragent_supplier.group_id",
"contragent_supplier.supplier_type",
"contragent_supplier.person_id",
"contragent_supplier.corporation_id",
"contragent_supplier.uuid",
"contragent_supplier.country_id",
"contragent_person.id",
"contragent_person.fname",
"contragent_person.iname",
"contragent_person.oname",
"contragent_person.g_fname",
"contragent_person.g_iname",
"contragent_person.g_oname",
"contragent_person.d_fname",
"contragent_person.d_iname",
"contragent_person.d_oname",
"contragent_person.inn",
"contragent_person.snils",
"contragent_person.phone",
"contragent_person.email",
"contragent_person.person_type",
"contragent_person.dul_type_id",
"contragent_person.dul_seria",
"contragent_person.dul_number",
"contragent_person.dul_issue_date",
"contragent_person.dul_issue_by",
"contragent_person.address_id",
"contragent_person.is_entrepreneur",
"contragent_person.entrepreneur_okved",
"contragent_person.entrepreneur_ogrn",
"contragent_person.entrepreneur_okpo",
"contragent_person.entrepreneur_okato",
"contragent_person.entrepreneur_oktmo",
"contragent_person.entrepreneur_phone",
"contragent_person.entrepreneur_full_name",
"contragent_person.entrepreneur_ur_address_id",
"contragent_person.entrepreneur_fact_address_id",
"contragent_person.entrepreneur_mail_address_id",
"contragent_address.id",
"contragent_address.address_type",
"contragent_address.geo",
"contragent_address.street",
"contragent_address.house",
"contragent_address.building",
"contragent_address.structure",
"contragent_address.flat",
"contragent_address.address",
"contragent_address.office",
"contragent_address.kladr_geo",
"contragent_address.kladr_street",
"contragent_address.kladr_house",
"contragent_address.kladr_building",
"contragent_address.kladr_flat",
"contragent_address.kladr_address",
"contragent_address.kladr_office",
"contragent_corporation.id",
"contragent_corporation.short_name",
"contragent_corporation.full_name",
"contragent_corporation.inn",
"contragent_corporation.kpp",
"contragent_corporation.filial",
"contragent_corporation.phone",
"contragent_corporation.email",
"contragent_corporation.ent_type",
"contragent_corporation.okved",
"contragent_corporation.ogrn",
"contragent_corporation.okpo",
"contragent_corporation.okato",
"contragent_corporation.oktmo",
"contragent_corporation.ur_address_id",
"contragent_corporation.fact_address_id",
"contragent_corporation.mail_address_id",
"contragent_corporation.budget_item",
"t5.id",
"t5.address_type",
"t5.geo",
"t5.street",
"t5.house",
"t5.building",
"t5.structure",
"t5.flat",
"t5.address",
"t5.office",
"t5.kladr_geo",
"t5.kladr_street",
"t5.kladr_house",
"t5.kladr_building",
"t5.kladr_flat",
"t5.kladr_address",
"t5.kladr_office"
],
"Shared Hit Blocks": 95852,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 9342,
"Temp Written Blocks": 17394,
"Plans": [
{
"Node Type": "Unique",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Startup Cost": 324392.08,
"Total Cost": 393857.32,
"Plan Rows": 267174,
"Plan Width": 1131,
"Actual Startup Time": 7303.634,
"Actual Total Time": 7304.009,
"Actual Rows": 200,
"Actual Loops": 1,
"Output": [
"(concat(contragent_corporation.short_name, contragent_person.fname))",
"(concat(contragent_corporation.full_name, contragent_person.entrepreneur_full_name))",
"contragent_supplier.id",
"contragent_supplier.version",
"contragent_supplier.state",
"contragent_supplier.begin",
"contragent_supplier.\"end\"",
"contragent_supplier.created",
"contragent_supplier.modified",
"contragent_supplier.external_id",
"contragent_supplier.ent_id",
"contragent_supplier.direct_id",
"contragent_supplier.name",
"contragent_supplier.group_id",
"contragent_supplier.supplier_type",
"contragent_supplier.person_id",
"contragent_supplier.corporation_id",
"contragent_supplier.uuid",
"contragent_supplier.country_id",
"contragent_person.id",
"contragent_person.fname",
"contragent_person.iname",
"contragent_person.oname",
"contragent_person.g_fname",
"contragent_person.g_iname",
"contragent_person.g_oname",
"contragent_person.d_fname",
"contragent_person.d_iname",
"contragent_person.d_oname",
"contragent_person.inn",
"contragent_person.snils",
"contragent_person.phone",
"contragent_person.email",
"contragent_person.person_type",
"contragent_person.dul_type_id",
"contragent_person.dul_seria",
"contragent_person.dul_number",
"contragent_person.dul_issue_date",
"contragent_person.dul_issue_by",
"contragent_person.address_id",
"contragent_person.is_entrepreneur",
"contragent_person.entrepreneur_okved",
"contragent_person.entrepreneur_ogrn",
"contragent_person.entrepreneur_okpo",
"contragent_person.entrepreneur_okato",
"contragent_person.entrepreneur_oktmo",
"contragent_person.entrepreneur_phone",
"contragent_person.entrepreneur_full_name",
"contragent_person.entrepreneur_ur_address_id",
"contragent_person.entrepreneur_fact_address_id",
"contragent_person.entrepreneur_mail_address_id",
"contragent_address.id",
"contragent_address.address_type",
"contragent_address.geo",
"contragent_address.street",
"contragent_address.house",
"contragent_address.building",
"contragent_address.structure",
"contragent_address.flat",
"contragent_address.address",
"contragent_address.office",
"contragent_address.kladr_geo",
"contragent_address.kladr_street",
"contragent_address.kladr_house",
"contragent_address.kladr_building",
"contragent_address.kladr_flat",
"contragent_address.kladr_address",
"contragent_address.kladr_office",
"contragent_corporation.id",
"contragent_corporation.short_name",
"contragent_corporation.full_name",
"contragent_corporation.inn",
"contragent_corporation.kpp",
"contragent_corporation.filial",
"contragent_corporation.phone",
"contragent_corporation.email",
"contragent_corporation.ent_type",
"contragent_corporation.okved",
"contragent_corporation.ogrn",
"contragent_corporation.okpo",
"contragent_corporation.okato",
"contragent_corporation.oktmo",
"contragent_corporation.ur_address_id",
"contragent_corporation.fact_address_id",
"contragent_corporation.mail_address_id",
"contragent_corporation.budget_item",
"t5.id",
"t5.address_type",
"t5.geo",
"t5.street",
"t5.house",
"t5.building",
"t5.structure",
"t5.flat",
"t5.address",
"t5.office",
"t5.kladr_geo",
"t5.kladr_street",
"t5.kladr_house",
"t5.kladr_building",
"t5.kladr_flat",
"t5.kladr_address",
"t5.kladr_office"
],
"Shared Hit Blocks": 95852,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 9342,
"Temp Written Blocks": 17394,
"Plans": [
{
"Node Type": "Sort",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Startup Cost": 324392.08,
"Total Cost": 325060.02,
"Plan Rows": 267174,
"Plan Width": 1131,
"Actual Startup Time": 7303.632,
"Actual Total Time": 7303.772,
"Actual Rows": 200,
"Actual Loops": 1,
"Output": [
"(concat(contragent_corporation.short_name, contragent_person.fname))",
"(concat(contragent_corporation.full_name, contragent_person.entrepreneur_full_name))",
"contragent_supplier.id",
"contragent_supplier.version",
"contragent_supplier.state",
"contragent_supplier.begin",
"contragent_supplier.\"end\"",
"contragent_supplier.created",
"contragent_supplier.modified",
"contragent_supplier.external_id",
"contragent_supplier.ent_id",
"contragent_supplier.direct_id",
"contragent_supplier.name",
"contragent_supplier.group_id",
"contragent_supplier.supplier_type",
"contragent_supplier.person_id",
"contragent_supplier.corporation_id",
"contragent_supplier.uuid",
"contragent_supplier.country_id",
"contragent_person.id",
"contragent_person.fname",
"contragent_person.iname",
"contragent_person.oname",
"contragent_person.g_fname",
"contragent_person.g_iname",
"contragent_person.g_oname",
"contragent_person.d_fname",
"contragent_person.d_iname",
"contragent_person.d_oname",
"contragent_person.inn",
"contragent_person.snils",
"contragent_person.phone",
"contragent_person.email",
"contragent_person.person_type",
"contragent_person.dul_type_id",
"contragent_person.dul_seria",
"contragent_person.dul_number",
"contragent_person.dul_issue_date",
"contragent_person.dul_issue_by",
"contragent_person.address_id",
"contragent_person.is_entrepreneur",
"contragent_person.entrepreneur_okved",
"contragent_person.entrepreneur_ogrn",
"contragent_person.entrepreneur_okpo",
"contragent_person.entrepreneur_okato",
"contragent_person.entrepreneur_oktmo",
"contragent_person.entrepreneur_phone",
"contragent_person.entrepreneur_full_name",
"contragent_person.entrepreneur_ur_address_id",
"contragent_person.entrepreneur_fact_address_id",
"contragent_person.entrepreneur_mail_address_id",
"contragent_address.id",
"contragent_address.address_type",
"contragent_address.geo",
"contragent_address.street",
"contragent_address.house",
"contragent_address.building",
"contragent_address.structure",
"contragent_address.flat",
"contragent_address.address",
"contragent_address.office",
"contragent_address.kladr_geo",
"contragent_address.kladr_street",
"contragent_address.kladr_house",
"contragent_address.kladr_building",
"contragent_address.kladr_flat",
"contragent_address.kladr_address",
"contragent_address.kladr_office",
"contragent_corporation.id",
"contragent_corporation.short_name",
"contragent_corporation.full_name",
"contragent_corporation.inn",
"contragent_corporation.kpp",
"contragent_corporation.filial",
"contragent_corporation.phone",
"contragent_corporation.email",
"contragent_corporation.ent_type",
"contragent_corporation.okved",
"contragent_corporation.ogrn",
"contragent_corporation.okpo",
"contragent_corporation.okato",
"contragent_corporation.oktmo",
"contragent_corporation.ur_address_id",
"contragent_corporation.fact_address_id",
"contragent_corporation.mail_address_id",
"contragent_corporation.budget_item",
"t5.id",
"t5.address_type",
"t5.geo",
"t5.street",
"t5.house",
"t5.building",
"t5.structure",
"t5.flat",
"t5.address",
"t5.office",
"t5.kladr_geo",
"t5.kladr_street",
"t5.kladr_house",
"t5.kladr_building",
"t5.kladr_flat",
"t5.kladr_address",
"t5.kladr_office"
],
"Sort Key": [
"contragent_supplier.name",
"contragent_supplier.id",
"(concat(contragent_corporation.short_name, contragent_person.fname))",
"(concat(contragent_corporation.full_name, contragent_person.entrepreneur_full_name))",
"contragent_supplier.version",
"contragent_supplier.state",
"contragent_supplier.begin",
"contragent_supplier.\"end\"",
"contragent_supplier.created",
"contragent_supplier.modified",
"contragent_supplier.external_id",
"contragent_supplier.ent_id",
"contragent_supplier.direct_id",
"contragent_supplier.group_id",
"contragent_supplier.supplier_type",
"contragent_supplier.person_id",
"contragent_supplier.corporation_id",
"contragent_supplier.uuid",
"contragent_supplier.country_id",
"contragent_person.id",
"contragent_person.fname",
"contragent_person.iname",
"contragent_person.oname",
"contragent_person.g_fname",
"contragent_person.g_iname",
"contragent_person.g_oname",
"contragent_person.d_fname",
"contragent_person.d_iname",
"contragent_person.d_oname",
"contragent_person.inn",
"contragent_person.snils",
"contragent_person.phone",
"contragent_person.email",
"contragent_person.person_type",
"contragent_person.dul_type_id",
"contragent_person.dul_seria",
"contragent_person.dul_number",
"contragent_person.dul_issue_date",
"contragent_person.dul_issue_by",
"contragent_person.address_id",
"contragent_person.is_entrepreneur",
"contragent_person.entrepreneur_okved",
"contragent_person.entrepreneur_ogrn",
"contragent_person.entrepreneur_okpo",
"contragent_person.entrepreneur_okato",
"contragent_person.entrepreneur_oktmo",
"contragent_person.entrepreneur_phone",
"contragent_person.entrepreneur_full_name",
"contragent_person.entrepreneur_ur_address_id",
"contragent_person.entrepreneur_fact_address_id",
"contragent_person.entrepreneur_mail_address_id",
"contragent_address.id",
"contragent_address.address_type",
"contragent_address.geo",
"contragent_address.street",
"contragent_address.house",
"contragent_address.building",
"contragent_address.structure",
"contragent_address.flat",
"contragent_address.address",
"contragent_address.office",
"contragent_address.kladr_geo",
"contragent_address.kladr_street",
"contragent_address.kladr_house",
"contragent_address.kladr_building",
"contragent_address.kladr_flat",
"contragent_address.kladr_address",
"contragent_address.kladr_office",
"contragent_corporation.id",
"contragent_corporation.short_name",
"contragent_corporation.full_name",
"contragent_corporation.inn",
"contragent_corporation.kpp",
"contragent_corporation.filial",
"contragent_corporation.phone",
"contragent_corporation.email",
"contragent_corporation.ent_type",
"contragent_corporation.okved",
"contragent_corporation.ogrn",
"contragent_corporation.okpo",
"contragent_corporation.okato",
"contragent_corporation.oktmo",
"contragent_corporation.ur_address_id",
"contragent_corporation.fact_address_id",
"contragent_corporation.mail_address_id",
"contragent_corporation.budget_item",
"t5.id",
"t5.address_type",
"t5.geo",
"t5.street",
"t5.house",
"t5.building",
"t5.structure",
"t5.flat",
"t5.address",
"t5.office",
"t5.kladr_geo",
"t5.kladr_street",
"t5.kladr_house",
"t5.kladr_building",
"t5.kladr_flat",
"t5.kladr_address",
"t5.kladr_office"
],
"Sort Method": "external merge",
"Sort Space Used": 139136,
"Sort Space Type": "Disk",
"Shared Hit Blocks": 95852,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 9342,
"Temp Written Blocks": 17394,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Left",
"Startup Cost": 113708.12,
"Total Cost": 167894.29,
"Plan Rows": 267174,
"Plan Width": 1131,
"Actual Startup Time": 1980.801,
"Actual Total Time": 3289.618,
"Actual Rows": 267558,
"Actual Loops": 1,
"Output": [
"concat(contragent_corporation.short_name, contragent_person.fname)",
"concat(contragent_corporation.full_name, contragent_person.entrepreneur_full_name)",
"contragent_supplier.id",
"contragent_supplier.version",
"contragent_supplier.state",
"contragent_supplier.begin",
"contragent_supplier.\"end\"",
"contragent_supplier.created",
"contragent_supplier.modified",
"contragent_supplier.external_id",
"contragent_supplier.ent_id",
"contragent_supplier.direct_id",
"contragent_supplier.name",
"contragent_supplier.group_id",
"contragent_supplier.supplier_type",
"contragent_supplier.person_id",
"contragent_supplier.corporation_id",
"contragent_supplier.uuid",
"contragent_supplier.country_id",
"contragent_person.id",
"contragent_person.fname",
"contragent_person.iname",
"contragent_person.oname",
"contragent_person.g_fname",
"contragent_person.g_iname",
"contragent_person.g_oname",
"contragent_person.d_fname",
"contragent_person.d_iname",
"contragent_person.d_oname",
"contragent_person.inn",
"contragent_person.snils",
"contragent_person.phone",
"contragent_person.email",
"contragent_person.person_type",
"contragent_person.dul_type_id",
"contragent_person.dul_seria",
"contragent_person.dul_number",
"contragent_person.dul_issue_date",
"contragent_person.dul_issue_by",
"contragent_person.address_id",
"contragent_person.is_entrepreneur",
"contragent_person.entrepreneur_okved",
"contragent_person.entrepreneur_ogrn",
"contragent_person.entrepreneur_okpo",
"contragent_person.entrepreneur_okato",
"contragent_person.entrepreneur_oktmo",
"contragent_person.entrepreneur_phone",
"contragent_person.entrepreneur_full_name",
"contragent_person.entrepreneur_ur_address_id",
"contragent_person.entrepreneur_fact_address_id",
"contragent_person.entrepreneur_mail_address_id",
"contragent_address.id",
"contragent_address.address_type",
"contragent_address.geo",
"contragent_address.street",
"contragent_address.house",
"contragent_address.building",
"contragent_address.structure",
"contragent_address.flat",
"contragent_address.address",
"contragent_address.office",
"contragent_address.kladr_geo",
"contragent_address.kladr_street",
"contragent_address.kladr_house",
"contragent_address.kladr_building",
"contragent_address.kladr_flat",
"contragent_address.kladr_address",
"contragent_address.kladr_office",
"contragent_corporation.id",
"contragent_corporation.short_name",
"contragent_corporation.full_name",
"contragent_corporation.inn",
"contragent_corporation.kpp",
"contragent_corporation.filial",
"contragent_corporation.phone",
"contragent_corporation.email",
"contragent_corporation.ent_type",
"contragent_corporation.okved",
"contragent_corporation.ogrn",
"contragent_corporation.okpo",
"contragent_corporation.okato",
"contragent_corporation.oktmo",
"contragent_corporation.ur_address_id",
"contragent_corporation.fact_address_id",
"contragent_corporation.mail_address_id",
"contragent_corporation.budget_item",
"t5.id",
"t5.address_type",
"t5.geo",
"t5.street",
"t5.house",
"t5.building",
"t5.structure",
"t5.flat",
"t5.address",
"t5.office",
"t5.kladr_geo",
"t5.kladr_street",
"t5.kladr_house",
"t5.kladr_building",
"t5.kladr_flat",
"t5.kladr_address",
"t5.kladr_office"
],
"Hash Cond": "(contragent_corporation.ur_address_id = t5.id)",
"Shared Hit Blocks": 95852,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Left",
"Startup Cost": 88645.72,
"Total Cost": 139158.51,
"Plan Rows": 267174,
"Plan Width": 824,
"Actual Startup Time": 1437.748,
"Actual Total Time": 2456.402,
"Actual Rows": 267558,
"Actual Loops": 1,
"Output": [
"contragent_supplier.id",
"contragent_supplier.version",
"contragent_supplier.state",
"contragent_supplier.begin",
"contragent_supplier.\"end\"",
"contragent_supplier.created",
"contragent_supplier.modified",
"contragent_supplier.external_id",
"contragent_supplier.ent_id",
"contragent_supplier.direct_id",
"contragent_supplier.name",
"contragent_supplier.group_id",
"contragent_supplier.supplier_type",
"contragent_supplier.person_id",
"contragent_supplier.corporation_id",
"contragent_supplier.uuid",
"contragent_supplier.country_id",
"contragent_person.fname",
"contragent_person.entrepreneur_full_name",
"contragent_person.id",
"contragent_person.iname",
"contragent_person.oname",
"contragent_person.g_fname",
"contragent_person.g_iname",
"contragent_person.g_oname",
"contragent_person.d_fname",
"contragent_person.d_iname",
"contragent_person.d_oname",
"contragent_person.inn",
"contragent_person.snils",
"contragent_person.phone",
"contragent_person.email",
"contragent_person.person_type",
"contragent_person.dul_type_id",
"contragent_person.dul_seria",
"contragent_person.dul_number",
"contragent_person.dul_issue_date",
"contragent_person.dul_issue_by",
"contragent_person.address_id",
"contragent_person.is_entrepreneur",
"contragent_person.entrepreneur_okved",
"contragent_person.entrepreneur_ogrn",
"contragent_person.entrepreneur_okpo",
"contragent_person.entrepreneur_okato",
"contragent_person.entrepreneur_oktmo",
"contragent_person.entrepreneur_phone",
"contragent_person.entrepreneur_ur_address_id",
"contragent_person.entrepreneur_fact_address_id",
"contragent_person.entrepreneur_mail_address_id",
"contragent_address.id",
"contragent_address.address_type",
"contragent_address.geo",
"contragent_address.street",
"contragent_address.house",
"contragent_address.building",
"contragent_address.structure",
"contragent_address.flat",
"contragent_address.address",
"contragent_address.office",
"contragent_address.kladr_geo",
"contragent_address.kladr_street",
"contragent_address.kladr_house",
"contragent_address.kladr_building",
"contragent_address.kladr_flat",
"contragent_address.kladr_address",
"contragent_address.kladr_office",
"contragent_corporation.short_name",
"contragent_corporation.full_name",
"contragent_corporation.id",
"contragent_corporation.inn",
"contragent_corporation.kpp",
"contragent_corporation.filial",
"contragent_corporation.phone",
"contragent_corporation.email",
"contragent_corporation.ent_type",
"contragent_corporation.okved",
"contragent_corporation.ogrn",
"contragent_corporation.okpo",
"contragent_corporation.okato",
"contragent_corporation.oktmo",
"contragent_corporation.ur_address_id",
"contragent_corporation.fact_address_id",
"contragent_corporation.mail_address_id",
"contragent_corporation.budget_item"
],
"Hash Cond": "(contragent_person.entrepreneur_ur_address_id = contragent_address.id)",
"Shared Hit Blocks": 82697,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Left",
"Startup Cost": 63583.31,
"Total Cost": 112945.75,
"Plan Rows": 267174,
"Plan Width": 581,
"Actual Startup Time": 866.004,
"Actual Total Time": 1793.045,
"Actual Rows": 267558,
"Actual Loops": 1,
"Output": [
"contragent_supplier.id",
"contragent_supplier.version",
"contragent_supplier.state",
"contragent_supplier.begin",
"contragent_supplier.\"end\"",
"contragent_supplier.created",
"contragent_supplier.modified",
"contragent_supplier.external_id",
"contragent_supplier.ent_id",
"contragent_supplier.direct_id",
"contragent_supplier.name",
"contragent_supplier.group_id",
"contragent_supplier.supplier_type",
"contragent_supplier.person_id",
"contragent_supplier.corporation_id",
"contragent_supplier.uuid",
"contragent_supplier.country_id",
"contragent_person.fname",
"contragent_person.entrepreneur_full_name",
"contragent_person.id",
"contragent_person.iname",
"contragent_person.oname",
"contragent_person.g_fname",
"contragent_person.g_iname",
"contragent_person.g_oname",
"contragent_person.d_fname",
"contragent_person.d_iname",
"contragent_person.d_oname",
"contragent_person.inn",
"contragent_person.snils",
"contragent_person.phone",
"contragent_person.email",
"contragent_person.person_type",
"contragent_person.dul_type_id",
"contragent_person.dul_seria",
"contragent_person.dul_number",
"contragent_person.dul_issue_date",
"contragent_person.dul_issue_by",
"contragent_person.address_id",
"contragent_person.is_entrepreneur",
"contragent_person.entrepreneur_okved",
"contragent_person.entrepreneur_ogrn",
"contragent_person.entrepreneur_okpo",
"contragent_person.entrepreneur_okato",
"contragent_person.entrepreneur_oktmo",
"contragent_person.entrepreneur_phone",
"contragent_person.entrepreneur_ur_address_id",
"contragent_person.entrepreneur_fact_address_id",
"contragent_person.entrepreneur_mail_address_id",
"contragent_corporation.short_name",
"contragent_corporation.full_name",
"contragent_corporation.id",
"contragent_corporation.inn",
"contragent_corporation.kpp",
"contragent_corporation.filial",
"contragent_corporation.phone",
"contragent_corporation.email",
"contragent_corporation.ent_type",
"contragent_corporation.okved",
"contragent_corporation.ogrn",
"contragent_corporation.okpo",
"contragent_corporation.okato",
"contragent_corporation.oktmo",
"contragent_corporation.ur_address_id",
"contragent_corporation.fact_address_id",
"contragent_corporation.mail_address_id",
"contragent_corporation.budget_item"
],
"Hash Cond": "(contragent_supplier.person_id = contragent_person.id)",
"Shared Hit Blocks": 69542,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Right",
"Startup Cost": 46230.42,
"Total Cost": 94248.43,
"Plan Rows": 267174,
"Plan Width": 402,
"Actual Startup Time": 399.103,
"Actual Total Time": 1182.067,
"Actual Rows": 267558,
"Actual Loops": 1,
"Output": [
"contragent_supplier.id",
"contragent_supplier.version",
"contragent_supplier.state",
"contragent_supplier.begin",
"contragent_supplier.\"end\"",
"contragent_supplier.created",
"contragent_supplier.modified",
"contragent_supplier.external_id",
"contragent_supplier.ent_id",
"contragent_supplier.direct_id",
"contragent_supplier.name",
"contragent_supplier.group_id",
"contragent_supplier.supplier_type",
"contragent_supplier.person_id",
"contragent_supplier.corporation_id",
"contragent_supplier.uuid",
"contragent_supplier.country_id",
"contragent_corporation.short_name",
"contragent_corporation.full_name",
"contragent_corporation.id",
"contragent_corporation.inn",
"contragent_corporation.kpp",
"contragent_corporation.filial",
"contragent_corporation.phone",
"contragent_corporation.email",
"contragent_corporation.ent_type",
"contragent_corporation.okved",
"contragent_corporation.ogrn",
"contragent_corporation.okpo",
"contragent_corporation.okato",
"contragent_corporation.oktmo",
"contragent_corporation.ur_address_id",
"contragent_corporation.fact_address_id",
"contragent_corporation.mail_address_id",
"contragent_corporation.budget_item"
],
"Hash Cond": "(contragent_corporation.id = contragent_supplier.corporation_id)",
"Shared Hit Blocks": 60921,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Relation Name": "contragent_corporation",
"Schema": "public",
"Alias": "contragent_corporation",
"Startup Cost": 0,
"Total Cost": 41410.85,
"Plan Rows": 1140785,
"Plan Width": 239,
"Actual Startup Time": 0.015,
"Actual Total Time": 192.421,
"Actual Rows": 1140723,
"Actual Loops": 1,
"Output": [
"contragent_corporation.id",
"contragent_corporation.short_name",
"contragent_corporation.full_name",
"contragent_corporation.inn",
"contragent_corporation.kpp",
"contragent_corporation.filial",
"contragent_corporation.okved",
"contragent_corporation.ogrn",
"contragent_corporation.okpo",
"contragent_corporation.phone",
"contragent_corporation.okato",
"contragent_corporation.ur_address_id",
"contragent_corporation.fact_address_id",
"contragent_corporation.mail_address_id",
"contragent_corporation.ent_type",
"contragent_corporation.oktmo",
"contragent_corporation.email",
"contragent_corporation.budget_item"
],
"Shared Hit Blocks": 30003,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Startup Cost": 42890.75,
"Total Cost": 42890.75,
"Plan Rows": 267174,
"Plan Width": 163,
"Actual Startup Time": 397.451,
"Actual Total Time": 397.451,
"Actual Rows": 267558,
"Actual Loops": 1,
"Output": [
"contragent_supplier.id",
"contragent_supplier.version",
"contragent_supplier.state",
"contragent_supplier.begin",
"contragent_supplier.\"end\"",
"contragent_supplier.created",
"contragent_supplier.modified",
"contragent_supplier.external_id",
"contragent_supplier.ent_id",
"contragent_supplier.direct_id",
"contragent_supplier.name",
"contragent_supplier.group_id",
"contragent_supplier.supplier_type",
"contragent_supplier.person_id",
"contragent_supplier.corporation_id",
"contragent_supplier.uuid",
"contragent_supplier.country_id"
],
"Hash Buckets": 524288,
"Original Hash Buckets": 524288,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 57988,
"Shared Hit Blocks": 30918,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Bitmap Heap Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Relation Name": "contragent_supplier",
"Schema": "public",
"Alias": "contragent_supplier",
"Startup Cost": 7107.83,
"Total Cost": 42890.75,
"Plan Rows": 267174,
"Plan Width": 163,
"Actual Startup Time": 40.316,
"Actual Total Time": 238.305,
"Actual Rows": 267558,
"Actual Loops": 1,
"Output": [
"contragent_supplier.id",
"contragent_supplier.version",
"contragent_supplier.state",
"contragent_supplier.begin",
"contragent_supplier.\"end\"",
"contragent_supplier.created",
"contragent_supplier.modified",
"contragent_supplier.external_id",
"contragent_supplier.ent_id",
"contragent_supplier.direct_id",
"contragent_supplier.name",
"contragent_supplier.group_id",
"contragent_supplier.supplier_type",
"contragent_supplier.person_id",
"contragent_supplier.corporation_id",
"contragent_supplier.uuid",
"contragent_supplier.country_id"
],
"Recheck Cond": "((contragent_supplier.ent_id IS NULL) AND (contragent_supplier.begin <= '2019-08-05'::date))",
"Rows Removed by Index Recheck": 0,
"Filter": "((contragent_supplier.\"end\" >= '2019-08-05'::date) OR (contragent_supplier.\"end\" IS NULL))",
"Rows Removed by Filter": 0,
"Exact Heap Blocks": 29597,
"Lossy Heap Blocks": 0,
"Shared Hit Blocks": 30918,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Bitmap Index Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Index Name": "contragent_supplier_ent_id_6b220edd5d346340",
"Startup Cost": 0,
"Total Cost": 7041.04,
"Plan Rows": 267261,
"Plan Width": 0,
"Actual Startup Time": 30.701,
"Actual Total Time": 30.701,
"Actual Rows": 267558,
"Actual Loops": 1,
"Index Cond": "((contragent_supplier.ent_id IS NULL) AND (contragent_supplier.begin <= '2019-08-05'::date))",
"Shared Hit Blocks": 1321,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
}
]
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Startup Cost": 12501.84,
"Total Cost": 12501.84,
"Plan Rows": 388084,
"Plan Width": 179,
"Actual Startup Time": 464.611,
"Actual Total Time": 464.611,
"Actual Rows": 388102,
"Actual Loops": 1,
"Output": [
"contragent_person.fname",
"contragent_person.entrepreneur_full_name",
"contragent_person.id",
"contragent_person.iname",
"contragent_person.oname",
"contragent_person.g_fname",
"contragent_person.g_iname",
"contragent_person.g_oname",
"contragent_person.d_fname",
"contragent_person.d_iname",
"contragent_person.d_oname",
"contragent_person.inn",
"contragent_person.snils",
"contragent_person.phone",
"contragent_person.email",
"contragent_person.person_type",
"contragent_person.dul_type_id",
"contragent_person.dul_seria",
"contragent_person.dul_number",
"contragent_person.dul_issue_date",
"contragent_person.dul_issue_by",
"contragent_person.address_id",
"contragent_person.is_entrepreneur",
"contragent_person.entrepreneur_okved",
"contragent_person.entrepreneur_ogrn",
"contragent_person.entrepreneur_okpo",
"contragent_person.entrepreneur_okato",
"contragent_person.entrepreneur_oktmo",
"contragent_person.entrepreneur_phone",
"contragent_person.entrepreneur_ur_address_id",
"contragent_person.entrepreneur_fact_address_id",
"contragent_person.entrepreneur_mail_address_id"
],
"Hash Buckets": 524288,
"Original Hash Buckets": 524288,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 73104,
"Shared Hit Blocks": 8621,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Relation Name": "contragent_person",
"Schema": "public",
"Alias": "contragent_person",
"Startup Cost": 0,
"Total Cost": 12501.84,
"Plan Rows": 388084,
"Plan Width": 179,
"Actual Startup Time": 0.022,
"Actual Total Time": 184.896,
"Actual Rows": 388102,
"Actual Loops": 1,
"Output": [
"contragent_person.fname",
"contragent_person.entrepreneur_full_name",
"contragent_person.id",
"contragent_person.iname",
"contragent_person.oname",
"contragent_person.g_fname",
"contragent_person.g_iname",
"contragent_person.g_oname",
"contragent_person.d_fname",
"contragent_person.d_iname",
"contragent_person.d_oname",
"contragent_person.inn",
"contragent_person.snils",
"contragent_person.phone",
"contragent_person.email",
"contragent_person.person_type",
"contragent_person.dul_type_id",
"contragent_person.dul_seria",
"contragent_person.dul_number",
"contragent_person.dul_issue_date",
"contragent_person.dul_issue_by",
"contragent_person.address_id",
"contragent_person.is_entrepreneur",
"contragent_person.entrepreneur_okved",
"contragent_person.entrepreneur_ogrn",
"contragent_person.entrepreneur_okpo",
"contragent_person.entrepreneur_okato",
"contragent_person.entrepreneur_oktmo",
"contragent_person.entrepreneur_phone",
"contragent_person.entrepreneur_ur_address_id",
"contragent_person.entrepreneur_fact_address_id",
"contragent_person.entrepreneur_mail_address_id"
],
"Shared Hit Blocks": 8621,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Startup Cost": 18447.18,
"Total Cost": 18447.18,
"Plan Rows": 529218,
"Plan Width": 243,
"Actual Startup Time": 567.869,
"Actual Total Time": 567.87,
"Actual Rows": 529224,
"Actual Loops": 1,
"Output": [
"contragent_address.id",
"contragent_address.address_type",
"contragent_address.geo",
"contragent_address.street",
"contragent_address.house",
"contragent_address.building",
"contragent_address.structure",
"contragent_address.flat",
"contragent_address.address",
"contragent_address.office",
"contragent_address.kladr_geo",
"contragent_address.kladr_street",
"contragent_address.kladr_house",
"contragent_address.kladr_building",
"contragent_address.kladr_flat",
"contragent_address.kladr_address",
"contragent_address.kladr_office"
],
"Hash Buckets": 1048576,
"Original Hash Buckets": 1048576,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 112302,
"Shared Hit Blocks": 13155,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Relation Name": "contragent_address",
"Schema": "public",
"Alias": "contragent_address",
"Startup Cost": 0,
"Total Cost": 18447.18,
"Plan Rows": 529218,
"Plan Width": 243,
"Actual Startup Time": 0.017,
"Actual Total Time": 209.45,
"Actual Rows": 529224,
"Actual Loops": 1,
"Output": [
"contragent_address.id",
"contragent_address.address_type",
"contragent_address.geo",
"contragent_address.street",
"contragent_address.house",
"contragent_address.building",
"contragent_address.structure",
"contragent_address.flat",
"contragent_address.address",
"contragent_address.office",
"contragent_address.kladr_geo",
"contragent_address.kladr_street",
"contragent_address.kladr_house",
"contragent_address.kladr_building",
"contragent_address.kladr_flat",
"contragent_address.kladr_address",
"contragent_address.kladr_office"
],
"Shared Hit Blocks": 13155,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Startup Cost": 18447.18,
"Total Cost": 18447.18,
"Plan Rows": 529218,
"Plan Width": 243,
"Actual Startup Time": 539.896,
"Actual Total Time": 539.896,
"Actual Rows": 529224,
"Actual Loops": 1,
"Output": [
"t5.id",
"t5.address_type",
"t5.geo",
"t5.street",
"t5.house",
"t5.building",
"t5.structure",
"t5.flat",
"t5.address",
"t5.office",
"t5.kladr_geo",
"t5.kladr_street",
"t5.kladr_house",
"t5.kladr_building",
"t5.kladr_flat",
"t5.kladr_address",
"t5.kladr_office"
],
"Hash Buckets": 1048576,
"Original Hash Buckets": 1048576,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 112302,
"Shared Hit Blocks": 13155,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Relation Name": "contragent_address",
"Schema": "public",
"Alias": "t5",
"Startup Cost": 0,
"Total Cost": 18447.18,
"Plan Rows": 529218,
"Plan Width": 243,
"Actual Startup Time": 0.03,
"Actual Total Time": 196.596,
"Actual Rows": 529224,
"Actual Loops": 1,
"Output": [
"t5.id",
"t5.address_type",
"t5.geo",
"t5.street",
"t5.house",
"t5.building",
"t5.structure",
"t5.flat",
"t5.address",
"t5.office",
"t5.kladr_geo",
"t5.kladr_street",
"t5.kladr_house",
"t5.kladr_building",
"t5.kladr_flat",
"t5.kladr_address",
"t5.kladr_office"
],
"Shared Hit Blocks": 13155,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
}
]
}
]
}
]
},
"Planning Time": 10.388,
"Triggers": [],
"Execution Time": 7354.522
}
]