explain.depesz.com

A tool for finding a real cause for slow queries.

Result: rdF

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

Sort (cost=64270.84..64270.85 rows=1 width=498) (actual time=39.765..39.765 rows=0 loops=1)

  • Sort Key: fs_agrperson.fs_party
  • Sort Method: quicksort Memory: 17kB
2. 0.005 39.712 ↓ 0.0 0 1

Nested Loop (cost=0.00..64270.83 rows=1 width=498) (actual time=39.712..39.712 rows=0 loops=1)

  • Join Filter: ((fs_agrperson.tril_gid)::text = (cm_ledgeritem.salesteam)::text)
3. 0.006 39.707 ↓ 0.0 0 1

Nested Loop (cost=0.00..1873.18 rows=1 width=132) (actual time=39.707..39.707 rows=0 loops=1)

4. 39.701 39.701 ↓ 0.0 0 1

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

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

Index Scan using idx_fsap_party on fs_agrperson (cost=0.00..8.28 rows=1 width=66) (actual time=.. rows= loops=0)

  • Index Cond: ((fs_agrperson.fs_party)::text = (fs_debtitem.fs_party)::text)
6. 0.000 0.000 ↓ 0.0 0

Seq Scan on cm_ledgeritem (cost=0.00..62337.82 rows=4786 width=399) (actual time=.. rows= loops=0)

  • Filter: (cm_ledgeritem.fs_batchid = 123123)