explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uN5J

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 2,227.619 ↑ 1.0 1 1

Aggregate (cost=551,928.17..551,928.18 rows=1 width=8) (actual time=2,227.618..2,227.619 rows=1 loops=1)

2. 13.893 2,237.684 ↓ 0.0 0 1

Gather (cost=1,000.55..551,928.17 rows=1 width=0) (actual time=2,227.611..2,237.684 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,342.838 2,223.791 ↓ 0.0 0 3 / 3

Nested Loop (cost=0.56..550,928.07 rows=1 width=0) (actual time=2,223.790..2,223.791 rows=0 loops=3)

4. 343.720 343.720 ↑ 1.3 537,233 3 / 3

Parallel Seq Scan on ct_co0122_1_present present (cost=0.00..33,115.42 rows=671,542 width=117) (actual time=0.015..343.720 rows=537,233 loops=3)

5. 537.233 537.233 ↓ 0.0 0 1,611,700 / 3

Index Scan using index_ct_co0122_1 on ct_co0122_1 bfc (cost=0.56..0.76 rows=1 width=117) (actual time=0.001..0.001 rows=0 loops=1,611,700)

  • Index Cond: ((period = present.period) AND (entity = present.entity) AND (entorig = present.entorig) AND (accnt = present.accnt) AND (flow = present.flow) AND (nature = present.nature) AND (partner = present.partner) AND (ctshare = present.ctshare) AND (curncy = present.curncy) AND (techorig = present.techorig) AND (globorig = present.globorig) AND (journal = present.journal) AND (enumber = present.enumber) AND (ct_0000_tc = present.ct_0000_tc) AND (ct_0000_axe1 = present.ct_0000_axe1) AND (ct_0000_axe2 = present.ct_0000_axe2) AND (ct_0000_axe3 = present.ct_0000_axe3) AND (ct_0000_axe4 = present.ct_0000_axe4) AND (mu = present.mu) AND (pmu = present.pmu) AND (ct_0000_zone = present.ct_0000_zone) AND (ct_0000_dest = present.ct_0000_dest) AND (ct_0000_tftr = present.ct_0000_tftr))
  • Filter: ((present.amount = amount) AND (present.convamount = convamount) AND (present.consamount = consamount) AND (present.data_comment = data_comment))
Planning time : 1.507 ms
Execution time : 2,237.810 ms