explain.depesz.com

A tool for finding a real cause for slow queries.

Result: vtYM

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

Merge Join (cost=3868768.51..3928996.42 rows=4000077 width=413) (actual time=.. rows= loops=)

  • Merge Cond: ((fs_debtitem.fs_party)::text = (fs_agrperson.fs_party)::text)
2. 0.000 0.000 ↓ 0.0

Sort (cost=7234.53..7347.90 rows=45351 width=66) (actual time=.. rows= loops=)

  • Sort Key: fs_debtitem.fs_party
3. 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)
4. 0.000 0.000 ↓ 0.0

Materialize (cost=3861533.98..3911534.94 rows=4000077 width=380) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0

Sort (cost=3861533.98..3871534.17 rows=4000077 width=380) (actual time=.. rows= loops=)

  • Sort Key: fs_agrperson.fs_party
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=2890.40..633771.61 rows=4000077 width=380) (actual time=.. rows= loops=)

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

Seq Scan on cm_ledgeritem (cost=0.00..198151.96 rows=4000077 width=347) (actual time=.. rows= loops=)

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

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

9. 0.000 0.000 ↓ 0.0

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