explain.depesz.com

A tool for finding a real cause for slow queries.

Result: mw6

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=97,980.07..97,996.88 rows=6,721 width=465) (actual time=.. rows= loops=)

  • Sort Key: fs_debtitem.fs_party
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=5,854.17..96,128.31 rows=6,721 width=465) (actual time=.. rows= loops=)

  • Hash Cond: ((fs_agrperson.fs_party)::text = (fs_debtitem.fs_party)::text)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,890.40..91,773.31 rows=6,721 width=432) (actual time=.. rows= loops=)

  • Hash Cond: ((cm_ledgeritem.salesteam)::text = (fs_agrperson.tril_gid)::text)
4. 0.000 0.000 ↓ 0.0

Seq Scan on cm_ledgeritem (cost=0.00..87,545.70 rows=6,721 width=399) (actual time=.. rows= loops=)

  • Filter: (fs_batchid = 0)
5. 0.000 0.000 ↓ 0.0

Hash (cost=1,791.51..1,791.51 rows=45,351 width=66) (actual time=.. rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on fs_agrperson (cost=0.00..1,791.51 rows=45,351 width=66) (actual time=.. rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=1,864.89..1,864.89 rows=45,351 width=66) (actual time=.. rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on fs_debtitem (cost=0.00..1,864.89 rows=45,351 width=66) (actual time=.. rows= loops=)

  • Filter: (fs_annualize = 0)