explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Ogq

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

Limit (cost=46,565.00..109,072.33 rows=5,000,000 width=99) (actual time=2,109.387..3,947.085 rows=5,000,000 loops=1)

2. 2,521.872 3,434.002 ↑ 199,893.2 5,000,000 1

Hash Join (cost=46,565.00..12,494,838,900.04 rows=999,466,157,905 width=99) (actual time=2,109.385..3,434.002 rows=5,000,000 loops=1)

  • Hash Cond: ((tmp_ap_di.ap_tril_gid)::text = (tmp_cm_ledgeritem.salesteam)::text)
3. 389.353 389.353 ↓ 1.0 2,000,000 1

Seq Scan on tmp_ap_di (cost=0.00..52,786.99 rows=1,999,999 width=99) (actual time=0.005..389.353 rows=2,000,000 loops=1)

4. 401.168 522.777 ↑ 1.0 1,000,000 1

Hash (cost=22,346.00..22,346.00 rows=1,000,000 width=66) (actual time=522.777..522.777 rows=1,000,000 loops=1)

5. 121.609 121.609 ↑ 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..121.609 rows=1,000,000 loops=1)