#	exclusive	inclusive	rows x	rows	loops	node
1.	459.557	5542.642	↓ 2.6	265494	1	→ Hash Join (cost=11251.650..208369.900 rows=101599 width=4) (actual time=136.613..5542.642 rows=265494 loops=1) Hash Cond: (seven.four = papa.quebec)
2.	4774.107	4946.780	↓ 2.9	297500	1	→ Nested Loop Semi Join (cost=0.000..194959.270 rows=101599 width=4) (actual time=0.147..4946.780 rows=297500 loops=1) -> Index Scan using tracking_history_vid_index on tracking_history (cost=0.00..1.67 rows=11 width=4) (actual time=0.004..0.004 rows=0 loops=1050
3.	172.673	172.673	↑ 1.0	1050000	1	→ Seq Scan on bravo seven (cost=0.000..20314.230 rows=1050023 width=8) (actual time=0.008..172.673 rows=1050000 loops=1) Index Cond: (golf.echo = seven.echo) Filter: (golf.lima >= 500)
4.	67.195	136.305	↑ 1.0	218251	1	→ Hash (cost=8523.510..8523.510 rows=218251 width=4) (actual time=136.305..136.305 rows=218251 loops=1)
5.	69.110	69.110	↑ 1.0	218251	1	→ Seq Scan on romeo papa (cost=0.000..8523.510 rows=218251 width=4) (actual time=0.006..69.110 rows=218251 loops=1)

Hash Join  (cost=11251.650..208369.900 rows=101599 width=4) (actual time=136.613..5542.642 rows=265494 loops=1)
    Hash Cond: (seven.four = papa.quebec)
  ->  Nested Loop Semi Join  (cost=0.000..194959.270 rows=101599 width=4) (actual time=0.147..4946.780 rows=297500 loops=1)
          ->  Index Scan using tracking_history_vid_index on tracking_history  (cost=0.00..1.67 rows=11 width=4) (actual time=0.004..0.004 rows=0 loops=1050
        ->  Seq Scan on bravo seven  (cost=0.000..20314.230 rows=1050023 width=8) (actual time=0.008..172.673 rows=1050000 loops=1)
                Index Cond: (golf.echo = seven.echo)
                Filter: (golf.lima >= 500)
  ->  Hash  (cost=8523.510..8523.510 rows=218251 width=4) (actual time=136.305..136.305 rows=218251 loops=1)
        ->  Seq Scan on romeo papa  (cost=0.000..8523.510 rows=218251 width=4) (actual time=0.006..69.110 rows=218251 loops=1)

Per node type stats

node type	count	sum of times	% of query
Hash	1	67.195 ms	1.2 %
Hash Join	1	459.557 ms	8.3 %
Nested Loop Semi Join	1	4774.107 ms	86.1 %
Seq Scan	2	241.783 ms	4.4 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
bravo	1	172.673 ms	3.1 %
Seq Scan	1	172.673 ms	100.0 %
romeo	1	69.110 ms	1.2 %
Seq Scan	1	69.110 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: fLg

Colorize:

Columns visibility:

Per node type stats

Per table stats