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 33,209.936 ↑ 1.0 1,000 1

Limit (cost=294,849.26..343,990.80 rows=1,000 width=1,210) (actual time=28,667.477..33,209.936 rows=1,000 loops=1)

2. 17.770 33,208.590 ↑ 73.9 7,000 1

Nested Loop Left Join (cost=0.00..25,409,568.66 rows=517,069 width=1,210) (actual time=0.022..33,208.590 rows=7,000 loops=1)

3. 17.820 17.820 ↑ 73.9 7,000 1

Seq Scan on april_sample (cost=0.00..21,656.69 rows=517,069 width=35) (actual time=0.007..17.820 rows=7,000 loops=1)

4. 33,173.000 33,173.000 ↑ 1.0 1 7,000

Index Scan using invdat_all_pkey on invdat_all (cost=0.00..49.09 rows=1 width=1,183) (actual time=4.718..4.739 rows=1 loops=7,000)

  • Index Cond: (april_sample.invno = invno)