explain.depesz.com

A tool for finding a real cause for slow queries.

Result: CJ7

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

Limit (cost=46565.00..109072.33 rows=5000000 width=99) (actual time=2066.575..3904.772 rows=5000000 loops=1)

2. 2477.109 3392.995 ↑ 199893.2 5000000 1

Hash Join (cost=46565.00..12494838900.04 rows=999466157905 width=99) (actual time=2066.573..3392.995 rows=5000000 loops=1)

  • Hash Cond: ((tmp_ap_di.ap_tril_gid)::text = (tmp_cm_ledgeritem.salesteam)::text)
3. 390.255 390.255 ↓ 1.0 2000000 1

Seq Scan on tmp_ap_di (cost=0.00..52786.99 rows=1999999 width=99) (actual time=0.006..390.255 rows=2000000 loops=1)

4. 401.691 525.631 ↑ 1.0 1000000 1

Hash (cost=22346.00..22346.00 rows=1000000 width=66) (actual time=525.631..525.631 rows=1000000 loops=1)

5. 123.940 123.940 ↑ 1.0 1000000 1

Seq Scan on tmp_cm_ledgeritem (cost=0.00..22346.00 rows=1000000 width=66) (actual time=0.012..123.940 rows=1000000 loops=1)