explain.depesz.com

A tool for finding a real cause for slow queries.

Result: hXC

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

Hash Join (cost=2,473.40..68,966.40 rows=1,000,000 width=99) (actual time=33.936..580.644 rows=1,000,000 loops=1)

  • Hash Cond: ((tmp_cm_ledgeritem.salesteam)::text = (tmp_ap_di.ap_tril_gid)::text)
2. 119.870 119.870 ↑ 1.0 1,000,000 1

Seq Scan on tmp_cm_ledgeritem (cost=0.00..22,346.00 rows=1,000,000 width=66) (actual time=0.014..119.870 rows=1,000,000 loops=1)

3. 24.523 33.899 ↑ 1.0 45,351 1

Hash (cost=1,197.51..1,197.51 rows=45,351 width=99) (actual time=33.899..33.899 rows=45,351 loops=1)

4. 9.376 9.376 ↑ 1.0 45,351 1

Seq Scan on tmp_ap_di (cost=0.00..1,197.51 rows=45,351 width=99) (actual time=0.002..9.376 rows=45,351 loops=1)