HTML
SOURCE
TEXT
STATS

#	exclusive	inclusive	rows x	rows	loops	node
1.	0.002	0.431	↑ 1.8	45	1	→ Limit (cost=22.32..25.52 rows=80 width=729) (actual time=0.389..0.431 rows=45 loops=1) Buffers: shared hit=8
2.	0.040	0.429	↑ 1.8	45	1	→ GroupAggregate (cost=22.32..25.52 rows=80 width=729) (actual time=0.389..0.429 rows=45 loops=1) 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 Buffers: shared hit=8
3.	0.067	0.389	↑ 1.1	72	1	→ Sort (cost=22.32..22.52 rows=80 width=704) (actual time=0.384..0.389 rows=72 loops=1) 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 Memory: 44kB Buffers: shared hit=8
4.	0.027	0.322	↑ 1.1	72	1	→ Hash Join (cost=15.76..19.79 rows=80 width=704) (actual time=0.291..0.322 rows=72 loops=1) Buffers: shared hit=8
5.	0.033	0.033	↑ 1.0	89	1	→ Seq Scan on tb_vendaitempdv vendaitempdv (cost=0..2.89 rows=89 width=12) (actual time=0.022..0.033 rows=89 loops=1) Buffers: shared hit=2
6.	0.016	0.262	↓ 1.0	45	1	→ Hash (cost=15.23..15.23 rows=43 width=737) (actual time=0.262..0.262 rows=45 loops=1) Buffers: shared hit=6
7.	0.015	0.246	↓ 1.0	45	1	→ Hash Join (cost=10.29..15.23 rows=43 width=737) (actual time=0.175..0.246 rows=45 loops=1) Buffers: shared hit=6
8.	0.049	0.207	↓ 1.0	45	1	→ Hash Join (cost=8.23..12.58 rows=43 width=269) (actual time=0.148..0.207 rows=45 loops=1) Buffers: shared hit=5
9.	0.019	0.136	↓ 1.0	45	1	→ Hash Join (cost=6.17..9.93 rows=43 width=143) (actual time=0.089..0.136 rows=45 loops=1) Buffers: shared hit=4
10.	0.016	0.096	↓ 1.0	45	1	→ Hash Join (cost=4.12..7.28 rows=43 width=77) (actual time=0.062..0.096 rows=45 loops=1) Buffers: shared hit=3
11.	0.017	0.059	↓ 1.0	45	1	→ Hash Join (cost=2.06..4.63 rows=44 width=49) (actual time=0.036..0.059 rows=45 loops=1) Buffers: shared hit=2
12.	0.022	0.022	↓ 1.0	46	1	→ Seq Scan on tb_vendapdv vendapdv (cost=0..1.96 rows=45 width=9) (actual time=0.01..0.022 rows=46 loops=1) 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)) Buffers: shared hit=1
13.	0.010	0.020	↑ 1.0	47	1	→ Hash (cost=1.47..1.47 rows=47 width=40) (actual time=0.02..0.02 rows=47 loops=1) Buffers: shared hit=1
14.	0.010	0.010	↑ 1.0	47	1	→ Seq Scan on tb_documentoeletrvendaven documentoeletronicovendaven (cost=0..1.47 rows=47 width=40) (actual time=0.008..0.01 rows=47 loops=1) Buffers: shared hit=1
15.	0.011	0.021	↑ 1.0	47	1	→ Hash (cost=1.47..1.47 rows=47 width=28) (actual time=0.021..0.021 rows=47 loops=1) Buffers: shared hit=1
16.	0.010	0.010	↑ 1.0	47	1	→ Seq Scan on tb_integracaovendaven integracaovendaven (cost=0..1.47 rows=47 width=28) (actual time=0.007..0.01 rows=47 loops=1) Buffers: shared hit=1
17.	0.010	0.021	↑ 1.0	47	1	→ Hash (cost=1.47..1.47 rows=47 width=66) (actual time=0.021..0.021 rows=47 loops=1) Buffers: shared hit=1
18.	0.011	0.011	↑ 1.0	47	1	→ Seq Scan on tb_documentoeletrven documentoeletronicoven (cost=0..1.47 rows=47 width=66) (actual time=0.006..0.011 rows=47 loops=1) Buffers: shared hit=1
19.	0.011	0.022	↑ 1.0	47	1	→ Hash (cost=1.47..1.47 rows=47 width=126) (actual time=0.022..0.022 rows=47 loops=1) Buffers: shared hit=1
20.	0.011	0.011	↑ 1.0	47	1	→ Seq Scan on tb_documentoeletrchaveven documentoeletronicochaveven (cost=0..1.47 rows=47 width=126) (actual time=0.007..0.011 rows=47 loops=1) Buffers: shared hit=1
21.	0.012	0.024	↑ 1.0	47	1	→ Hash (cost=1.47..1.47 rows=47 width=548) (actual time=0.024..0.024 rows=47 loops=1) Buffers: shared hit=1
22.	0.012	0.012	↑ 1.0	47	1	→ Seq Scan on tb_documentoeletreventoven documentoeletronicoeventoven (cost=0..1.47 rows=47 width=548) (actual time=0.008..0.012 rows=47 loops=1) Buffers: shared hit=1

Planning time	:	10.376 ms
Execution time	:	0.517 ms

[
  {
    "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
  }
]

