#	exclusive	inclusive	rows x	rows	loops	node
1.	0.225	68724.502	↑ 75.1	24	1	→ Sort (cost=342033.45..342037.95 rows=1802 width=63) (actual time=68724.458..68724.502 rows=24 loops=1) Output: mondetails_recent.serverid, mondetails_recent.vmid, (max(todecimal(mondetails_recent.sv1))), mondetails_recent.mid Sort Key: (max(todecimal(mondetails_recent.sv1))) Sort Method: quicksort Memory: 20kB
2.	26610.473	68724.277	↑ 75.1	24	1	→ HashAggregate (cost=341462.98..341936.00 rows=1802 width=63) (actual time=68724.215..68724.277 rows=24 loops=1) Output: mondetails_recent.serverid, mondetails_recent.vmid, max(todecimal(mondetails_recent.sv1)), mondetails_recent.mid
3.	11134.325	42113.804	↑ 1.1	1780334	1	→ Hash Join (cost=1.30..322365.23 rows=1909775 width=63) (actual time=12.942..42113.804 rows=1780334 loops=1) Output: mondetails_recent.serverid, mondetails_recent.vmid, mondetails_recent.sv1, mondetails_recent.mid Hash Cond: ((mondetails_recent.serverid)::text = (hosts.guid)::text)
4.	30979.403	30979.403	↑ 1.1	1780334	1	→ Seq Scan on public.mondetails_recent (cost=0.00..296104.52 rows=1909775 width=63) (actual time=12.814..30979.403 rows=1780334 loops=1) Output: mondetails_recent.mid, mondetails_recent.serverid, mondetails_recent.vmid, mondetails_recent.slapolicyguid, mondetails_recent.po Filter: ((mondetails_recent.stime >= 1335848499) AND (mondetails_recent.mid = 1000))
5.	0.035	0.076	↑ 1.0	12	1	→ Hash (cost=1.15..1.15 rows=12 width=29) (actual time=0.076..0.076 rows=12 loops=1) Output: hosts.guid Buckets: 1024 Batches: 1 Memory Usage: 1kB
6.	0.041	0.041	↑ 1.0	12	1	→ Seq Scan on public.hosts (cost=0.00..1.15 rows=12 width=29) (actual time=0.009..0.041 rows=12 loops=1) Output: hosts.guid Filter: (hosts.hosttype <> 3)

                                                                                                    QUERY PLAN



-------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------
 Sort  (cost=342033.45..342037.95 rows=1802 width=63) (actual time=68724.458..68724.502 rows=24 loops=1)
   Output: mondetails_recent.serverid, mondetails_recent.vmid, (max(todecimal(mondetails_recent.sv1))), mondetails_recent.mid
   Sort Key: (max(todecimal(mondetails_recent.sv1)))
   Sort Method:  quicksort  Memory: 20kB
   ->  HashAggregate  (cost=341462.98..341936.00 rows=1802 width=63) (actual time=68724.215..68724.277 rows=24 loops=1)
         Output: mondetails_recent.serverid, mondetails_recent.vmid, max(todecimal(mondetails_recent.sv1)), mondetails_recent.mid
         ->  Hash Join  (cost=1.30..322365.23 rows=1909775 width=63) (actual time=12.942..42113.804 rows=1780334 loops=1)
               Output: mondetails_recent.serverid, mondetails_recent.vmid, mondetails_recent.sv1, mondetails_recent.mid
               Hash Cond: ((mondetails_recent.serverid)::text = (hosts.guid)::text)
               ->  Seq Scan on public.mondetails_recent  (cost=0.00..296104.52 rows=1909775 width=63) (actual time=12.814..30979.403 rows=1780334 loops=1)
                     Output: mondetails_recent.mid, mondetails_recent.serverid, mondetails_recent.vmid, mondetails_recent.slapolicyguid, mondetails_recent.po
licyid, mondetails_recent.slagroupguid, mondetails_recent.stime, mondetails_recent.csvval, mondetails_recent.sv1, mondetails_recent.sv2, mondetails_recent.sv
3, mondetails_recent.sv4, mondetails_recent.sv5, mondetails_recent.sv6, mondetails_recent.sv7, mondetails_recent.sv8, mondetails_recent.sv9, mondetails_recen
t.sv10, mondetails_recent.sv11, mondetails_recent.sv12, mondetails_recent.sv13, mondetails_recent.sv14, mondetails_recent.sv15, mondetails_recent.sv16, monde
tails_recent.sv17, mondetails_recent.sv18, mondetails_recent.sv19, mondetails_recent.sv20, mondetails_recent.sv21, mondetails_recent.sv22, mondetails_recent.
sv23, mondetails_recent.sv24, mondetails_recent.sv25
                     Filter: ((mondetails_recent.stime >= 1335848499) AND (mondetails_recent.mid = 1000))
               ->  Hash  (cost=1.15..1.15 rows=12 width=29) (actual time=0.076..0.076 rows=12 loops=1)
                     Output: hosts.guid
                     Buckets: 1024  Batches: 1  Memory Usage: 1kB
                     ->  Seq Scan on public.hosts  (cost=0.00..1.15 rows=12 width=29) (actual time=0.009..0.041 rows=12 loops=1)
                           Output: hosts.guid
                           Filter: (hosts.hosttype <> 3)
 Total runtime: 68742.622 ms

Per node type stats

node type	count	sum of times	% of query
Hash	1	0.035 ms	0.0 %
Hash Join	1	11134.325 ms	16.2 %
HashAggregate	1	26610.473 ms	38.7 %
Seq Scan	2	30979.444 ms	45.1 %
Sort	1	0.225 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
public.hosts	1	0.041 ms	0.0 %
Seq Scan	1	0.041 ms	100.0 %
public.mondetails_recent	1	30979.403 ms	45.1 %
Seq Scan	1	30979.403 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: FcV

Colorize:

Columns visibility:

Per node type stats

Per table stats