explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8KcV

Settings
# exclusive inclusive rows x rows loops node
1. 408.269 958.373 ↓ 3.9 672,152 1

Gather (cost=4,859.38..48,359.08 rows=173,414 width=139) (actual time=33.018..958.373 rows=672,152 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 230.245 550.104 ↓ 3.1 224,051 3 / 3

Hash Left Join (cost=3,859.38..30,017.68 rows=72,256 width=139) (actual time=25.592..550.104 rows=224,051 loops=3)

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

Parallel Hash Join (cost=3,840.28..28,824.41 rows=72,256 width=98) (actual time=25.301..319.583 rows=224,051 loops=3)

  • Hash Cond: ((fec_dc.journalcode = ecritures.journalcode) AND (fec_dc.ecriturenum = ecritures.ecriturenum))
4. 60.591 60.591 ↑ 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.022..60.591 rows=224,051 loops=3)

5. 14.182 22.357 ↑ 1.8 26,594 3 / 3

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

  • Buckets: 131,072 Batches: 1 Memory Usage: 6,048kB
6. 8.175 8.175 ↑ 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.007..8.175 rows=26,594 loops=3)

7. 0.148 0.276 ↑ 1.0 627 3 / 3

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 44kB
8. 0.128 0.128 ↑ 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.128 rows=627 loops=3)