Limit  (cost=22.32..25.52 rows=80 width=729) (actual time=0.389..0.431 rows=45 loops=1)
    Buffers: shared hit=8
  ->  GroupAggregate  (cost=22.32..25.52 rows=80 width=729) (actual time=0.389..0.429 rows=45 loops=1)
          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
          Buffers: shared hit=8
        ->  Sort  (cost=22.32..22.52 rows=80 width=704) (actual time=0.384..0.389 rows=72 loops=1)
                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 Memory: 44kB
                Buffers: shared hit=8
              ->  Hash Join  (cost=15.76..19.79 rows=80 width=704) (actual time=0.291..0.322 rows=72 loops=1)
                      Buffers: shared hit=8
                    ->  Seq Scan on tb_vendaitempdv vendaitempdv  (cost=0.00..2.89 rows=89 width=12) (actual time=0.022..0.033 rows=89 loops=1)
                            Buffers: shared hit=2
                    ->  Hash  (cost=15.23..15.23 rows=43 width=737) (actual time=0.262..0.262 rows=45 loops=1)
                            Buffers: shared hit=6
                          ->  Hash Join  (cost=10.29..15.23 rows=43 width=737) (actual time=0.175..0.246 rows=45 loops=1)
                                  Buffers: shared hit=6
                                ->  Hash Join  (cost=8.23..12.58 rows=43 width=269) (actual time=0.148..0.207 rows=45 loops=1)
                                        Buffers: shared hit=5
                                      ->  Hash Join  (cost=6.17..9.93 rows=43 width=143) (actual time=0.089..0.136 rows=45 loops=1)
                                              Buffers: shared hit=4
                                            ->  Hash Join  (cost=4.12..7.28 rows=43 width=77) (actual time=0.062..0.096 rows=45 loops=1)
                                                    Buffers: shared hit=3
                                                  ->  Hash Join  (cost=2.06..4.63 rows=44 width=49) (actual time=0.036..0.059 rows=45 loops=1)
                                                          Buffers: shared hit=2
                                                        ->  Seq Scan on tb_vendapdv vendapdv  (cost=0.00..1.96 rows=45 width=9) (actual time=0.010..0.022 rows=46 loops=1)
                                                                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))
                                                                Buffers: shared hit=1
                                                        ->  Hash  (cost=1.47..1.47 rows=47 width=40) (actual time=0.020..0.020 rows=47 loops=1)
                                                                Buffers: shared hit=1
                                                              ->  Seq Scan on tb_documentoeletrvendaven documentoeletronicovendaven  (cost=0.00..1.47 rows=47 width=40) (actual time=0.008..0.010 rows=47 loops=1)
                                                                      Buffers: shared hit=1
                                                  ->  Hash  (cost=1.47..1.47 rows=47 width=28) (actual time=0.021..0.021 rows=47 loops=1)
                                                          Buffers: shared hit=1
                                                        ->  Seq Scan on tb_integracaovendaven integracaovendaven  (cost=0.00..1.47 rows=47 width=28) (actual time=0.007..0.010 rows=47 loops=1)
                                                                Buffers: shared hit=1
                                            ->  Hash  (cost=1.47..1.47 rows=47 width=66) (actual time=0.021..0.021 rows=47 loops=1)
                                                    Buffers: shared hit=1
                                                  ->  Seq Scan on tb_documentoeletrven documentoeletronicoven  (cost=0.00..1.47 rows=47 width=66) (actual time=0.006..0.011 rows=47 loops=1)
                                                          Buffers: shared hit=1
                                      ->  Hash  (cost=1.47..1.47 rows=47 width=126) (actual time=0.022..0.022 rows=47 loops=1)
                                              Buffers: shared hit=1
                                            ->  Seq Scan on tb_documentoeletrchaveven documentoeletronicochaveven  (cost=0.00..1.47 rows=47 width=126) (actual time=0.007..0.011 rows=47 loops=1)
                                                    Buffers: shared hit=1
                                ->  Hash  (cost=1.47..1.47 rows=47 width=548) (actual time=0.024..0.024 rows=47 loops=1)
                                        Buffers: shared hit=1
                                      ->  Seq Scan on tb_documentoeletreventoven documentoeletronicoeventoven  (cost=0.00..1.47 rows=47 width=548) (actual time=0.008..0.012 rows=47 loops=1)
                                              Buffers: shared hit=1
Planning time: 10.376 ms
Execution time: 0.517 ms

Per node type stats

node type	count	sum of times	% of query
GroupAggregate	1	0.040 ms	9.3 %
Hash	6	0.070 ms	16.2 %
Hash Join	6	0.143 ms	33.2 %
Limit	1	0.002 ms	0.5 %
Seq Scan	7	0.109 ms	25.3 %
Sort	1	0.067 ms	15.5 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
tb_documentoeletrchaveven	1	0.011 ms	2.6 %
Seq Scan	1	0.011 ms	100.0 %
tb_documentoeletreventoven	1	0.012 ms	2.8 %
Seq Scan	1	0.012 ms	100.0 %
tb_documentoeletrven	1	0.011 ms	2.6 %
Seq Scan	1	0.011 ms	100.0 %
tb_documentoeletrvendaven	1	0.010 ms	2.3 %
Seq Scan	1	0.010 ms	100.0 %
tb_integracaovendaven	1	0.010 ms	2.3 %
Seq Scan	1	0.010 ms	100.0 %
tb_vendaitempdv	1	0.033 ms	7.7 %
Seq Scan	1	0.033 ms	100.0 %
tb_vendapdv	1	0.022 ms	5.1 %
Seq Scan	1	0.022 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UAQS : Removido w

Color mode:

Visible columns:

Optimization path:

Per node type stats

Per table stats