explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PNmg

Settings
# exclusive inclusive rows x rows loops node
1. 17.825 1,603,322.788 ↑ 974.2 169 1

Gather (cost=27,376.76..670,012.51 rows=164,636 width=12) (actual time=7,377.221..1,603,322.788 rows=169 loops=1)

  • Workers Planned: 4
  • Params Evaluated: $0
  • Workers Launched: 0
2.          

Initplan (for Gather)

3. 0.101 0.101 ↑ 1.0 1 1

Seq Scan on tb_parametro tp (cost=0.00..19.36 rows=1 width=4) (actual time=0.101..0.101 rows=1 loops=1)

  • Filter: ((nm_variavel)::text = 'parametroDataCrow'::text)
  • Rows Removed by Filter: 507
4. 338.564 1,603,304.862 ↑ 243.5 169 1

Nested Loop (cost=26,357.40..652,529.55 rows=41,159 width=12) (actual time=7,376.259..1,603,304.862 rows=169 loops=1)

5. 750.724 1,399,226.548 ↓ 2.6 320,850 1

Nested Loop (cost=26,356.96..569,680.48 rows=125,047 width=8) (actual time=1,365.914..1,399,226.548 rows=320,850 loops=1)

6. 917.600 1,102,652.124 ↓ 2.6 320,850 1

Parallel Hash Join (cost=26,356.40..454,614.16 rows=125,047 width=4) (actual time=1,365.244..1,102,652.124 rows=320,850 loops=1)

  • Hash Cond: ((pd.id_processo)::integer = (p.id_processo)::integer)
7. 1,100,388.067 1,100,388.067 ↓ 4.2 595,878 1

Parallel Index Scan using idx_tb_processo_documento9 on tb_processo_documento pd (cost=0.56..427,887.36 rows=141,318 width=8) (actual time=6.280..1,100,388.067 rows=595,878 loops=1)

  • Index Cond: (dt_juntada IS NULL)
8. 369.235 1,346.457 ↓ 3.1 1,109,659 1

Parallel Hash (cost=21,888.18..21,888.18 rows=357,413 width=4) (actual time=1,346.456..1,346.457 rows=1,109,659 loops=1)

  • Buckets: 2,097,152 Batches: 1 Memory Usage: 59,808kB
9. 977.222 977.222 ↓ 3.1 1,109,659 1

Parallel Seq Scan on tb_processo p (cost=0.00..21,888.18 rows=357,413 width=4) (actual time=2.466..977.222 rows=1,109,659 loops=1)

  • Filter: (nr_processo IS NOT NULL)
  • Rows Removed by Filter: 143,011
10. 295,823.700 295,823.700 ↑ 1.0 1 320,850

Index Only Scan using sys_c005815 on tb_processo_documento_bin bin (cost=0.56..0.92 rows=1 width=4) (actual time=0.922..0.922 rows=1 loops=320,850)

  • Index Cond: (id_processo_documento_bin = (pd.id_processo_documento_bin)::integer)
  • Heap Fetches: 3,861
11. 203,739.750 203,739.750 ↓ 0.0 0 320,850

Index Scan using idx_tb_processo_documento_bin_pessoa_assinatura1 on tb_proc_doc_bin_pess_assin ass (cost=0.44..0.65 rows=1 width=12) (actual time=0.635..0.635 rows=0 loops=320,850)

  • Index Cond: ((id_processo_documento_bin)::integer = (bin.id_processo_documento_bin)::integer)
  • Filter: ((dt_assinatura IS NOT NULL) AND (ds_assinatura IS NOT NULL) AND (ds_cert_chain IS NOT NULL) AND ((dt_assinatura)::timestamp without time zone > $0) AND (ds_assinatura <> ''::text) AND (ds_cert_chain <> ''::text))
  • Rows Removed by Filter: 0