explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DRaJ : Optimization for: plan #RwJ4

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 559.755 4,221.287 ↓ 1,611,686.0 1,611,686 1

Gather (cost=96,736.55..221,624.04 rows=1 width=125) (actual time=2,531.074..4,221.287 rows=1,611,686 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Execution Time: 5109.077 ms(11 lignes)
2. 2,035.827 3,661.532 ↓ 537,229.0 537,229 3 / 3

Parallel Hash Semi Join (cost=95,736.55..220,623.94 rows=1 width=125) (actual time=2,503.537..3,661.532 rows=537,229 loops=3)

  • Hash Cond: ((present.period = bfc.period) AND (present.entity = bfc.entity) AND (present.entorig = bfc.entorig) AND (present.accnt = bfc.accnt) AND (present.flow = bfc.flow) AND (present.nature = bfc.nature) AND (present.partner = bfc.partner) AND (present.ctshare = bfc.ctshare) AND (present.curncy = bfc.curncy) AND (present.techorig = bfc.techorig) AND (present.globorig = bfc.globorig) AND (present.journal = bfc.journal) AND (present.enumber = bfc.enumber) AND (present.ct_0000_tc = bfc.ct_0000_tc) AND (present.ct_0000_axe1 = bfc.ct_0000_axe1) AND (present.ct_0000_axe2 = bfc.ct_0000_axe2) AND (present.ct_0000_axe3 = bfc.ct_0000_axe3) AND (present.ct_0000_axe4 = bfc.ct_0000_axe4) AND (present.mu = bfc.mu) AND (present.pmu = bfc.pmu) AND (present.ct_0000_zone = bfc.ct_0000_zone) AND (present.ct_0000_dest = bfc.ct_0000_dest) AND (present.ct_0000_tftr = bfc.ct_0000_tftr) AND (present.amount = bfc.amount) AND (present.convamount = bfc.convamount) AND (present.consamount = bfc.consamount) AND (present.data_comment = bfc.data_comment))
3. 369.396 369.396 ↑ 1.2 537,229 3 / 3

Parallel Seq Scan on ct_co0122_present present (cost=0.00..39,607.35 rows=671,535 width=125) (actual time=0.017..369.396 rows=537,229 loops=3)

4. 828.688 1,256.309 ↑ 1.1 537,229 3 / 3

Parallel Hash (cost=36,934.52..36,934.52 rows=594,052 width=148) (actual time=1,256.308..1,256.309 rows=537,229 loops=3)

  • Buckets: 524288 Batches: 8 Memory Usage: 35808kB
5. 427.621 427.621 ↑ 1.1 537,229 3 / 3

Parallel Seq Scan on bfc_0122_v1 bfc (cost=0.00..36,934.52 rows=594,052 width=148) (actual time=0.037..427.621 rows=537,229 loops=3)

Planning time : 1.152 ms