explain.depesz.com

A tool for finding a real cause for slow queries.

Result: bdc

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

Aggregate (cost=154.10..154.12 rows=1 width=8) (actual time=27.468..27.468 rows=1 loops=1)

2. 0.007 27.454 ↑ 1.0 10 1

Limit (cost=0.00..153.95 rows=10 width=16) (actual time=2.821..27.454 rows=10 loops=1)

3. 27.447 27.447 ↑ 541.6 10 1

Index Scan Backward using replied_idx on mail_times m (cost=0.00..83,380.55 rows=5,416 width=16) (actual time=2.819..27.447 rows=10 loops=1)

  • Index Cond: (replied IS NOT NULL)
  • Filter: (idusuario = 52364)