explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hHXg

Settings
# exclusive inclusive rows x rows loops node
1. 5,401.724 14,197.330 ↓ 1.0 1,611,686 1

Hash Join (cost=170,001.95..397,450.13 rows=1,590,371 width=125) (actual time=7,906.629..14,197.330 rows=1,611,686 loops=1)

  • 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))
  • Execution Time: 14938.735 ms(10 lignes)
2. 890.399 890.399 ↓ 1.0 1,611,686 1

Seq Scan on ct_co0122_present present (cost=0.00..49,008.84 rows=1,611,684 width=125) (actual time=0.012..890.399 rows=1,611,686 loops=1)

3. 2,245.310 7,905.207 ↓ 10.0 1,611,686 1

Hash (cost=157,511.36..157,511.36 rows=161,169 width=117) (actual time=7,905.207..7,905.207 rows=1,611,686 loops=1)

  • Buckets: 524288 (originally 262144) Batches: 4 (originally 1) Memory Usage: 64379kB
4. 4,823.072 5,659.897 ↓ 10.0 1,611,686 1

HashAggregate (cost=155,899.67..157,511.36 rows=161,169 width=117) (actual time=3,712.246..5,659.897 rows=1,611,686 loops=1)

  • Group Key: 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, bfc.ct_0000_tftr, bfc.amount, bfc.convamount, bfc.consamount, bfc.data_comment
5. 836.825 836.825 ↑ 1.0 1,611,686 1

Seq Scan on bfc_0122_v1 bfc (cost=0.00..47,110.86 rows=1,611,686 width=117) (actual time=0.006..836.825 rows=1,611,686 loops=1)

Planning time : 1.662 ms