Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [
- {
- "Plan": {
- "Node Type": "Unique",
- "Parallel Aware": false,
- "Startup Cost": 23303.96,
- "Total Cost": 23841.31,
- "Plan Rows": 4885,
- "Plan Width": 300,
- "Actual Startup Time": 308.570,
- "Actual Total Time": 319.424,
- "Actual Rows": 9378,
- "Actual Loops": 1,
- "Output": ["phdrug_phdrug.id", "phdrug_phdrug.uuid", "phdrug_phdrug.default_description", "phdrug_phdrug.alternative_description", "phdrug_phdrug.ean", "phdrug_phdrug.mirror_ean", "phdrug_phdrug.parent_ean", "phdrug_phdrug.reg_num", "phdrug_phdrug.medika_code", "phdrug_phdrug.atc_iv", "phdrug_phdrug.product_type", "phdrug_phdrug.fraction", "phdrug_phdrug.active", "phdrug_phdrug.loyal", "phdrug_phdrug.patent", "phdrug_phdrug.chronics", "phdrug_phdrug.recipe", "phdrug_phdrug.deal", "phdrug_phdrug.specialized", "phdrug_phdrug.armored", "phdrug_phdrug.top_hight_speciality", "phdrug_phdrug.top_generic", "phdrug_phdrug.hight_speciality", "phdrug_phdrug.temp_8_15", "phdrug_phdrug.temp_15_25", "phdrug_phdrug.temp_2_8", "phdrug_phdrug.temp_less_15", "phdrug_phdrug.new", "phdrug_phdrug.mdk_internal_code", "phdrug_phdrug.mdk_single_id", "phdrug_phdrug.mdk_object_id", "phdrug_phdrug.is_from_mdk_db", "phdrug_phdrug.top", "phdrug_phdrug.laboratory_name", "phdrug_phdrug.laboratory_alternative_name", "phdrug_phdrug.imported", "phdrug_phdrug.imported_country", "phdrug_phdrug.laboratory_id", "phdrug_phdrug.specialty", "phdrug_phdrug.dimension_id", "phdrug_phdrug.featured", "phdrug_phdrug.top_ae_rank", "phdrug_phdrug.top_farma_rank"],
- "Shared Hit Blocks": 57130,
- "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": "Sort",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Startup Cost": 23303.96,
- "Total Cost": 23316.17,
- "Plan Rows": 4885,
- "Plan Width": 300,
- "Actual Startup Time": 308.568,
- "Actual Total Time": 309.748,
- "Actual Rows": 9564,
- "Actual Loops": 1,
- "Output": ["phdrug_phdrug.id", "phdrug_phdrug.uuid", "phdrug_phdrug.default_description", "phdrug_phdrug.alternative_description", "phdrug_phdrug.ean", "phdrug_phdrug.mirror_ean", "phdrug_phdrug.parent_ean", "phdrug_phdrug.reg_num", "phdrug_phdrug.medika_code", "phdrug_phdrug.atc_iv", "phdrug_phdrug.product_type", "phdrug_phdrug.fraction", "phdrug_phdrug.active", "phdrug_phdrug.loyal", "phdrug_phdrug.patent", "phdrug_phdrug.chronics", "phdrug_phdrug.recipe", "phdrug_phdrug.deal", "phdrug_phdrug.specialized", "phdrug_phdrug.armored", "phdrug_phdrug.top_hight_speciality", "phdrug_phdrug.top_generic", "phdrug_phdrug.hight_speciality", "phdrug_phdrug.temp_8_15", "phdrug_phdrug.temp_15_25", "phdrug_phdrug.temp_2_8", "phdrug_phdrug.temp_less_15", "phdrug_phdrug.new", "phdrug_phdrug.mdk_internal_code", "phdrug_phdrug.mdk_single_id", "phdrug_phdrug.mdk_object_id", "phdrug_phdrug.is_from_mdk_db", "phdrug_phdrug.top", "phdrug_phdrug.laboratory_name", "phdrug_phdrug.laboratory_alternative_name", "phdrug_phdrug.imported", "phdrug_phdrug.imported_country", "phdrug_phdrug.laboratory_id", "phdrug_phdrug.specialty", "phdrug_phdrug.dimension_id", "phdrug_phdrug.featured", "phdrug_phdrug.top_ae_rank", "phdrug_phdrug.top_farma_rank"],
- "Sort Key": ["phdrug_phdrug.id", "phdrug_phdrug.default_description", "phdrug_phdrug.uuid", "phdrug_phdrug.alternative_description", "phdrug_phdrug.ean", "phdrug_phdrug.mirror_ean", "phdrug_phdrug.parent_ean", "phdrug_phdrug.reg_num", "phdrug_phdrug.medika_code", "phdrug_phdrug.atc_iv", "phdrug_phdrug.product_type", "phdrug_phdrug.fraction", "phdrug_phdrug.active", "phdrug_phdrug.loyal", "phdrug_phdrug.patent", "phdrug_phdrug.chronics", "phdrug_phdrug.recipe", "phdrug_phdrug.deal", "phdrug_phdrug.specialized", "phdrug_phdrug.armored", "phdrug_phdrug.top_hight_speciality", "phdrug_phdrug.top_generic", "phdrug_phdrug.hight_speciality", "phdrug_phdrug.temp_8_15", "phdrug_phdrug.temp_15_25", "phdrug_phdrug.temp_2_8", "phdrug_phdrug.temp_less_15", "phdrug_phdrug.new", "phdrug_phdrug.mdk_internal_code", "phdrug_phdrug.mdk_single_id", "phdrug_phdrug.mdk_object_id", "phdrug_phdrug.is_from_mdk_db", "phdrug_phdrug.top", "phdrug_phdrug.laboratory_name", "phdrug_phdrug.laboratory_alternative_name", "phdrug_phdrug.imported", "phdrug_phdrug.imported_country", "phdrug_phdrug.laboratory_id", "phdrug_phdrug.specialty", "phdrug_phdrug.dimension_id", "phdrug_phdrug.featured", "phdrug_phdrug.top_ae_rank", "phdrug_phdrug.top_farma_rank"],
- "Sort Method": "quicksort",
- "Sort Space Used": 2959,
- "Sort Space Type": "Memory",
- "Shared Hit Blocks": 57130,
- "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": "Inner",
- "Startup Cost": 21789.58,
- "Total Cost": 23004.65,
- "Plan Rows": 4885,
- "Plan Width": 300,
- "Actual Startup Time": 266.604,
- "Actual Total Time": 294.714,
- "Actual Rows": 9564,
- "Actual Loops": 1,
- "Output": ["phdrug_phdrug.id", "phdrug_phdrug.uuid", "phdrug_phdrug.default_description", "phdrug_phdrug.alternative_description", "phdrug_phdrug.ean", "phdrug_phdrug.mirror_ean", "phdrug_phdrug.parent_ean", "phdrug_phdrug.reg_num", "phdrug_phdrug.medika_code", "phdrug_phdrug.atc_iv", "phdrug_phdrug.product_type", "phdrug_phdrug.fraction", "phdrug_phdrug.active", "phdrug_phdrug.loyal", "phdrug_phdrug.patent", "phdrug_phdrug.chronics", "phdrug_phdrug.recipe", "phdrug_phdrug.deal", "phdrug_phdrug.specialized", "phdrug_phdrug.armored", "phdrug_phdrug.top_hight_speciality", "phdrug_phdrug.top_generic", "phdrug_phdrug.hight_speciality", "phdrug_phdrug.temp_8_15", "phdrug_phdrug.temp_15_25", "phdrug_phdrug.temp_2_8", "phdrug_phdrug.temp_less_15", "phdrug_phdrug.new", "phdrug_phdrug.mdk_internal_code", "phdrug_phdrug.mdk_single_id", "phdrug_phdrug.mdk_object_id", "phdrug_phdrug.is_from_mdk_db", "phdrug_phdrug.top", "phdrug_phdrug.laboratory_name", "phdrug_phdrug.laboratory_alternative_name", "phdrug_phdrug.imported", "phdrug_phdrug.imported_country", "phdrug_phdrug.laboratory_id", "phdrug_phdrug.specialty", "phdrug_phdrug.dimension_id", "phdrug_phdrug.featured", "phdrug_phdrug.top_ae_rank", "phdrug_phdrug.top_farma_rank"],
- "Inner Unique": false,
- "Hash Cond": "(phdrug_phdrug.id = phdrug_phdrugpicture.drug_id)",
- "Shared Hit Blocks": 57130,
- "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": "Inner",
- "Startup Cost": 21285.56,
- "Total Cost": 22364.48,
- "Plan Rows": 7760,
- "Plan Width": 304,
- "Actual Startup Time": 259.750,
- "Actual Total Time": 281.295,
- "Actual Rows": 10260,
- "Actual Loops": 1,
- "Output": ["monetary_drugprice.drug_id", "phdrug_phdrug.id", "phdrug_phdrug.uuid", "phdrug_phdrug.default_description", "phdrug_phdrug.alternative_description", "phdrug_phdrug.ean", "phdrug_phdrug.mirror_ean", "phdrug_phdrug.parent_ean", "phdrug_phdrug.reg_num", "phdrug_phdrug.medika_code", "phdrug_phdrug.atc_iv", "phdrug_phdrug.product_type", "phdrug_phdrug.fraction", "phdrug_phdrug.active", "phdrug_phdrug.loyal", "phdrug_phdrug.patent", "phdrug_phdrug.chronics", "phdrug_phdrug.recipe", "phdrug_phdrug.deal", "phdrug_phdrug.specialized", "phdrug_phdrug.armored", "phdrug_phdrug.top_hight_speciality", "phdrug_phdrug.top_generic", "phdrug_phdrug.hight_speciality", "phdrug_phdrug.temp_8_15", "phdrug_phdrug.temp_15_25", "phdrug_phdrug.temp_2_8", "phdrug_phdrug.temp_less_15", "phdrug_phdrug.new", "phdrug_phdrug.mdk_internal_code", "phdrug_phdrug.mdk_single_id", "phdrug_phdrug.mdk_object_id", "phdrug_phdrug.is_from_mdk_db", "phdrug_phdrug.top", "phdrug_phdrug.laboratory_name", "phdrug_phdrug.laboratory_alternative_name", "phdrug_phdrug.imported", "phdrug_phdrug.imported_country", "phdrug_phdrug.laboratory_id", "phdrug_phdrug.specialty", "phdrug_phdrug.dimension_id", "phdrug_phdrug.featured", "phdrug_phdrug.top_ae_rank", "phdrug_phdrug.top_farma_rank"],
- "Inner Unique": false,
- "Hash Cond": "(phdrug_phdrug.id = monetary_drugprice.drug_id)",
- "Shared Hit Blocks": 56939,
- "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": "phdrug_phdrug",
- "Schema": "public",
- "Alias": "phdrug_phdrug",
- "Startup Cost": 0.00,
- "Total Cost": 812.18,
- "Plan Rows": 21616,
- "Plan Width": 300,
- "Actual Startup Time": 0.559,
- "Actual Total Time": 13.736,
- "Actual Rows": 21616,
- "Actual Loops": 1,
- "Output": ["phdrug_phdrug.id", "phdrug_phdrug.uuid", "phdrug_phdrug.default_description", "phdrug_phdrug.alternative_description", "phdrug_phdrug.ean", "phdrug_phdrug.mirror_ean", "phdrug_phdrug.parent_ean", "phdrug_phdrug.reg_num", "phdrug_phdrug.medika_code", "phdrug_phdrug.atc_iv", "phdrug_phdrug.product_type", "phdrug_phdrug.fraction", "phdrug_phdrug.active", "phdrug_phdrug.loyal", "phdrug_phdrug.patent", "phdrug_phdrug.chronics", "phdrug_phdrug.recipe", "phdrug_phdrug.deal", "phdrug_phdrug.specialized", "phdrug_phdrug.armored", "phdrug_phdrug.top_hight_speciality", "phdrug_phdrug.top_generic", "phdrug_phdrug.hight_speciality", "phdrug_phdrug.temp_8_15", "phdrug_phdrug.temp_15_25", "phdrug_phdrug.temp_2_8", "phdrug_phdrug.temp_less_15", "phdrug_phdrug.new", "phdrug_phdrug.mdk_internal_code", "phdrug_phdrug.mdk_single_id", "phdrug_phdrug.mdk_object_id", "phdrug_phdrug.is_from_mdk_db", "phdrug_phdrug.top", "phdrug_phdrug.laboratory_name", "phdrug_phdrug.laboratory_alternative_name", "phdrug_phdrug.imported", "phdrug_phdrug.imported_country", "phdrug_phdrug.laboratory_id", "phdrug_phdrug.specialty", "phdrug_phdrug.dimension_id", "phdrug_phdrug.featured", "phdrug_phdrug.top_ae_rank", "phdrug_phdrug.top_farma_rank"],
- "Filter": "phdrug_phdrug.active",
- "Rows Removed by Filter": 2,
- "Shared Hit Blocks": 596,
- "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": 21187.67,
- "Total Cost": 21187.67,
- "Plan Rows": 7831,
- "Plan Width": 4,
- "Actual Startup Time": 259.108,
- "Actual Total Time": 259.108,
- "Actual Rows": 10260,
- "Actual Loops": 1,
- "Output": ["monetary_drugprice.drug_id"],
- "Hash Buckets": 16384,
- "Original Hash Buckets": 8192,
- "Hash Batches": 1,
- "Original Hash Batches": 1,
- "Peak Memory Usage": 489,
- "Shared Hit Blocks": 56343,
- "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": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 16592.44,
- "Total Cost": 21187.67,
- "Plan Rows": 7831,
- "Plan Width": 4,
- "Actual Startup Time": 219.168,
- "Actual Total Time": 255.916,
- "Actual Rows": 10260,
- "Actual Loops": 1,
- "Output": ["monetary_drugprice.drug_id"],
- "Inner Unique": true,
- "Shared Hit Blocks": 56343,
- "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": "Aggregate",
- "Strategy": "Hashed",
- "Partial Mode": "Simple",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Startup Cost": 16592.02,
- "Total Cost": 16670.33,
- "Plan Rows": 7831,
- "Plan Width": 4,
- "Actual Startup Time": 219.142,
- "Actual Total Time": 222.492,
- "Actual Rows": 10260,
- "Actual Loops": 1,
- "Output": ["v0.id"],
- "Group Key": ["v0.id"],
- "Shared Hit Blocks": 15276,
- "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": "Gather",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Startup Cost": 1051.99,
- "Total Cost": 16572.44,
- "Plan Rows": 7831,
- "Plan Width": 4,
- "Actual Startup Time": 23.276,
- "Actual Total Time": 210.572,
- "Actual Rows": 10260,
- "Actual Loops": 1,
- "Output": ["v0.id"],
- "Workers Planned": 2,
- "Workers Launched": 2,
- "Single Copy": false,
- "Shared Hit Blocks": 15276,
- "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": "Inner",
- "Startup Cost": 51.99,
- "Total Cost": 14789.34,
- "Plan Rows": 3263,
- "Plan Width": 4,
- "Actual Startup Time": 12.931,
- "Actual Total Time": 119.657,
- "Actual Rows": 3420,
- "Actual Loops": 3,
- "Output": ["v0.id"],
- "Inner Unique": true,
- "Hash Cond": "(v0.pricelist_id = u0.id)",
- "Shared Hit Blocks": 15276,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 6.093,
- "Actual Total Time": 78.364,
- "Actual Rows": 2137,
- "Actual Loops": 1,
- "Shared Hit Blocks": 2910,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 14.250,
- "Actual Total Time": 79.606,
- "Actual Rows": 883,
- "Actual Loops": 1,
- "Shared Hit Blocks": 2584,
- "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": true,
- "Relation Name": "monetary_drugprice",
- "Schema": "public",
- "Alias": "v0",
- "Startup Cost": 0.00,
- "Total Cost": 14307.49,
- "Plan Rows": 159145,
- "Plan Width": 8,
- "Actual Startup Time": 0.013,
- "Actual Total Time": 80.031,
- "Actual Rows": 127415,
- "Actual Loops": 3,
- "Output": ["v0.id", "v0.mdk_object_id", "v0.is_from_mdk_db", "v0.pvp_currency", "v0.pvp", "v0.pharmacy_price_currency", "v0.pharmacy_price", "v0.base_currency", "v0.base", "v0.no_tax_price_currency", "v0.no_tax_price", "v0.system_no_tax_price_currency", "v0.system_no_tax_price", "v0.all_included_price_currency", "v0.all_included_price", "v0.system_all_included_price_currency", "v0.system_all_included_price", "v0.margin", "v0.stock", "v0.drug_id", "v0.pricelist_id", "v0.uuid", "v0.offer", "v0.mdk_pricing_id", "v0.system_all_included_price_rate", "v0.system_no_tax_price_rate", "v0.all_included_price_before", "v0.all_included_price_before_currency", "v0.no_tax_price_before", "v0.no_tax_price_before_currency", "v0.system_all_included_price_before", "v0.system_all_included_price_before_currency", "v0.system_all_included_price_before_rate", "v0.system_no_tax_price_before", "v0.system_no_tax_price_before_currency", "v0.system_no_tax_price_before_rate", "v0.calculated_base", "v0.calculated_base_currency", "v0.system_calculated_base", "v0.system_calculated_base_currency", "v0.system_calculated_base_rate"],
- "Filter": "(v0.stock > 0)",
- "Rows Removed by Filter": 1064,
- "Shared Hit Blocks": 12300,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.016,
- "Actual Total Time": 54.434,
- "Actual Rows": 59112,
- "Actual Loops": 1,
- "Shared Hit Blocks": 1906,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.013,
- "Actual Total Time": 57.795,
- "Actual Rows": 48972,
- "Actual Loops": 1,
- "Shared Hit Blocks": 1580,
- "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": 51.95,
- "Total Cost": 51.95,
- "Plan Rows": 3,
- "Plan Width": 4,
- "Actual Startup Time": 12.820,
- "Actual Total Time": 12.820,
- "Actual Rows": 6,
- "Actual Loops": 3,
- "Output": ["u0.id"],
- "Hash Buckets": 1024,
- "Original Hash Buckets": 1024,
- "Hash Batches": 1,
- "Original Hash Batches": 1,
- "Peak Memory Usage": 9,
- "Shared Hit Blocks": 2928,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 5.920,
- "Actual Total Time": 5.920,
- "Actual Rows": 6,
- "Actual Loops": 1,
- "Shared Hit Blocks": 980,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 14.114,
- "Actual Total Time": 14.114,
- "Actual Rows": 6,
- "Actual Loops": 1,
- "Shared Hit Blocks": 980,
- "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": "Unique",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Startup Cost": 51.91,
- "Total Cost": 51.92,
- "Plan Rows": 3,
- "Plan Width": 4,
- "Actual Startup Time": 12.802,
- "Actual Total Time": 12.811,
- "Actual Rows": 6,
- "Actual Loops": 3,
- "Output": ["u0.id"],
- "Shared Hit Blocks": 2928,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 5.903,
- "Actual Total Time": 5.910,
- "Actual Rows": 6,
- "Actual Loops": 1,
- "Shared Hit Blocks": 980,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 14.096,
- "Actual Total Time": 14.104,
- "Actual Rows": 6,
- "Actual Loops": 1,
- "Shared Hit Blocks": 980,
- "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": "Sort",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Startup Cost": 51.91,
- "Total Cost": 51.91,
- "Plan Rows": 3,
- "Plan Width": 4,
- "Actual Startup Time": 12.801,
- "Actual Total Time": 12.804,
- "Actual Rows": 41,
- "Actual Loops": 3,
- "Output": ["u0.id"],
- "Sort Key": ["u0.id"],
- "Sort Method": "quicksort",
- "Sort Space Used": 26,
- "Sort Space Type": "Memory",
- "Shared Hit Blocks": 2928,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 5.902,
- "Actual Total Time": 5.905,
- "Actual Rows": 41,
- "Actual Loops": 1,
- "Shared Hit Blocks": 980,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 14.095,
- "Actual Total Time": 14.098,
- "Actual Rows": 41,
- "Actual Loops": 1,
- "Shared Hit Blocks": 980,
- "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": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 5.88,
- "Total Cost": 51.88,
- "Plan Rows": 3,
- "Plan Width": 4,
- "Actual Startup Time": 7.780,
- "Actual Total Time": 12.742,
- "Actual Rows": 41,
- "Actual Loops": 3,
- "Output": ["u0.id"],
- "Inner Unique": false,
- "Shared Hit Blocks": 2914,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 3.996,
- "Actual Total Time": 5.852,
- "Actual Rows": 41,
- "Actual Loops": 1,
- "Shared Hit Blocks": 973,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 11.617,
- "Actual Total Time": 14.019,
- "Actual Rows": 41,
- "Actual Loops": 1,
- "Shared Hit Blocks": 973,
- "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": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 5.59,
- "Total Cost": 35.29,
- "Plan Rows": 2,
- "Plan Width": 12,
- "Actual Startup Time": 7.703,
- "Actual Total Time": 10.022,
- "Actual Rows": 22,
- "Actual Loops": 3,
- "Output": ["u0.id", "u3.carrier_id", "u4.id"],
- "Inner Unique": true,
- "Shared Hit Blocks": 2018,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 3.953,
- "Actual Total Time": 4.746,
- "Actual Rows": 22,
- "Actual Loops": 1,
- "Shared Hit Blocks": 674,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 11.581,
- "Actual Total Time": 12.364,
- "Actual Rows": 22,
- "Actual Loops": 1,
- "Shared Hit Blocks": 674,
- "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": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 5.45,
- "Total Cost": 34.78,
- "Plan Rows": 2,
- "Plan Width": 8,
- "Actual Startup Time": 5.313,
- "Actual Total Time": 7.505,
- "Actual Rows": 22,
- "Actual Loops": 3,
- "Output": ["u0.id", "u3.carrier_id"],
- "Inner Unique": true,
- "Shared Hit Blocks": 1884,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 3.638,
- "Actual Total Time": 4.393,
- "Actual Rows": 22,
- "Actual Loops": 1,
- "Shared Hit Blocks": 629,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 4.736,
- "Actual Total Time": 5.480,
- "Actual Rows": 22,
- "Actual Loops": 1,
- "Shared Hit Blocks": 629,
- "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": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 5.18,
- "Total Cost": 32.05,
- "Plan Rows": 4,
- "Plan Width": 12,
- "Actual Startup Time": 5.286,
- "Actual Total Time": 7.277,
- "Actual Rows": 22,
- "Actual Loops": 3,
- "Output": ["u0.id", "u0.manager_id", "u3.carrier_id"],
- "Inner Unique": true,
- "Shared Hit Blocks": 1684,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 3.608,
- "Actual Total Time": 4.253,
- "Actual Rows": 22,
- "Actual Loops": 1,
- "Shared Hit Blocks": 562,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 4.697,
- "Actual Total Time": 5.372,
- "Actual Rows": 22,
- "Actual Loops": 1,
- "Shared Hit Blocks": 562,
- "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": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 4.91,
- "Total Cost": 25.42,
- "Plan Rows": 13,
- "Plan Width": 20,
- "Actual Startup Time": 4.952,
- "Actual Total Time": 6.366,
- "Actual Rows": 106,
- "Actual Loops": 3,
- "Output": ["u0.id", "u0.manager_id", "u1.pricelist_id", "u3.pricelist_id", "u3.carrier_id"],
- "Inner Unique": true,
- "Join Filter": "(u1.pricelist_id = u0.id)",
- "Rows Removed by Join Filter": 0,
- "Shared Hit Blocks": 980,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 3.404,
- "Actual Total Time": 3.793,
- "Actual Rows": 106,
- "Actual Loops": 1,
- "Shared Hit Blocks": 327,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 3.921,
- "Actual Total Time": 4.333,
- "Actual Rows": 106,
- "Actual Loops": 1,
- "Shared Hit Blocks": 327,
- "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": "Inner",
- "Startup Cost": 4.76,
- "Total Cost": 10.73,
- "Plan Rows": 36,
- "Plan Width": 12,
- "Actual Startup Time": 4.906,
- "Actual Total Time": 5.175,
- "Actual Rows": 161,
- "Actual Loops": 3,
- "Output": ["u1.pricelist_id", "u3.pricelist_id", "u3.carrier_id"],
- "Inner Unique": false,
- "Hash Cond": "(u1.pricelist_id = u3.pricelist_id)",
- "Shared Hit Blocks": 12,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 3.370,
- "Actual Total Time": 3.458,
- "Actual Rows": 161,
- "Actual Loops": 1,
- "Shared Hit Blocks": 4,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 3.881,
- "Actual Total Time": 3.979,
- "Actual Rows": 161,
- "Actual Loops": 1,
- "Shared Hit Blocks": 4,
- "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": "monetary_pricelistdestinations",
- "Schema": "public",
- "Alias": "u1",
- "Startup Cost": 0.00,
- "Total Cost": 5.15,
- "Plan Rows": 46,
- "Plan Width": 4,
- "Actual Startup Time": 1.409,
- "Actual Total Time": 1.451,
- "Actual Rows": 46,
- "Actual Loops": 3,
- "Output": ["u1.id", "u1.uuid", "u1.mdk_org_object_id", "u1.to_public", "u1.to_all_pharmacies", "u1.to_all_insurances", "u1.pricelist_id", "u1.to_organization_customer_id"],
- "Filter": "u1.to_public",
- "Rows Removed by Filter": 169,
- "Shared Hit Blocks": 9,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 1.510,
- "Actual Total Time": 1.543,
- "Actual Rows": 46,
- "Actual Loops": 1,
- "Shared Hit Blocks": 3,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 2.265,
- "Actual Total Time": 2.303,
- "Actual Rows": 46,
- "Actual Loops": 1,
- "Shared Hit Blocks": 3,
- "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": 2.67,
- "Total Cost": 2.67,
- "Plan Rows": 167,
- "Plan Width": 8,
- "Actual Startup Time": 3.433,
- "Actual Total Time": 3.433,
- "Actual Rows": 167,
- "Actual Loops": 3,
- "Output": ["u3.pricelist_id", "u3.carrier_id"],
- "Hash Buckets": 1024,
- "Original Hash Buckets": 1024,
- "Hash Batches": 1,
- "Original Hash Batches": 1,
- "Peak Memory Usage": 15,
- "Shared Hit Blocks": 3,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 1.813,
- "Actual Total Time": 1.813,
- "Actual Rows": 167,
- "Actual Loops": 1,
- "Shared Hit Blocks": 1,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 1.594,
- "Actual Total Time": 1.594,
- "Actual Rows": 167,
- "Actual Loops": 1,
- "Shared Hit Blocks": 1,
- "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": "courier_carrier_pricelists",
- "Schema": "public",
- "Alias": "u3",
- "Startup Cost": 0.00,
- "Total Cost": 2.67,
- "Plan Rows": 167,
- "Plan Width": 8,
- "Actual Startup Time": 3.176,
- "Actual Total Time": 3.208,
- "Actual Rows": 167,
- "Actual Loops": 3,
- "Output": ["u3.pricelist_id", "u3.carrier_id"],
- "Shared Hit Blocks": 3,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 1.751,
- "Actual Total Time": 1.773,
- "Actual Rows": 167,
- "Actual Loops": 1,
- "Shared Hit Blocks": 1,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 1.536,
- "Actual Total Time": 1.557,
- "Actual Rows": 167,
- "Actual Loops": 1,
- "Shared Hit Blocks": 1,
- "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": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "monetary_pricelist_pkey",
- "Relation Name": "monetary_pricelist",
- "Schema": "public",
- "Alias": "u0",
- "Startup Cost": 0.15,
- "Total Cost": 0.40,
- "Plan Rows": 1,
- "Plan Width": 8,
- "Actual Startup Time": 0.006,
- "Actual Total Time": 0.006,
- "Actual Rows": 1,
- "Actual Loops": 483,
- "Output": ["u0.id", "u0.uuid", "u0.name", "u0.mdk_object_id", "u0.active", "u0.expires", "u0.datestart", "u0.dateend", "u0.is_from_mdk_db", "u0.manager_id", "u0.mdk_manager_object_id", "u0.international_trade_export"],
- "Index Cond": "(u0.id = u3.pricelist_id)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "(u0.active AND ((NOT u0.expires) OR (u0.expires AND ((timezone('UTC'::text, u0.datestart))::date <= '2020-05-01'::date) AND ((timezone('UTC'::text, u0.dateend))::date >= '2020-05-01'::date))))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 968,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.001,
- "Actual Total Time": 0.001,
- "Actual Rows": 1,
- "Actual Loops": 161,
- "Shared Hit Blocks": 323,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 1,
- "Actual Loops": 161,
- "Shared Hit Blocks": 323,
- "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": "Index Only Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "monetary_pricelistcountry_country_pricelist_id_be9ca8b0_uniq",
- "Relation Name": "monetary_pricelistcountry",
- "Schema": "public",
- "Alias": "u6",
- "Startup Cost": 0.28,
- "Total Cost": 0.51,
- "Plan Rows": 1,
- "Plan Width": 4,
- "Actual Startup Time": 0.008,
- "Actual Total Time": 0.008,
- "Actual Rows": 0,
- "Actual Loops": 318,
- "Output": ["u6.country", "u6.pricelist_id"],
- "Index Cond": "((u6.country = 'MX'::text) AND (u6.pricelist_id = u0.id))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 22,
- "Shared Hit Blocks": 704,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 0,
- "Actual Loops": 106,
- "Shared Hit Blocks": 235,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.009,
- "Actual Total Time": 0.009,
- "Actual Rows": 0,
- "Actual Loops": 106,
- "Shared Hit Blocks": 235,
- "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": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "organization_organization_pkey",
- "Relation Name": "organization_organization",
- "Schema": "public",
- "Alias": "u2",
- "Startup Cost": 0.27,
- "Total Cost": 0.68,
- "Plan Rows": 1,
- "Plan Width": 4,
- "Actual Startup Time": 0.009,
- "Actual Total Time": 0.009,
- "Actual Rows": 1,
- "Actual Loops": 66,
- "Output": ["u2.id", "u2.uuid", "u2.organization_type", "u2.mdk_object_id", "u2.medika_connect_token", "u2.theparent_id", "u2.active", "u2.person_id", "u2.address", "u2.business_line", "u2.colony", "u2.country", "u2.email", "u2.image_header", "u2.legal_name", "u2.logo", "u2.phone", "u2.postal_code", "u2.public_name", "u2.tax_id", "u2.town", "u2.web_page", "u2.is_mdk_profile", "u2.configuration_id", "u2.phone2", "u2.preferred_language_id", "u2.is_global_group"],
- "Index Cond": "(u2.id = u0.manager_id)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "(u2.active AND (u2.organization_type = 2))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 200,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.006,
- "Actual Total Time": 0.006,
- "Actual Rows": 1,
- "Actual Loops": 22,
- "Shared Hit Blocks": 67,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 1,
- "Actual Loops": 22,
- "Shared Hit Blocks": 67,
- "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": "Index Only Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "drugtransaction_carrier_pkey",
- "Relation Name": "courier_carrier",
- "Schema": "public",
- "Alias": "u4",
- "Startup Cost": 0.14,
- "Total Cost": 0.25,
- "Plan Rows": 1,
- "Plan Width": 4,
- "Actual Startup Time": 0.113,
- "Actual Total Time": 0.113,
- "Actual Rows": 1,
- "Actual Loops": 66,
- "Output": ["u4.id"],
- "Index Cond": "(u4.id = u3.carrier_id)",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 22,
- "Shared Hit Blocks": 134,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.015,
- "Actual Total Time": 0.015,
- "Actual Rows": 1,
- "Actual Loops": 22,
- "Shared Hit Blocks": 45,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.312,
- "Actual Total Time": 0.312,
- "Actual Rows": 1,
- "Actual Loops": 22,
- "Shared Hit Blocks": 45,
- "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": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "drugtransaction_carrierdelivery_carrier_id_dff8fb35",
- "Relation Name": "courier_carrierdelivery",
- "Schema": "public",
- "Alias": "u5",
- "Startup Cost": 0.29,
- "Total Cost": 8.28,
- "Plan Rows": 2,
- "Plan Width": 4,
- "Actual Startup Time": 0.052,
- "Actual Total Time": 0.122,
- "Actual Rows": 2,
- "Actual Loops": 66,
- "Output": ["u5.id", "u5.uuid", "u5.dst_country", "u5.postal_code", "u5.carrier_id", "u5.exclude_code_range_lower", "u5.exclude_code_range_upper", "u5.postal_code_range_lower", "u5.postal_code_range_upper", "u5.external_service_id", "u5.mdk_object_id", "u5.ignore_country_filter"],
- "Index Cond": "(u5.carrier_id = u3.carrier_id)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "(((u5.dst_country)::text = 'MX'::text) OR u5.ignore_country_filter)",
- "Rows Removed by Filter": 117,
- "Shared Hit Blocks": 896,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.019,
- "Actual Total Time": 0.049,
- "Actual Rows": 2,
- "Actual Loops": 22,
- "Shared Hit Blocks": 299,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.025,
- "Actual Total Time": 0.074,
- "Actual Rows": 2,
- "Actual Loops": 22,
- "Shared Hit Blocks": 299,
- "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": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "monetary_drugprice_pkey",
- "Relation Name": "monetary_drugprice",
- "Schema": "public",
- "Alias": "monetary_drugprice",
- "Startup Cost": 0.42,
- "Total Cost": 0.58,
- "Plan Rows": 1,
- "Plan Width": 8,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 10260,
- "Output": ["monetary_drugprice.id", "monetary_drugprice.mdk_object_id", "monetary_drugprice.is_from_mdk_db", "monetary_drugprice.pvp_currency", "monetary_drugprice.pvp", "monetary_drugprice.pharmacy_price_currency", "monetary_drugprice.pharmacy_price", "monetary_drugprice.base_currency", "monetary_drugprice.base", "monetary_drugprice.no_tax_price_currency", "monetary_drugprice.no_tax_price", "monetary_drugprice.system_no_tax_price_currency", "monetary_drugprice.system_no_tax_price", "monetary_drugprice.all_included_price_currency", "monetary_drugprice.all_included_price", "monetary_drugprice.system_all_included_price_currency", "monetary_drugprice.system_all_included_price", "monetary_drugprice.margin", "monetary_drugprice.stock", "monetary_drugprice.drug_id", "monetary_drugprice.pricelist_id", "monetary_drugprice.uuid", "monetary_drugprice.offer", "monetary_drugprice.mdk_pricing_id", "monetary_drugprice.system_all_included_price_rate", "monetary_drugprice.system_no_tax_price_rate", "monetary_drugprice.all_included_price_before", "monetary_drugprice.all_included_price_before_currency", "monetary_drugprice.no_tax_price_before", "monetary_drugprice.no_tax_price_before_currency", "monetary_drugprice.system_all_included_price_before", "monetary_drugprice.system_all_included_price_before_currency", "monetary_drugprice.system_all_included_price_before_rate", "monetary_drugprice.system_no_tax_price_before", "monetary_drugprice.system_no_tax_price_before_currency", "monetary_drugprice.system_no_tax_price_before_rate", "monetary_drugprice.calculated_base", "monetary_drugprice.calculated_base_currency", "monetary_drugprice.system_calculated_base", "monetary_drugprice.system_calculated_base_currency", "monetary_drugprice.system_calculated_base_rate"],
- "Index Cond": "(monetary_drugprice.id = v0.id)",
- "Rows Removed by Index Recheck": 0,
- "Shared Hit Blocks": 41067,
- "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": 333.92,
- "Total Cost": 333.92,
- "Plan Rows": 13608,
- "Plan Width": 4,
- "Actual Startup Time": 6.800,
- "Actual Total Time": 6.800,
- "Actual Rows": 13608,
- "Actual Loops": 1,
- "Output": ["phdrug_phdrugpicture.drug_id"],
- "Hash Buckets": 16384,
- "Original Hash Buckets": 16384,
- "Hash Batches": 1,
- "Original Hash Batches": 1,
- "Peak Memory Usage": 607,
- "Shared Hit Blocks": 191,
- "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": "phdrug_phdrugpicture",
- "Schema": "public",
- "Alias": "phdrug_phdrugpicture",
- "Startup Cost": 0.00,
- "Total Cost": 333.92,
- "Plan Rows": 13608,
- "Plan Width": 4,
- "Actual Startup Time": 0.487,
- "Actual Total Time": 4.032,
- "Actual Rows": 13608,
- "Actual Loops": 1,
- "Output": ["phdrug_phdrugpicture.drug_id"],
- "Filter": "phdrug_phdrugpicture.is_main",
- "Rows Removed by Filter": 684,
- "Shared Hit Blocks": 191,
- "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": 60.221,
- "Triggers": [
- ],
- "Execution Time": 320.527
- }
- ]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement