#	rows x	node
1.	↓ 0.0	→ Hash Join (cost=4151.30..12644.94 rows=82834 width=45) (actual time=.. rows= loops=) Output: o.id, s.status Hash Cond: ((o.lastoperationstatus_id)::text = (s.id)::text)
2.	↓ 0.0	→ Seq Scan on public.xselloperation o (cost=0.00..3901.69 rows=88869 width=74) (actual time=.. rows= loops=) Output: o.id, o.lastoperationstatus_id
3.	↓ 0.0	→ Hash (cost=2388.69..2388.69 rows=82769 width=45) (actual time=.. rows= loops=) Output: s.status, s.id
4.	↓ 0.0	→ Seq Scan on public.xselloperationstatus s (cost=0.00..2388.69 rows=82769 width=45) (actual time=.. rows= loops=) Output: s.status, s.id

Hash Join  (cost=4151.30..12644.94 rows=82834 width=45)
  Output: o.id, s.status
  Hash Cond: ((o.lastoperationstatus_id)::text = (s.id)::text)
  ->  Seq Scan on public.xselloperation o  (cost=0.00..3901.69 rows=88869 width=74)
        Output: o.id, o.lastoperationstatus_id
  ->  Hash  (cost=2388.69..2388.69 rows=82769 width=45)
        Output: s.status, s.id
        ->  Seq Scan on public.xselloperationstatus s  (cost=0.00..2388.69 rows=82769 width=45)
              Output: s.status, s.id

Per node type stats

node type	count	sum of times	% of query
Hash	1	0.000 ms	0.0 %
Hash Join	1	0.000 ms	0.0 %
Seq Scan	2	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
public.xselloperation	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
public.xselloperationstatus	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: rDT

Colorize:

Columns visibility:

Per node type stats

Per table stats