explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 0U7

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 9972.569 11330.452 ↓ 0.0 0 1

Update on alldat_nl (cost=0.00..40973.83 rows=10561 width=303) (actual time=11330.452..11330.452 rows=0 loops=1)

2. 0.289 1357.883 ↑ 88.7 119 1

Nested Loop (cost=0.00..40973.83 rows=10561 width=303) (actual time=83.075..1357.883 rows=119 loops=1)

3. 0.019 0.019 ↑ 87.3 15 1

Seq Scan on tmp_ip (cost=0.00..23.10 rows=1310 width=38) (actual time=0.005..0.019 rows=15 loops=1)

4. 1357.575 1357.575 ↑ 1.0 8 15

Index Scan using idx_alldat_nl_client_ip on alldat_nl (cost=0.00..31.16 rows=8 width=304) (actual time=5.535..90.505 rows=8 loops=15)

  • Index Cond: (client_ip = tmp_ip.client_ip)