explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HtT4

Settings
# exclusive inclusive rows x rows loops node
1. 205.311 11,951.030 ↑ 1.0 1 1

Aggregate (cost=891,679.33..891,679.34 rows=1 width=40) (actual time=11,951.030..11,951.030 rows=1 loops=1)

  • Execution time: 12194.955 ms(20 registros)
2. 156.577 11,745.719 ↓ 883,867.0 883,867 1

Nested Loop (cost=386,097.40..891,679.33 rows=1 width=14) (actual time=8,462.350..11,745.719 rows=883,867 loops=1)

3. 77.342 10,705.275 ↓ 883,867.0 883,867 1

Gather (cost=386,097.25..891,679.16 rows=1 width=18) (actual time=8,462.322..10,705.275 rows=883,867 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
4. 964.727 10,627.933 ↓ 176,773.0 176,773 5 / 5

Hash Left Join (cost=385,097.25..890,679.06 rows=1 width=18) (actual time=8,589.620..10,627.933 rows=176,773 loops=5)

  • Hash Cond: ((fat.empresa_id = cv.empresa_id) AND ((fat.chavefato)::text = (cv.chavefato)::text))
  • Filter: (cv.id IS NULL)
  • Rows Removed by Filter: 682639
5. 1,166.821 1,166.821 ↓ 1.2 859,412 5 / 5

Parallel Seq Scan on vm_venda_nao_conciliada_fato_1615 fat (cost=0.00..475,345.02 rows=711,454 width=70) (actual time=0.030..1,166.821 rows=859,412 loops=5)

  • Filter: ((parcela = 1) AND (status <> ALL ('{4,6,7}'::integer[])) AND (data_venda <= CURRENT_DATE) AND (data_venda >= (CURRENT_DATE - 30)) AND (loja_id = ANY ('{8293,8294,8295,8296,8297,8298,8287,8299,8300,8301,8302,8303,8304,8305,8306,8307,8308,8309,8310,8311,8312,8313,8314,17262,8315,8316,8317,8318,8319,8320,15973,8321,8322,8323,8324,8325,8326,8327,8328,8329,8330,8331,8332,8333,8334,8335,8290,8336,9816,8337,8338,12365,8291,8339,9095,8340,8341,8342,8343,8344,8345,8346,8347,8348,8349,8350,8351,8352,8353,8354,8292,8355,8356,8357,8358,9096,8359,8360,8361,8362,8363,8364,8365,8366,8367,8368,8369,8370,8371,17665,8372,8373,8374,8375,8376,8449,8377,8378,8379,8380,8381,8382,8383,8384,8385,8386,8387,8388,8389,8390,8391,8392,8393,8394,8395,8396,8397,8398,8399,8400,8401,8402,8403,8404,8405,8406,8407,8408,8409,8410,8411,8412,8413,8414,8415,8416,8417,8418,8419,8420,8421,8422,8423,8424,8425,8426,8427,8428,8429,8430,8431,8432,8433,18094,8434,8435,8436,8437,8438,8439,8440,8441,8442,8443,8444,8445,8446,8447,8448,9097,9002,9099,9100,9101,9999,10021,12430,12565,12566,14193,14450,14451,14452,15152,15182,16402,16960,16686,16794,16795,17078,17216,17232,17233,17244,17245,17246,17247,17234,17248,17225,17229,17509,18828,10367,18880,10741,10742,9586}'::integer[])))
  • Rows Removed by Filter: 161157
6. 5,943.570 8,496.385 ↑ 1.0 10,407,777 5 / 5

Hash (cost=226,865.10..226,865.10 rows=10,548,810 width=60) (actual time=8,496.385..8,496.385 rows=10,407,777 loops=5)

  • Buckets: 16777216 Batches: 1 Memory Usage: 1108100kB
7. 2,552.815 2,552.815 ↑ 1.0 10,407,777 5 / 5

Seq Scan on vm_venda_nao_conciliada_conciliacao_vendas_1615 cv (cost=0.00..226,865.10 rows=10,548,810 width=60) (actual time=0.047..2,552.815 rows=10,407,777 loops=5)

8. 883.867 883.867 ↑ 1.0 1 883,867

Index Scan using pk_dim_rede on rede red (cost=0.14..0.16 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=883,867)

  • Index Cond: (id = fat.rede_id)
  • Filter: (pbm IS FALSE)
Planning time : 1.078 ms