Result: DffO : qsdqdq

options

HTML
TEXT
STATS

exclusive	inclusive	rows x	rows	loops	node
1.847	433.022	↑ 1.0	1	1	→ Aggregate (cost=4303.78..4303.79 rows=1 width=8) (actual time=433.022..433.022 rows=1 loops=1)
4.584	431.175	↓ 3666.0	3666	1	→ Nested Loop (cost=789.84..4303.77 rows=1 width=8) (actual time=26.600..431.175 rows=3666 loops=1)
5.150	411.927	↓ 3666.0	3666	1	→ Nested Loop (cost=789.84..4303.46 rows=1 width=16) (actual time=26.591..411.927 rows=3666 loops=1)
2.385	388.447	↓ 3666.0	3666	1	→ Nested Loop (cost=789.84..4297.15 rows=1 width=16) (actual time=26.578..388.447 rows=3666 loops=1)
6.147	375.064	↓ 3666.0	3666	1	→ Nested Loop (cost=789.84..4296.59 rows=1 width=24) (actual time=26.571..375.064 rows=3666 loops=1)
51.392	357.919	↓ 3666.0	3666	1	→ Nested Loop (cost=789.84..4296.13 rows=1 width=24) (actual time=26.563..357.919 rows=3666 loops=1) Join Filter: (tor.monitoredmodule_id = mod.id)
7.069	273.533	↓ 3666.0	3666	1	→ Nested Loop (cost=789.84..4293.02 rows=1 width=24) (actual time=26.538..273.533 rows=3666 loops=1)
2.344	248.134	↓ 3666.0	3666	1	→ Nested Loop (cost=789.84..4292.66 rows=1 width=24) (actual time=26.525..248.134 rows=3666 loops=1)
6.562	223.494	↓ 3716.0	3716	1	→ Nested Loop (cost=789.84..4292.31 rows=1 width=32) (actual time=26.512..223.494 rows=3716 loops=1)
11.073	198.352	↓ 3716.0	3716	1	→ Nested Loop (cost=789.84..4291.95 rows=1 width=32) (actual time=26.498..198.352 rows=3716 loops=1)
8.956	161.035	↓ 8748.0	8748	1	→ Nested Loop (cost=789.84..4291.65 rows=1 width=32) (actual time=8.251..161.035 rows=8748 loops=1)
87.047	108.339	↓ 1749.6	8748	1	→ Hash Left Join (cost=789.84..4288.73 rows=5 width=8) (actual time=8.238..108.339 rows=8748 loops=1) Hash Cond: (bc.disposable_id = di.id) Filter: (di.disposableidentifier IS NULL)
13.078	13.078	↑ 1.0	76824	1	→ Seq Scan on bloodculture bc (cost=0.00..1662.30 rows=77330 width=24) (actual time=0.006..13.078 rows=76824 loops=1)
4.170	8.214	↓ 1.0	17759	1	→ Hash (cost=569.93..569.93 rows=17593 width=22) (actual time=8.214..8.214 rows=17759 loops=1) Buckets: 2048 Batches: 1 Memory Usage: 925kB
4.044	4.044	↓ 1.0	17759	1	→ Seq Scan on disposable di (cost=0.00..569.93 rows=17593 width=22) (actual time=0.005..4.044 rows=17759 loops=1)
43.740	43.740	↑ 1.0	1	8748	→ Index Scan using bloodculture_id_idx on testresult res (cost=0.00..0.57 rows=1 width=40) (actual time=0.004..0.005 rows=1 loops=8748) Index Cond: (res.bloodculture_id = bc.id)
26.244	26.244	↓ 0.0	0	8748	→ Index Scan using idx1_testorderinprogress on testorderinprogress toip (cost=0.00..0.29 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=8748) Index Cond: (toip.result_id = res.id)
18.580	18.580	↑ 1.0	1	3716	→ Index Scan using commontestresult_pkey on commontestresult cp (cost=0.00..0.35 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=3716) Index Cond: (cp.id = res.commonpart_id)
22.296	22.296	↑ 1.0	1	3716	→ Index Scan using traceabilitysummary_pkey on traceabilitysummary trac (cost=0.00..0.33 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=3716) Index Cond: (trac.id = cp.traceabilitysummary_id) Filter: (trac.unloaddate IS NULL)
18.330	18.330	↑ 1.0	1	3666	→ Index Scan using testorder_pkey on testorder tor (cost=0.00..0.35 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=3666) Index Cond: (tor.id = res.testorder_id)
32.994	32.994	↑ 1.0	49	3666	→ Seq Scan on module mod (cost=0.00..2.49 rows=49 width=16) (actual time=0.003..0.009 rows=49 loops=3666)
10.998	10.998	↑ 1.0	1	3666	→ Index Scan using moduletype_pkey on moduletype modtype (cost=0.00..0.45 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=3666) Index Cond: (modtype.id = mod.moduletype_id)
10.998	10.998	↑ 1.0	1	3666	→ Index Scan using systemtype_pkey on systemtype systype (cost=0.00..0.55 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=3666) Index Cond: (systype.id = modtype.systemtype_id)
18.330	18.330	↑ 1.0	1	3666	→ Index Scan using specimen_pkey on specimen sp (cost=0.00..6.29 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=3666) Index Cond: (sp.id = res.specimen_id)
14.664	14.664	↑ 1.0	1	3666	→ Index Scan using patientvisit_pkey on patientvisit pvi (cost=0.00..0.30 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=3666) Index Cond: (pvi.id = sp.patientvisit_id)

