#	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..83380.55 rows=5416 width=16) (actual time=2.819..27.447 rows=10 loops=1) Index Cond: (replied IS NOT NULL) Filter: (idusuario = 52364)

 Aggregate  (cost=154.10..154.12 rows=1 width=8) (actual time=27.468..27.468 rows=1 loops=1)
   ->  Limit  (cost=0.00..153.95 rows=10 width=16) (actual time=2.821..27.454 rows=10 loops=1)
         ->  Index Scan Backward using replied_idx on mail_times m  (cost=0.00..83380.55 rows=5416 width=16) (actual time=2.819..27.447 rows=10 loops=1)
               Index Cond: (replied IS NOT NULL)
               Filter: (idusuario = 52364)

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	0.014 ms	0.1 %
Index Scan Backward	1	27.447 ms	99.9 %
Limit	1	0.007 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
mail_times	1	27.447 ms	99.9 %
Index Scan Backward	1	27.447 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: bdc

Colorize:

Columns visibility:

Per node type stats

Per table stats