explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cXik

Settings
# exclusive inclusive rows x rows loops node
1. 430.958 957.050 ↓ 3.9 672,152 1

Gather (cost=4,859.38..48,406.27 rows=173,846 width=139) (actual time=31.012..957.050 rows=672,152 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 212.823 526.092 ↓ 3.1 224,051 3 / 3

Hash Left Join (cost=3,859.38..30,021.67 rows=72,436 width=139) (actual time=24.137..526.092 rows=224,051 loops=3)

  • Hash Cond: (fec_dc.comptenum = exaas_account_classification_03_exaas_account_classification.comptenum)
3. 227.889 312.995 ↓ 3.1 224,051 3 / 3

Parallel Hash Join (cost=3,840.28..28,825.47 rows=72,436 width=98) (actual time=23.851..312.995 rows=224,051 loops=3)

  • Hash Cond: ((fec_dc.journalcode = ecritures.journalcode) AND (fec_dc.ecriturenum = ecritures.ecriturenum))
4. 62.147 62.147 ↑ 1.2 224,051 3 / 3

Parallel Seq Scan on fec_dc (cost=0.00..22,458.63 rows=280,063 width=94) (actual time=0.027..62.147 rows=224,051 loops=3)

5. 10.857 22.959 ↑ 1.8 26,594 3 / 3

Parallel Hash (cost=3,136.31..3,136.31 rows=46,931 width=25) (actual time=22.958..22.959 rows=26,594 loops=3)

  • Buckets: 131,072 Batches: 1 Memory Usage: 6,016kB
6. 12.102 12.102 ↑ 1.8 26,594 3 / 3

Parallel Seq Scan on ecritures (cost=0.00..3,136.31 rows=46,931 width=25) (actual time=0.008..12.102 rows=26,594 loops=3)

7. 0.138 0.274 ↑ 1.0 627 3 / 3

Hash (cost=11.27..11.27 rows=627 width=25) (actual time=0.274..0.274 rows=627 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 44kB
8. 0.136 0.136 ↑ 1.0 627 3 / 3

Seq Scan on exaas_account_classification_03_exaas_account_classification (cost=0.00..11.27 rows=627 width=25) (actual time=0.010..0.136 rows=627 loops=3)