explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RCKs

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

Hash Join (cost=170,001.95..397,450.13 rows=1,590,371 width=125) (actual time=7,950.892..14,112.122 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: 14855.400 ms(10 lignes)
2. 899.433 899.433 ↓ 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.021..899.433 rows=1,611,686 loops=1)

3. 2,263.068 7,949.419 ↓ 10.0 1,611,686 1

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

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

HashAggregate (cost=155,899.67..157,511.36 rows=161,169 width=117) (actual time=3,707.241..5,686.351 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. 837.175 837.175 ↑ 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.008..837.175 rows=1,611,686 loops=1)

Planning time : 2.349 ms