"Aggregate  (cost=4303.78..4303.79 rows=1 width=8) (actual time=433.022..433.022 rows=1 loops=1)"
"  ->  Nested Loop  (cost=789.84..4303.77 rows=1 width=8) (actual time=26.600..431.175 rows=3666 loops=1)"
"        ->  Nested Loop  (cost=789.84..4303.46 rows=1 width=16) (actual time=26.591..411.927 rows=3666 loops=1)"
"              ->  Nested Loop  (cost=789.84..4297.15 rows=1 width=16) (actual time=26.578..388.447 rows=3666 loops=1)"
"                    ->  Nested Loop  (cost=789.84..4296.59 rows=1 width=24) (actual time=26.571..375.064 rows=3666 loops=1)"
"                          ->  Nested Loop  (cost=789.84..4296.13 rows=1 width=24) (actual time=26.563..357.919 rows=3666 loops=1)"
"                                Join Filter: (tor.monitoredmodule_id = mod.id)"
"                                ->  Nested Loop  (cost=789.84..4293.02 rows=1 width=24) (actual time=26.538..273.533 rows=3666 loops=1)"
"                                      ->  Nested Loop  (cost=789.84..4292.66 rows=1 width=24) (actual time=26.525..248.134 rows=3666 loops=1)"
"                                            ->  Nested Loop  (cost=789.84..4292.31 rows=1 width=32) (actual time=26.512..223.494 rows=3716 loops=1)"
"                                                  ->  Nested Loop  (cost=789.84..4291.95 rows=1 width=32) (actual time=26.498..198.352 rows=3716 loops=1)"
"                                                        ->  Nested Loop  (cost=789.84..4291.65 rows=1 width=32) (actual time=8.251..161.035 rows=8748 loops=1)"
"                                                              ->  Hash Left Join  (cost=789.84..4288.73 rows=5 width=8) (actual time=8.238..108.339 rows=8748 loops=1)"
"                                                                    Hash Cond: (bc.disposable_id = di.id)"
"                                                                    Filter: (di.disposableidentifier IS NULL)"
"                                                                    ->  Seq Scan on bloodculture bc  (cost=0.00..1662.30 rows=77330 width=24) (actual time=0.006..13.078 rows=76824 loops=1)"
"                                                                    ->  Hash  (cost=569.93..569.93 rows=17593 width=22) (actual time=8.214..8.214 rows=17759 loops=1)"
"                                                                          Buckets: 2048  Batches: 1  Memory Usage: 925kB"
"                                                                          ->  Seq Scan on disposable di  (cost=0.00..569.93 rows=17593 width=22) (actual time=0.005..4.044 rows=17759 loops=1)"
"                                                              ->  Index Scan using bloodculture_id_idx on testresult res  (cost=0.00..0.57 rows=1 width=40) (actual time=0.004..0.005 rows=1 loops=8748)"
"                                                                    Index Cond: (res.bloodculture_id = bc.id)"
"                                                        ->  Index Scan using idx1_testorderinprogress on testorderinprogress toip  (cost=0.00..0.29 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=8748)"
"                                                              Index Cond: (toip.result_id = res.id)"
"                                                  ->  Index Scan using commontestresult_pkey on commontestresult cp  (cost=0.00..0.35 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=3716)"
"                                                        Index Cond: (cp.id = res.commonpart_id)"
"                                            ->  Index Scan using traceabilitysummary_pkey on traceabilitysummary trac  (cost=0.00..0.33 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=3716)"
"                                                  Index Cond: (trac.id = cp.traceabilitysummary_id)"
"                                                  Filter: (trac.unloaddate IS NULL)"
"                                      ->  Index Scan using testorder_pkey on testorder tor  (cost=0.00..0.35 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=3666)"
"                                            Index Cond: (tor.id = res.testorder_id)"
"                                ->  Seq Scan on module mod  (cost=0.00..2.49 rows=49 width=16) (actual time=0.003..0.009 rows=49 loops=3666)"
"                          ->  Index Scan using moduletype_pkey on moduletype modtype  (cost=0.00..0.45 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=3666)"
"                                Index Cond: (modtype.id = mod.moduletype_id)"
"                    ->  Index Scan using systemtype_pkey on systemtype systype  (cost=0.00..0.55 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=3666)"
"                          Index Cond: (systype.id = modtype.systemtype_id)"
"              ->  Index Scan using specimen_pkey on specimen sp  (cost=0.00..6.29 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=3666)"
"                    Index Cond: (sp.id = res.specimen_id)"
"        ->  Index Scan using patientvisit_pkey on patientvisit pvi  (cost=0.00..0.30 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=3666)"
"              Index Cond: (pvi.id = sp.patientvisit_id)"
"Total runtime: 433.494 ms"

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	1.847 ms	0.4 %
Hash	1	4.170 ms	1.0 %
Hash Left Join	1	87.047 ms	20.1 %
Index Scan	9	184.180 ms	42.5 %
Nested Loop	10	105.662 ms	24.4 %
Seq Scan	3	50.116 ms	11.6 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
bloodculture	1	13.078 ms	3.0 %
Seq Scan	1	13.078 ms	100.0 %
commontestresult	1	18.580 ms	4.3 %
Index Scan	1	18.580 ms	100.0 %
disposable	1	4.044 ms	0.9 %
Seq Scan	1	4.044 ms	100.0 %
module	1	32.994 ms	7.6 %
Seq Scan	1	32.994 ms	100.0 %
moduletype	1	10.998 ms	2.5 %
Index Scan	1	10.998 ms	100.0 %
patientvisit	1	14.664 ms	3.4 %
Index Scan	1	14.664 ms	100.0 %
specimen	1	18.330 ms	4.2 %
Index Scan	1	18.330 ms	100.0 %
systemtype	1	10.998 ms	2.5 %
Index Scan	1	10.998 ms	100.0 %
testorder	1	18.330 ms	4.2 %
Index Scan	1	18.330 ms	100.0 %
testorderinprogress	1	26.244 ms	6.1 %
Index Scan	1	26.244 ms	100.0 %
testresult	1	43.740 ms	10.1 %
Index Scan	1	43.740 ms	100.0 %
traceabilitysummary	1	22.296 ms	5.1 %
Index Scan	1	22.296 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: DffO : qsdqdq

Colorize:

Columns visibility:

Per node type stats

Per table stats