explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vBt6

Settings
# exclusive inclusive rows x rows loops node
1. 245.917 12,273.170 ↓ 0.0 0 1

Gather (cost=442,827.89..580,399.01 rows=5,818 width=149) (actual time=12,252.109..12,273.170 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Execution Time: 12300.933 ms(19 lignes)
2. 2,314.907 12,027.253 ↓ 0.0 0 3 / 3

Merge Anti Join (cost=441,827.89..578,817.21 rows=2,424 width=149) (actual time=12,027.252..12,027.253 rows=0 loops=3)

  • Merge Cond: ((bfc.ct_0000_tftr = present.ct_0000_tftr) AND (bfc.period = present.period) AND (bfc.entity = present.entity) AND (bfc.entorig = present.entorig) AND (bfc.accnt = present.accnt) AND (bfc.flow = present.flow) AND (bfc.nature = present.nature) AND (bfc.partner = present.partner) AND (bfc.ctshare = present.ctshare) AND (bfc.curncy = present.curncy) AND (bfc.techorig = present.techorig) AND (bfc.globorig = present.globorig) AND (bfc.journal = present.journal) AND (bfc.enumber = present.enumber) AND (bfc.ct_0000_tc = present.ct_0000_tc) AND (bfc.ct_0000_axe1 = present.ct_0000_axe1) AND (bfc.ct_0000_axe2 = present.ct_0000_axe2) AND (bfc.ct_0000_axe3 = present.ct_0000_axe3) AND (bfc.ct_0000_axe4 = present.ct_0000_axe4) AND (bfc.mu = present.mu) AND (bfc.pmu = present.pmu) AND (bfc.ct_0000_zone = present.ct_0000_zone) AND (bfc.ct_0000_dest = present.ct_0000_dest))
3. 1,888.531 2,222.616 ↑ 1.2 537,229 3 / 3

Sort (cost=144,021.82..145,700.66 rows=671,536 width=117) (actual time=1,837.838..2,222.616 rows=537,229 loops=3)

  • Sort Key: bfc.ct_0000_tftr, bfc.period, bfc.entity, bfc.entorig, bfc.accnt, bfc.flow, bfc.nature, bfc.partner, bfc.ctshare, bfc.curncy, bfc.techorig, bfc.globorig, bfc.journal, bfc.enumber, bfc.ct_0000_tc, bfc.ct_0000_axe1, bfc.ct_0000_axe2, bfc.ct_0000_axe3, bfc.ct_0000_axe4, bfc.mu, bfc.pmu, bfc.ct_0000_zone, bfc.ct_0000_dest
  • Sort Method: external merge Disk: 68736kB
  • Worker 0: Sort Method: external merge Disk: 69848kB
  • Worker 1: Sort Method: external merge Disk: 68032kB
4. 334.085 334.085 ↑ 1.2 537,229 3 / 3

Parallel Seq Scan on bfc_0122_v1 bfc (cost=0.00..37,709.36 rows=671,536 width=117) (actual time=0.014..334.085 rows=537,229 loops=3)

5. 6,208.824 7,489.730 ↑ 1.0 1,611,674 3 / 3

Sort (cost=297,806.07..301,835.28 rows=1,611,684 width=92) (actual time=5,601.501..7,489.730 rows=1,611,674 loops=3)

  • Sort Key: present.ct_0000_tftr, present.period, present.entity, present.entorig, present.accnt, present.flow, present.nature, present.partner, present.ctshare, present.curncy, present.techorig, present.globorig, present.journal, present.enumber, present.ct_0000_tc, present.ct_0000_axe1, present.ct_0000_axe2, present.ct_0000_axe3, present.ct_0000_axe4, present.mu, present.pmu, present.ct_0000_zone, present.ct_0000_dest
  • Sort Method: external merge Disk: 160864kB
  • Worker 0: Sort Method: external merge Disk: 160864kB
  • Worker 1: Sort Method: external merge Disk: 160864kB
6. 1,280.906 1,280.906 ↓ 1.0 1,611,686 3 / 3

Seq Scan on ct_co0122_present present (cost=0.00..49,008.84 rows=1,611,684 width=92) (actual time=0.048..1,280.906 rows=1,611,686 loops=3)

Planning time : 1.169 ms