Result: iQi

options

HTML
TEXT
STATS

exclusive	inclusive	rows x	rows	loops	node
0.000	0.000	↓ 0.0			→ Aggregate (cost=44.00..44.01 rows=1 width=0) (actual time=.. rows= loops=)
0.000	0.000	↓ 0.0			→ Nested Loop (cost=0.00..44.00 rows=1 width=0) (actual time=.. rows= loops=)
0.000	0.000	↓ 0.0			→ Index Scan using pk_tracked_units on tracked_unit tu (cost=0.00..8.27 rows=1 width=4) (actual time=.. rows= loops=) Index Cond: (id = 303) Filter: (account_id = 2)
0.000	0.000	↓ 0.0			→ Index Scan using dsh_local_time_idx on dev_status_history dsh (cost=0.00..35.72 rows=1 width=4) (actual time=.. rows= loops=) Index Cond: ((dsh.local_time >= '2012-01-31 00:00:00'::timestamp without time zone) AND (dsh.local_time <= '2012-01-31 23:00:00'::timestamp without time zone)) Filter: (dsh.unit_id = 303)

"Aggregate  (cost=44.00..44.01 rows=1 width=0)"
"  ->  Nested Loop  (cost=0.00..44.00 rows=1 width=0)"
"        ->  Index Scan using pk_tracked_units on tracked_unit tu  (cost=0.00..8.27 rows=1 width=4)"
"              Index Cond: (id = 303)"
"              Filter: (account_id = 2)"
"        ->  Index Scan using dsh_local_time_idx on dev_status_history dsh  (cost=0.00..35.72 rows=1 width=4)"
"              Index Cond: ((dsh.local_time >= '2012-01-31 00:00:00'::timestamp without time zone) AND (dsh.local_time <= '2012-01-31 23:00:00'::timestamp without time zone))"
"              Filter: (dsh.unit_id = 303)"

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	0.000 ms	0.0 %
Index Scan	2	0.000 ms	0.0 %
Nested Loop	1	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
dev_status_history	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
tracked_unit	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: iQi

Colorize:

Columns visibility:

Per node type stats

Per table stats