Result: ME

options

HTML
TEXT
STATS

exclusive	inclusive	rows x	rows	loops	node
0.184	17859.347	↑ 1.0	100	1	→ Limit (cost=133334.63..133334.88 rows=100 width=32) (actual time=17859.060..17859.347 rows=100 loops=1)
2626.927	17859.163	↑ 114.0	100	1	→ Sort (cost=133334.63..133363.13 rows=11398 width=32) (actual time=17859.056..17859.163 rows=100 loops=1) Sort Key: stp.data
2830.904	15232.236	↓ 68.1	776367	1	→ Nested Loop (cost=123927.18..132566.60 rows=11398 width=32) (actual time=2751.479..15232.236 rows=776367 loops=1)
1680.026	6966.735	↓ 68.1	776371	1	→ Hash Join (cost=123927.18..127932.73 rows=11398 width=32) (actual time=2751.409..6966.735 rows=776371 loops=1) Hash Cond: (sta.taryfa_telekart_id = tt.taryfa_telekart_id)
1631.652	5286.664	↓ 68.1	776371	1	→ Merge Left Join (cost=123926.07..127774.90 rows=11398 width=26) (actual time=2751.351..5286.664 rows=776371 loops=1) Merge Cond: (sta.tid = rt.tid) Filter: ((rt.treklamacja_id IS NULL) OR ((rt.treklamacja_id IS NOT NULL) AND ((rt.status_reklamacji = 0) OR (rt.status_reklamacji = 2))))
2500.334	3654.750	↓ 1.0	776397	1	→ Sort (cost=123864.23..125779.84 rows=766246 width=24) (actual time=2751.142..3654.750 rows=776397 loops=1) Sort Key: sta.tid
1154.416	1154.416	↓ 1.0	776397	1	→ Seq Scan on sys_telekarta_start sta (cost=0.00..14925.46 rows=766246 width=24) (actual time=0.021..1154.416 rows=776397 loops=1)
0.161	0.262	↑ 14.0	63	1	→ Sort (cost=61.84..64.04 rows=880 width=14) (actual time=0.199..0.262 rows=63 loops=1) Sort Key: rt.tid
0.101	0.101	↑ 14.0	63	1	→ Seq Scan on reklamacje_telekart rt (cost=0.00..18.80 rows=880 width=14) (actual time=0.026..0.101 rows=63 loops=1)
0.011	0.045	↑ 1.0	5	1	→ Hash (cost=1.05..1.05 rows=5 width=14) (actual time=0.045..0.045 rows=5 loops=1)
0.034	0.034	↑ 1.0	5	1	→ Seq Scan on taryfy_telekart tt (cost=0.00..1.05 rows=5 width=14) (actual time=0.028..0.034 rows=5 loops=1)
5434.597	5434.597	↑ 1.0	1	776371	→ Index Scan using sys_telekarta_stop_start_id_key on sys_telekarta_stop stp (cost=0.00..0.39 rows=1 width=16) (actual time=0.005..0.007 rows=1 loops=776371) Index Cond: (stp.start_id = sta.start_id)

Limit  (cost=133334.63..133334.88 rows=100 width=32) (actual time=17859.060..17859.347 rows=100 loops=1)
  ->  Sort  (cost=133334.63..133363.13 rows=11398 width=32) (actual time=17859.056..17859.163 rows=100 loops=1)
        Sort Key: stp.data
        ->  Nested Loop  (cost=123927.18..132566.60 rows=11398 width=32) (actual time=2751.479..15232.236 rows=776367 loops=1)
              ->  Hash Join  (cost=123927.18..127932.73 rows=11398 width=32) (actual time=2751.409..6966.735 rows=776371 loops=1)
                    Hash Cond: (sta.taryfa_telekart_id = tt.taryfa_telekart_id)
                    ->  Merge Left Join  (cost=123926.07..127774.90 rows=11398 width=26) (actual time=2751.351..5286.664 rows=776371 loops=1)
                          Merge Cond: (sta.tid = rt.tid)
                          Filter: ((rt.treklamacja_id IS NULL) OR ((rt.treklamacja_id IS NOT NULL) AND ((rt.status_reklamacji = 0) OR (rt.status_reklamacji = 2))))
                          ->  Sort  (cost=123864.23..125779.84 rows=766246 width=24) (actual time=2751.142..3654.750 rows=776397 loops=1)
                                Sort Key: sta.tid
                                ->  Seq Scan on sys_telekarta_start sta  (cost=0.00..14925.46 rows=766246 width=24) (actual time=0.021..1154.416 rows=776397 loops=1)
                          ->  Sort  (cost=61.84..64.04 rows=880 width=14) (actual time=0.199..0.262 rows=63 loops=1)
                                Sort Key: rt.tid
                                ->  Seq Scan on reklamacje_telekart rt  (cost=0.00..18.80 rows=880 width=14) (actual time=0.026..0.101 rows=63 loops=1)
                    ->  Hash  (cost=1.05..1.05 rows=5 width=14) (actual time=0.045..0.045 rows=5 loops=1)
                          ->  Seq Scan on taryfy_telekart tt  (cost=0.00..1.05 rows=5 width=14) (actual time=0.028..0.034 rows=5 loops=1)
              ->  Index Scan using sys_telekarta_stop_start_id_key on sys_telekarta_stop stp  (cost=0.00..0.39 rows=1 width=16) (actual time=0.005..0.007 rows=1 loops=776371)
                    Index Cond: (stp.start_id = sta.start_id)

Per node type stats

node type	count	sum of times	% of query
Hash	1	0.011 ms	0.0 %
Hash Join	1	1680.026 ms	9.4 %
Index Scan	1	5434.597 ms	30.4 %
Limit	1	0.184 ms	0.0 %
Merge Left Join	1	1631.652 ms	9.1 %
Nested Loop	1	2830.904 ms	15.9 %
Seq Scan	3	1154.551 ms	6.5 %
Sort	3	5127.422 ms	28.7 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
reklamacje_telekart	1	0.101 ms	0.0 %
Seq Scan	1	0.101 ms	100.0 %
sys_telekarta_start	1	1154.416 ms	6.5 %
Seq Scan	1	1154.416 ms	100.0 %
sys_telekarta_stop	1	5434.597 ms	30.4 %
Index Scan	1	5434.597 ms	100.0 %
taryfy_telekart	1	0.034 ms	0.0 %
Seq Scan	1	0.034 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: ME

Colorize:

Columns visibility:

Per node type stats

Per table stats