explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5kY1

Settings
# exclusive inclusive rows x rows loops node
1. 241.664 776.976 ↓ 10.0 33,818 1

GroupAggregate (cost=5,358.92..11,367.78 rows=3,385 width=1,699) (actual time=521.053..776.976 rows=33,818 loops=1)

  • Group Key: balance_sheet.property_name, balance_sheet.property_id, balance_sheet.row_num, balance_sheet.sort, balance_sheet.path, balance_sheet.order_num, balance_sheet.account_number, balance_sheet.lookup_code, balance_sheet.summary_label_path, balance_sheet.cid, balance_sheet.gl_account_id, balance_sheet.name, balance_sheet.details, balance_sheet.branch_name, balance_sheet.gl_group_types
2. 457.013 535.312 ↑ 1.0 33,853 1

Sort (cost=5,358.92..5,443.55 rows=33,853 width=1,495) (actual time=520.776..535.312 rows=33,853 loops=1)

  • Sort Key: balance_sheet.property_name, balance_sheet.property_id, balance_sheet.row_num, balance_sheet.sort, balance_sheet.path, balance_sheet.order_num, balance_sheet.account_number, balance_sheet.lookup_code, balance_sheet.summary_label_path, balance_sheet.gl_account_id, balance_sheet.name, balance_sheet.details, balance_sheet.branch_name, balance_sheet.gl_group_types
  • Sort Method: quicksort Memory: 17589kB
3. 21.899 78.299 ↑ 1.0 33,853 1

Hash Join (cost=3.48..2,811.99 rows=33,853 width=1,495) (actual time=0.165..78.299 rows=33,853 loops=1)

  • Hash Cond: (balance_sheet.property_id = load_prop.property_id)
4. 30.929 56.333 ↑ 1.0 33,853 1

Hash Left Join (cost=1.60..2,344.63 rows=33,853 width=1,495) (actual time=0.085..56.333 rows=33,853 loops=1)

  • Hash Cond: ((balance_sheet.cid = us.cid) AND (balance_sheet.property_id = us.property_id))
5. 25.373 25.373 ↑ 1.0 33,853 1

Seq Scan on bs_temp balance_sheet (cost=0.00..1,898.16 rows=33,853 width=1,487) (actual time=0.039..25.373 rows=33,853 loops=1)

  • Filter: (cid = 224)
6. 0.011 0.031 ↑ 1.0 22 1

Hash (cost=1.27..1.27 rows=22 width=16) (actual time=0.031..0.031 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
7. 0.020 0.020 ↑ 1.0 22 1

Seq Scan on unit_spaces_temp us (cost=0.00..1.27 rows=22 width=16) (actual time=0.006..0.020 rows=22 loops=1)

  • Filter: (cid = 224)
8. 0.024 0.067 ↑ 1.0 39 1

Hash (cost=1.39..1.39 rows=39 width=4) (actual time=0.067..0.067 rows=39 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
9. 0.043 0.043 ↑ 1.0 39 1

Seq Scan on load_prop (cost=0.00..1.39 rows=39 width=4) (actual time=0.034..0.043 rows=39 loops=1)

Planning time : 2.388 ms