explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oPmE

Settings
# exclusive inclusive rows x rows loops node
1. 2,017.132 14,565.995 ↓ 1.6 3,633,041 1

Hash Join (cost=865,561.44..1,130,314.84 rows=2,342,410 width=75) (actual time=11,743.373..14,565.995 rows=3,633,041 loops=1)

  • Hash Cond: (ecrituresallinfo0_1.id_ecritures = ecrituresclasseesuniques.ecritures_autoid)
2. 810.564 810.564 ↑ 1.0 4,683,312 1

Seq Scan on ecrituresallinfo0_1 (cost=0.00..204,415.79 rows=4,684,820 width=43) (actual time=0.010..810.564 rows=4,683,312 loops=1)

  • Filter: (montant_pool_tiers IS DISTINCT FROM '0'::numeric)
  • Rows Removed by Filter: 14177
3. 665.406 11,738.299 ↑ 1.0 3,633,815 1

Hash (cost=819,294.64..819,294.64 rows=3,701,344 width=4) (actual time=11,738.299..11,738.299 rows=3,633,815 loops=1)

  • Buckets: 4194304 Batches: 1 Memory Usage: 160520kB
4. 339.917 11,072.893 ↑ 1.0 3,633,815 1

Subquery Scan on ecrituresclasseesuniques (cost=0.56..819,294.64 rows=3,701,344 width=4) (actual time=0.089..11,072.893 rows=3,633,815 loops=1)

5. 6,539.736 10,732.976 ↑ 1.0 3,633,815 1

GroupAggregate (cost=0.56..782,281.20 rows=3,701,344 width=40) (actual time=0.087..10,732.976 rows=3,633,815 loops=1)

  • Group Key: ecrituresclassees.ecritures_autoid
  • Filter: ((first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Unclassified entries'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'VAT invoice only'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Suppliers - Accrued invoices'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Suppliers - CN'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Suppliers - Invoice'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Assets - Invoice'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Assets - CN'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Suppliers – Reversed accrued invoices'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Down payment reversed'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Supplier to Income'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Expense Reports'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Customer - Invoice'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Cash to Expenses'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Capital accounts'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Supplier to State'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Supplier to Deposit'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'VAT to expenses'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Intercompany to PL'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Customer - CN'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Cash to Income'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Depreciation'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Conversions losses or gains'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'State to PL'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Down payment'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Staff to Cash'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Staff costs'::text) OR (first(ecrituresclassees.class_name ORDER BY ecrituresclassees.priority) = 'Cut off'::text))
  • Rows Removed by Filter: 1063674
6. 4,193.240 4,193.240 ↓ 1.0 5,165,298 1

Index Scan using pk_ecrituresclassees on ecrituresclassees (cost=0.56..383,764.10 rows=5,164,338 width=29) (actual time=0.047..4,193.240 rows=5,165,298 loops=1)

Planning time : 1.003 ms