explain.depesz.com

A tool for finding a real cause for slow queries.

Result: ZvM

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 503.261 1,861.708 ↓ 1.0 1,000,000 1

Hash Join (cost=94,073.96..341,084.23 rows=980,110 width=566) (actual time=529.319..1,861.708 rows=1,000,000 loops=1)

  • Hash Cond: ((cm_ledgeritem.salesteam)::text = (fs_agrperson.tril_gid)::text)
2. 829.160 829.160 ↓ 1.0 1,000,000 1

Seq Scan on cm_ledgeritem (cost=0.00..99,075.12 rows=998,405 width=500) (actual time=0.010..829.160 rows=1,000,000 loops=1)

  • Filter: (fs_batchid = 1)
3. 23.748 529.287 ↓ 1.0 45,351 1

Hash (cost=92,821.46..92,821.46 rows=44,520 width=99) (actual time=529.287..529.287 rows=45,351 loops=1)

4. 54.790 505.539 ↓ 1.0 45,351 1

Hash Join (cost=2,886.40..92,821.46 rows=44,520 width=99) (actual time=121.001..505.539 rows=45,351 loops=1)

  • Hash Cond: ((fs_debtitem.fs_party)::text = (fs_agrperson.fs_party)::text)
5. 396.277 396.277 ↓ 1.0 45,351 1

Seq Scan on fs_debtitem (cost=0.00..87,468.66 rows=44,520 width=66) (actual time=66.387..396.277 rows=45,351 loops=1)

  • Filter: (fs_annualize = 0)
6. 19.645 54.472 ↑ 1.0 45,351 1

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

7. 34.827 34.827 ↑ 1.0 45,351 1

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