explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iZFT

Settings
# exclusive inclusive rows x rows loops node
1. 1,244.546 7,000.776 ↓ 4.6 79,783 1

GroupAggregate (cost=73,078.82..2,465,982.34 rows=17,500 width=1,688) (actual time=3,657.561..7,000.776 rows=79,783 loops=1)

  • Group Key: fec_dc.journalcode, fec_dc.ecriturenum
2. 1,547.131 5,756.230 ↓ 1.1 193,429 1

GroupAggregate (cost=73,078.82..121,642.15 rows=175,003 width=74) (actual time=3,657.467..5,756.230 rows=193,429 loops=1)

  • Group Key: fec_dc.journalcode, fec_dc.ecriturenum, exaas_account_classification_03_exaas_account_classification.account_class_name
3. 2,683.039 4,209.099 ↓ 3.8 672,152 1

Sort (cost=73,078.82..73,516.33 rows=175,003 width=51) (actual time=3,657.385..4,209.099 rows=672,152 loops=1)

  • Sort Key: fec_dc.journalcode, fec_dc.ecriturenum, exaas_account_classification_03_exaas_account_classification.account_class_name
  • Sort Method: external merge Disk: 40,640kB
4. 389.580 1,526.060 ↓ 3.8 672,152 1

Hash Left Join (cost=5,226.68..51,853.66 rows=175,003 width=51) (actual time=48.138..1,526.060 rows=672,152 loops=1)

  • Hash Cond: (fec_dc.comptenum = exaas_account_classification_03_exaas_account_classification.comptenum)
5. 718.886 1,136.218 ↓ 3.8 672,152 1

Hash Join (cost=5,207.57..49,428.26 rows=175,003 width=40) (actual time=47.868..1,136.218 rows=672,152 loops=1)

  • Hash Cond: ((fec_dc.journalcode = ecritures.journalcode) AND (fec_dc.ecriturenum = ecritures.ecriturenum))
6. 369.528 369.528 ↑ 1.0 672,152 1

Seq Scan on fec_dc (cost=0.00..26,379.52 rows=672,152 width=36) (actual time=0.024..369.528 rows=672,152 loops=1)

7. 29.227 47.804 ↑ 1.0 79,783 1

Hash (cost=3,464.83..3,464.83 rows=79,783 width=25) (actual time=47.804..47.804 rows=79,783 loops=1)

  • Buckets: 65,536 Batches: 2 Memory Usage: 2,756kB
8. 18.577 18.577 ↑ 1.0 79,783 1

Seq Scan on ecritures (cost=0.00..3,464.83 rows=79,783 width=25) (actual time=0.005..18.577 rows=79,783 loops=1)

9. 0.142 0.262 ↑ 1.0 627 1

Hash (cost=11.27..11.27 rows=627 width=25) (actual time=0.262..0.262 rows=627 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 44kB
10. 0.120 0.120 ↑ 1.0 627 1

Seq Scan on exaas_account_classification_03_exaas_account_classification (cost=0.00..11.27 rows=627 width=25) (actual time=0.008..0.120 rows=627 loops=1)