[
{
"Plan": {
"Node Type": "Limit",
"Parallel Aware": false,
"Startup Cost": 22.32,
"Total Cost": 25.52,
"Plan Rows": 80,
"Plan Width": 729,
"Actual Startup Time": 0.389,
"Actual Total Time": 0.431,
"Actual Rows": 45,
"Actual Loops": 1,
"Output": ["documentoeletronicoven.nr_documento", "documentoeletronicoven.nr_serie", "vendapdv.dt_movimento", "documentoeletronicochaveven.tx_chave", "(sum(vendaitempdv.vl_totalliquido))", "documentoeletronicoven.cd_status", "documentoeletronicoeventoven.cd_situacao", "documentoeletronicoeventoven.tx_motivo", "vendapdv.id_vendapdv", "integracaovendaven.fl_integrado", "documentoeletronicoven.dt_cadastro"],
"Shared Hit Blocks": 8,
"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": "Sorted",
"Partial Mode": "Simple",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Startup Cost": 22.32,
"Total Cost": 25.52,
"Plan Rows": 80,
"Plan Width": 729,
"Actual Startup Time": 0.389,
"Actual Total Time": 0.429,
"Actual Rows": 45,
"Actual Loops": 1,
"Output": ["documentoeletronicoven.nr_documento", "documentoeletronicoven.nr_serie", "vendapdv.dt_movimento", "documentoeletronicochaveven.tx_chave", "sum(vendaitempdv.vl_totalliquido)", "documentoeletronicoven.cd_status", "documentoeletronicoeventoven.cd_situacao", "documentoeletronicoeventoven.tx_motivo", "vendapdv.id_vendapdv", "integracaovendaven.fl_integrado", "documentoeletronicoven.dt_cadastro"],
"Group Key": ["documentoeletronicoven.dt_cadastro", "documentoeletronicoven.nr_documento", "documentoeletronicoven.nr_serie", "documentoeletronicochaveven.tx_chave", "documentoeletronicoven.cd_status", "documentoeletronicoeventoven.cd_situacao", "documentoeletronicoeventoven.tx_motivo", "vendapdv.id_vendapdv", "integracaovendaven.fl_integrado"],
"Shared Hit Blocks": 8,
"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": 22.32,
"Total Cost": 22.52,
"Plan Rows": 80,
"Plan Width": 704,
"Actual Startup Time": 0.384,
"Actual Total Time": 0.389,
"Actual Rows": 72,
"Actual Loops": 1,
"Output": ["documentoeletronicoven.nr_documento", "documentoeletronicoven.nr_serie", "documentoeletronicochaveven.tx_chave", "documentoeletronicoven.cd_status", "documentoeletronicoeventoven.cd_situacao", "documentoeletronicoeventoven.tx_motivo", "vendapdv.id_vendapdv", "integracaovendaven.fl_integrado", "documentoeletronicoven.dt_cadastro", "vendapdv.dt_movimento", "vendaitempdv.vl_totalliquido"],
"Sort Key": ["documentoeletronicoven.dt_cadastro DESC", "documentoeletronicoven.nr_documento DESC", "documentoeletronicoven.nr_serie", "documentoeletronicochaveven.tx_chave", "documentoeletronicoven.cd_status", "documentoeletronicoeventoven.cd_situacao", "documentoeletronicoeventoven.tx_motivo", "vendapdv.id_vendapdv", "integracaovendaven.fl_integrado"],
"Sort Method": "quicksort",
"Sort Space Used": 44,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 8,
"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": 15.76,
"Total Cost": 19.79,
"Plan Rows": 80,
"Plan Width": 704,
"Actual Startup Time": 0.291,
"Actual Total Time": 0.322,
"Actual Rows": 72,
"Actual Loops": 1,
"Output": ["documentoeletronicoven.nr_documento", "documentoeletronicoven.nr_serie", "documentoeletronicochaveven.tx_chave", "documentoeletronicoven.cd_status", "documentoeletronicoeventoven.cd_situacao", "documentoeletronicoeventoven.tx_motivo", "vendapdv.id_vendapdv", "integracaovendaven.fl_integrado", "documentoeletronicoven.dt_cadastro", "vendapdv.dt_movimento", "vendaitempdv.vl_totalliquido"],
"Hash Cond": "(vendaitempdv.cd_vendapdv = vendapdv.id_vendapdv)",
"Shared Hit Blocks": 8,
"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": "tb_vendaitempdv",
"Schema": "public",
"Alias": "vendaitempdv",
"Startup Cost": 0.00,
"Total Cost": 2.89,
"Plan Rows": 89,
"Plan Width": 12,
"Actual Startup Time": 0.022,
"Actual Total Time": 0.033,
"Actual Rows": 89,
"Actual Loops": 1,
"Output": ["vendaitempdv.vl_totalliquido", "vendaitempdv.cd_vendapdv"],
"Shared Hit Blocks": 2,
"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": 15.23,
"Total Cost": 15.23,
"Plan Rows": 43,
"Plan Width": 737,
"Actual Startup Time": 0.262,
"Actual Total Time": 0.262,
"Actual Rows": 45,
"Actual Loops": 1,
"Output": ["documentoeletronicovendaven.cd_vendaven", "vendapdv.dt_movimento", "vendapdv.id_vendapdv", "integracaovendaven.fl_integrado", "integracaovendaven.cd_vendapdv", "documentoeletronicoven.nr_documento", "documentoeletronicoven.nr_serie", "documentoeletronicoven.cd_status", "documentoeletronicoven.dt_cadastro", "documentoeletronicochaveven.tx_chave", "documentoeletronicoeventoven.cd_situacao", "documentoeletronicoeventoven.tx_motivo"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 16,
"Shared Hit Blocks": 6,
"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": 10.29,
"Total Cost": 15.23,
"Plan Rows": 43,
"Plan Width": 737,
"Actual Startup Time": 0.175,
"Actual Total Time": 0.246,
"Actual Rows": 45,
"Actual Loops": 1,
"Output": ["documentoeletronicovendaven.cd_vendaven", "vendapdv.dt_movimento", "vendapdv.id_vendapdv", "integracaovendaven.fl_integrado", "integracaovendaven.cd_vendapdv", "documentoeletronicoven.nr_documento", "documentoeletronicoven.nr_serie", "documentoeletronicoven.cd_status", "documentoeletronicoven.dt_cadastro", "documentoeletronicochaveven.tx_chave", "documentoeletronicoeventoven.cd_situacao", "documentoeletronicoeventoven.tx_motivo"],
"Hash Cond": "(documentoeletronicovendaven.cd_documentoeletrven = documentoeletronicoeventoven.cd_documentoeletrven)",
"Shared Hit Blocks": 6,
"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": 8.23,
"Total Cost": 12.58,
"Plan Rows": 43,
"Plan Width": 269,
"Actual Startup Time": 0.148,
"Actual Total Time": 0.207,
"Actual Rows": 45,
"Actual Loops": 1,
"Output": ["documentoeletronicovendaven.cd_vendaven", "documentoeletronicovendaven.cd_documentoeletrven", "vendapdv.dt_movimento", "vendapdv.id_vendapdv", "integracaovendaven.fl_integrado", "integracaovendaven.cd_vendapdv", "documentoeletronicoven.nr_documento", "documentoeletronicoven.nr_serie", "documentoeletronicoven.cd_status", "documentoeletronicoven.dt_cadastro", "documentoeletronicoven.id_documentoeletrven", "documentoeletronicochaveven.tx_chave", "documentoeletronicochaveven.cd_documentoeletrven"],
"Hash Cond": "(documentoeletronicovendaven.cd_documentoeletrven = documentoeletronicochaveven.cd_documentoeletrven)",
"Shared Hit Blocks": 5,
"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": 6.17,
"Total Cost": 9.93,
"Plan Rows": 43,
"Plan Width": 143,
"Actual Startup Time": 0.089,
"Actual Total Time": 0.136,
"Actual Rows": 45,
"Actual Loops": 1,
"Output": ["documentoeletronicovendaven.cd_vendaven", "documentoeletronicovendaven.cd_documentoeletrven", "vendapdv.dt_movimento", "vendapdv.id_vendapdv", "integracaovendaven.fl_integrado", "integracaovendaven.cd_vendapdv", "documentoeletronicoven.nr_documento", "documentoeletronicoven.nr_serie", "documentoeletronicoven.cd_status", "documentoeletronicoven.dt_cadastro", "documentoeletronicoven.id_documentoeletrven"],
"Hash Cond": "(documentoeletronicovendaven.cd_documentoeletrven = documentoeletronicoven.id_documentoeletrven)",
"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": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Inner",
"Startup Cost": 4.12,
"Total Cost": 7.28,
"Plan Rows": 43,
"Plan Width": 77,
"Actual Startup Time": 0.062,
"Actual Total Time": 0.096,
"Actual Rows": 45,
"Actual Loops": 1,
"Output": ["documentoeletronicovendaven.cd_vendaven", "documentoeletronicovendaven.cd_documentoeletrven", "vendapdv.dt_movimento", "vendapdv.id_vendapdv", "integracaovendaven.fl_integrado", "integracaovendaven.cd_vendapdv"],
"Hash Cond": "(vendapdv.id_vendapdv = integracaovendaven.cd_vendapdv)",
"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,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Inner",
"Startup Cost": 2.06,
"Total Cost": 4.63,
"Plan Rows": 44,
"Plan Width": 49,
"Actual Startup Time": 0.036,
"Actual Total Time": 0.059,
"Actual Rows": 45,
"Actual Loops": 1,
"Output": ["documentoeletronicovendaven.cd_vendaven", "documentoeletronicovendaven.cd_documentoeletrven", "vendapdv.dt_movimento", "vendapdv.id_vendapdv"],
"Hash Cond": "(vendapdv.id_vendapdv = documentoeletronicovendaven.cd_vendaven)",
"Shared Hit Blocks": 2,
"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": "tb_vendapdv",
"Schema": "public",
"Alias": "vendapdv",
"Startup Cost": 0.00,
"Total Cost": 1.96,
"Plan Rows": 45,
"Plan Width": 9,
"Actual Startup Time": 0.010,
"Actual Total Time": 0.022,
"Actual Rows": 46,
"Actual Loops": 1,
"Output": ["vendapdv.dt_movimento", "vendapdv.id_vendapdv"],
"Filter": "((vendapdv.dt_movimento >= '2019-11-22'::date) AND (vendapdv.dt_movimento <= '2019-11-27'::date) AND (vendapdv.cd_pdv = '1'::numeric) AND (vendapdv.cd_empresa = '1'::numeric))",
"Rows Removed by Filter": 2,
"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": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Startup Cost": 1.47,
"Total Cost": 1.47,
"Plan Rows": 47,
"Plan Width": 40,
"Actual Startup Time": 0.020,
"Actual Total Time": 0.020,
"Actual Rows": 47,
"Actual Loops": 1,
"Output": ["documentoeletronicovendaven.cd_vendaven", "documentoeletronicovendaven.cd_documentoeletrven"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 10,
"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": "tb_documentoeletrvendaven",
"Schema": "public",
"Alias": "documentoeletronicovendaven",
"Startup Cost": 0.00,
"Total Cost": 1.47,
"Plan Rows": 47,
"Plan Width": 40,
"Actual Startup Time": 0.008,
"Actual Total Time": 0.010,
"Actual Rows": 47,
"Actual Loops": 1,
"Output": ["documentoeletronicovendaven.cd_vendaven", "documentoeletronicovendaven.cd_documentoeletrven"],
"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": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Startup Cost": 1.47,
"Total Cost": 1.47,
"Plan Rows": 47,
"Plan Width": 28,
"Actual Startup Time": 0.021,
"Actual Total Time": 0.021,
"Actual Rows": 47,
"Actual Loops": 1,
"Output": ["integracaovendaven.fl_integrado", "integracaovendaven.cd_vendapdv"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 10,
"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": "tb_integracaovendaven",
"Schema": "public",
"Alias": "integracaovendaven",
"Startup Cost": 0.00,
"Total Cost": 1.47,
"Plan Rows": 47,
"Plan Width": 28,
"Actual Startup Time": 0.007,
"Actual Total Time": 0.010,
"Actual Rows": 47,
"Actual Loops": 1,
"Output": ["integracaovendaven.fl_integrado", "integracaovendaven.cd_vendapdv"],
"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": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Startup Cost": 1.47,
"Total Cost": 1.47,
"Plan Rows": 47,
"Plan Width": 66,
"Actual Startup Time": 0.021,
"Actual Total Time": 0.021,
"Actual Rows": 47,
"Actual Loops": 1,
"Output": ["documentoeletronicoven.nr_documento", "documentoeletronicoven.nr_serie", "documentoeletronicoven.cd_status", "documentoeletronicoven.dt_cadastro", "documentoeletronicoven.id_documentoeletrven"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 12,
"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": "tb_documentoeletrven",
"Schema": "public",
"Alias": "documentoeletronicoven",
"Startup Cost": 0.00,
"Total Cost": 1.47,
"Plan Rows": 47,
"Plan Width": 66,
"Actual Startup Time": 0.006,
"Actual Total Time": 0.011,
"Actual Rows": 47,
"Actual Loops": 1,
"Output": ["documentoeletronicoven.nr_documento", "documentoeletronicoven.nr_serie", "documentoeletronicoven.cd_status", "documentoeletronicoven.dt_cadastro", "documentoeletronicoven.id_documentoeletrven"],
"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": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Startup Cost": 1.47,
"Total Cost": 1.47,
"Plan Rows": 47,
"Plan Width": 126,
"Actual Startup Time": 0.022,
"Actual Total Time": 0.022,
"Actual Rows": 47,
"Actual Loops": 1,
"Output": ["documentoeletronicochaveven.tx_chave", "documentoeletronicochaveven.cd_documentoeletrven"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 12,
"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": "tb_documentoeletrchaveven",
"Schema": "public",
"Alias": "documentoeletronicochaveven",
"Startup Cost": 0.00,
"Total Cost": 1.47,
"Plan Rows": 47,
"Plan Width": 126,
"Actual Startup Time": 0.007,
"Actual Total Time": 0.011,
"Actual Rows": 47,
"Actual Loops": 1,
"Output": ["documentoeletronicochaveven.tx_chave", "documentoeletronicochaveven.cd_documentoeletrven"],
"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": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Startup Cost": 1.47,
"Total Cost": 1.47,
"Plan Rows": 47,
"Plan Width": 548,
"Actual Startup Time": 0.024,
"Actual Total Time": 0.024,
"Actual Rows": 47,
"Actual Loops": 1,
"Output": ["documentoeletronicoeventoven.cd_situacao", "documentoeletronicoeventoven.tx_motivo", "documentoeletronicoeventoven.cd_documentoeletrven"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 12,
"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": "tb_documentoeletreventoven",
"Schema": "public",
"Alias": "documentoeletronicoeventoven",
"Startup Cost": 0.00,
"Total Cost": 1.47,
"Plan Rows": 47,
"Plan Width": 548,
"Actual Startup Time": 0.008,
"Actual Total Time": 0.012,
"Actual Rows": 47,
"Actual Loops": 1,
"Output": ["documentoeletronicoeventoven.cd_situacao", "documentoeletronicoeventoven.tx_motivo", "documentoeletronicoeventoven.cd_documentoeletrven"],
"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
}
]
}
]
}
]
}
]
}
]
}
]
}
]
},
"Planning Time": 10.376,
"Triggers": [
],
"Execution Time": 0.517
}
]