explain.depesz.com

A tool for finding a real cause for slow queries.

Result: dfuB

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

Sort (cost=67029.39..67029.40 rows=1 width=465) (actual time=8.215..8.215 rows=0 loops=1)

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

Nested Loop (cost=0.00..67029.38 rows=1 width=465) (actual time=8.200..8.200 rows=0 loops=1)

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

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

4. 8.189 8.189 ↓ 0.0 0 1

Seq Scan on fs_debtitem (cost=0.00..1864.89 rows=1 width=66) (actual time=8.189..8.189 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..65093.74 rows=4997 width=399) (actual time=.. rows= loops=0)

  • Filter: (cm_ledgeritem.fs_batchid = 123123)