explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yJnS

Settings
# exclusive inclusive rows x rows loops node
1. 0.165 38.044 ↑ 109.1 213 1

Hash Join (cost=1,538.06..12,211.24 rows=23,228 width=79) (actual time=12.460..38.044 rows=213 loops=1)

  • Hash Cond: ((tb_dist_v_pos_geral_cot.cod_cot)::text = (tb_dist_mini_codcot_cpf_jn.cod_cot)::text)
2. 0.000 34.747 ↑ 109.1 213 1

Hash Join (cost=1,364.38..11,976.53 rows=23,228 width=67) (actual time=9.258..34.747 rows=213 loops=1)

  • Hash Cond: (tb_dist_mini_cod_prod_dist_custody_jn.id_instrument = tb_dist_fund_selected.id_instrument)
3. 17.686 45.454 ↑ 109.1 213 1

Gather (cost=1,276.04..11,826.88 rows=23,228 width=71) (actual time=7.762..45.454 rows=213 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 0.341 27.768 ↑ 136.3 71 3 / 3

Hash Join (cost=276.04..8,504.08 rows=9,678 width=71) (actual time=6.153..27.768 rows=71 loops=3)

  • Hash Cond: (((tb_dist_v_pos_geral_cot.cod_cot)::text = (tb_dist_mini_cod_prod_dist_custody_jn.cod_cot)::text) AND ((tb_dist_v_pos_geral_cot.cod_prod)::text = (tb_dist_mini_cod_prod_dist_custody_jn.cod_prod)::text))
5. 21.598 21.598 ↑ 1,052.3 71 3 / 3

Parallel Seq Scan on tb_dist_v_pos_geral_cot (cost=0.00..5,142.87 rows=74,710 width=49) (actual time=0.039..21.598 rows=71 loops=3)

  • Filter: (id_contract = 8)
6. 2.792 5.829 ↓ 1.0 7,756 3 / 3

Hash (cost=160.93..160.93 rows=7,674 width=29) (actual time=5.828..5.829 rows=7,756 loops=3)

  • Buckets: 8192 Batches: 1 Memory Usage: 549kB
7. 3.037 3.037 ↓ 1.0 7,756 3 / 3

Seq Scan on tb_dist_mini_cod_prod_dist_custody_jn (cost=0.00..160.93 rows=7,674 width=29) (actual time=0.036..3.037 rows=7,756 loops=3)

  • Filter: (id_contract = 8)
8. 0.172 1.455 ↓ 1.0 815 1

Hash (cost=78.17..78.17 rows=814 width=12) (actual time=1.454..1.455 rows=815 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 44kB
9. 1.283 1.283 ↓ 1.0 815 1

Seq Scan on tb_dist_fund_selected (cost=0.00..78.17 rows=814 width=12) (actual time=0.033..1.283 rows=815 loops=1)

  • Filter: (id_contract = 8)
10. 1.150 3.132 ↑ 1.0 4,427 1

Hash (cost=118.34..118.34 rows=4,427 width=22) (actual time=3.132..3.132 rows=4,427 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 318kB
11. 1.982 1.982 ↑ 1.0 4,427 1

Seq Scan on tb_dist_mini_codcot_cpf_jn (cost=0.00..118.34 rows=4,427 width=22) (actual time=0.025..1.982 rows=4,427 loops=1)

  • Filter: (id_contract = 8)
Planning time : 3.337 ms
Execution time : 50.539 ms