explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j8Q7 : Optimization for: plan #uN5J

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 743.294 ↑ 1.0 1 1

Aggregate (cost=244,649.77..244,649.78 rows=1 width=8) (actual time=743.292..743.294 rows=1 loops=1)

2. 20.211 759.272 ↓ 0.0 0 1

Gather (cost=146,436.16..244,649.76 rows=1 width=0) (actual time=743.214..759.272 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1.604 739.061 ↓ 0.0 0 3 / 3

Parallel Hash Semi Join (cost=145,436.16..243,649.66 rows=1 width=0) (actual time=739.060..739.061 rows=0 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))
4. 0.000 0.000 ↓ 0.0 0 / 3

Parallel Seq Scan on ct_co0122_1_present present (cost=0.00..31,240.00 rows=484,000 width=148) (never executed)

5. 405.131 737.457 ↑ 1.3 537,233 3 / 3

Parallel Hash (cost=81,225.39..81,225.39 rows=675,339 width=117) (actual time=737.456..737.457 rows=537,233 loops=3)

  • Buckets: 524288 Batches: 4 Memory Usage: 0kB
6. 332.326 332.326 ↑ 1.3 537,233 3 / 3

Parallel Seq Scan on ct_co0122_1 bfc (cost=0.00..81,225.39 rows=675,339 width=117) (actual time=20.827..332.326 rows=537,233 loops=3)

Planning time : 1.694 ms
Execution time : 759.483 ms