explain.depesz.com

A tool for finding a real cause for slow queries.

Result: mw6

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

Sort (cost=97980.07..97996.88 rows=6721 width=465) (actual time=.. rows= loops=)

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

Hash Join (cost=5854.17..96128.31 rows=6721 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=2890.40..91773.31 rows=6721 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..87545.70 rows=6721 width=399) (actual time=.. rows= loops=)

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

Hash (cost=1791.51..1791.51 rows=45351 width=66) (actual time=.. rows= loops=)

6. 0.000 0.000 ↓ 0.0
→

Seq Scan on fs_agrperson (cost=0.00..1791.51 rows=45351 width=66) (actual time=.. rows= loops=)

7. 0.000 0.000 ↓ 0.0
→

Hash (cost=1864.89..1864.89 rows=45351 width=66) (actual time=.. rows= loops=)

8. 0.000 0.000 ↓ 0.0
→

Seq Scan on fs_debtitem (cost=0.00..1864.89 rows=45351 width=66) (actual time=.. rows= loops=)

  • Filter: (fs_annualize = 0)