explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BnEt

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Gather (cost=4,840.28..10,854.84 rows=34,093 width=190) (actual rows= loops=)

  • Workers Planned: 1
2. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=3,840.28..6,445.54 rows=20,055 width=190) (actual rows= loops=)

  • Hash Cond: ((exaas_entry_classification_06_sumpool.journalcode = ecritures.journalcode) AND (exaas_entry_classification_06_sumpool.ecriturenum = ecritures.ecriturenum))
3. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on exaas_entry_classification_06_sumpool (cost=0.00..2,135.31 rows=46,931 width=169) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=3136.31..3136.31 rows=46931 width=42)" -> Parallel Seq Scan on ecritures (cost=0.00..3,136.31 rows=46,931 width=42) (actual rows= loops=)