explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pxUj

Settings
# exclusive inclusive rows x rows loops node
1. 161.087 2,211.752 ↓ 629.0 629 1

GroupAggregate (cost=250,348.78..250,855.39 rows=1 width=136) (actual time=2,200.744..2,211.752 rows=629 loops=1)

  • Group Key: exaas_entry_classification_07_mvtsparpool.line_number
  • Filter: (count(DISTINCT exaas_entry_classification_07_mvtsparpool.account_class_name) = 1)
  • Rows Removed by Filter: 79,154
2. 135.490 2,050.665 ↓ 2.9 193,429 1

Sort (cost=250,348.78..250,516.82 rows=67,215 width=19) (actual time=2,008.617..2,050.665 rows=193,429 loops=1)

  • Sort Key: exaas_entry_classification_07_mvtsparpool.line_number
  • Sort Method: external merge Disk: 5,456kB
3. 39.965 1,915.175 ↓ 2.9 193,429 1

Subquery Scan on exaas_entry_classification_07_mvtsparpool (cost=0.42..244,959.32 rows=67,215 width=19) (actual time=0.112..1,915.175 rows=193,429 loops=1)

4. 1,600.974 1,875.210 ↓ 2.9 193,429 1

GroupAggregate (cost=0.42..244,287.17 rows=67,215 width=71) (actual time=0.112..1,875.210 rows=193,429 loops=1)

  • Group Key: exaas_entry_classification_01_mvtsecrituresaccountclass.journalcode, exaas_entry_classification_01_mvtsecrituresaccountclass.ecriturenum, exaas_entry_classification_01_mvtsecrituresaccountclass.account_class_name
5. 274.236 274.236 ↑ 1.0 672,152 1

Index Scan using xs_ntr_clssfctn_01_mvtscrtrsccntclss_jrnlcdcrtrnmccnt_clss_nm_n on exaas_entry_classification_01_mvtsecrituresaccountclass (cost=0.42..70,535.88 rows=672,152 width=39) (actual time=0.061..274.236 rows=672,152 loops=1)