explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 9aK

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 13541.768 15186.643 ↑ 1.0 1000000 1

Sort (cost=1368037.04..1370547.87 rows=1004333 width=566) (actual time=14652.130..15186.643 rows=1000000 loops=1)

  • Sort Key: tmp_ap_di.fs_party
  • Sort Method: external sort Disk: 339208kB
2. 610.240 1644.875 ↑ 1.0 1000000 1

Hash Join (cost=2473.40..251810.06 rows=1004333 width=566) (actual time=32.065..1644.875 rows=1000000 loops=1)

  • Hash Cond: ((cm_ledgeritem.salesteam)::text = (tmp_ap_di.ap_tril_gid)::text)
3. 1002.603 1002.603 ↑ 1.0 1000000 1

Seq Scan on cm_ledgeritem (cost=0.00..99075.00 rows=1004333 width=500) (actual time=0.009..1002.603 rows=1000000 loops=1)

  • Filter: (fs_batchid = 1)
4. 23.429 32.032 ↑ 1.0 45351 1

Hash (cost=1197.51..1197.51 rows=45351 width=99) (actual time=32.032..32.032 rows=45351 loops=1)

5. 8.603 8.603 ↑ 1.0 45351 1

Seq Scan on tmp_ap_di (cost=0.00..1197.51 rows=45351 width=99) (actual time=0.004..8.603 rows=45351 loops=1)