explain.depesz.com

A tool for finding a real cause for slow queries.

Result: nUw

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

Limit (cost=294849.26..343990.80 rows=1000 width=1210) (actual time=28667.477..33209.936 rows=1000 loops=1)

2. 17.770 33208.590 ↑ 73.9 7000 1

Nested Loop Left Join (cost=0.00..25409568.66 rows=517069 width=1210) (actual time=0.022..33208.590 rows=7000 loops=1)

3. 17.820 17.820 ↑ 73.9 7000 1

Seq Scan on april_sample (cost=0.00..21656.69 rows=517069 width=35) (actual time=0.007..17.820 rows=7000 loops=1)

4. 33173.000 33173.000 ↑ 1.0 1 7000

Index Scan using invdat_all_pkey on invdat_all (cost=0.00..49.09 rows=1 width=1183) (actual time=4.718..4.739 rows=1 loops=7000)

  • Index Cond: (april_sample.invno = invno)