#	exclusive	inclusive	rows x	rows	loops	node
1.	1.732	20.875	↑ 1.0	1,907	1	→ Hash Join (cost=1,446.16..1,533.46 rows=1,940 width=192) (actual time=15.612..20.875 rows=1,907 loops=1) Hash Cond: (base.id = ets.id)
2.						CTE base
3.	1.784	12.550	↑ 1.0	1,907	1	→ Unique (cost=966.96..1,016.82 rows=1,940 width=24) (actual time=9.759..12.550 rows=1,907 loops=1)
4.	7.587	10.766	↑ 1.0	9,971	1	→ Sort (cost=966.96..991.89 rows=9,971 width=24) (actual time=9.758..10.766 rows=9,971 loops=1) Sort Key: external_tracking_status.order_id, external_tracking_status.tracking_system_timestamp, external_tracking_status.server_timestamp Sort Method: quicksort Memory: 1163kB
5.	3.179	3.179	↑ 1.0	9,971	1	→ Seq Scan on external_tracking_status (cost=0.00..304.71 rows=9,971 width=24) (actual time=0.006..3.179 rows=9,971 loops=1)
6.	13.306	13.306	↑ 1.0	1,907	1	→ CTE Scan on base (cost=0.00..38.80 rows=1,940 width=4) (actual time=9.761..13.306 rows=1,907 loops=1)
7.	4.399	5.837	↑ 1.0	9,971	1	→ Hash (cost=304.71..304.71 rows=9,971 width=192) (actual time=5.837..5.837 rows=9,971 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 1638kB
8.	1.438	1.438	↑ 1.0	9,971	1	→ Seq Scan on external_tracking_status ets (cost=0.00..304.71 rows=9,971 width=192) (actual time=0.003..1.438 rows=9,971 loops=1)

"Hash Join  (cost=1446.16..1533.46 rows=1940 width=192) (actual time=15.612..20.875 rows=1907 loops=1)"
"  Hash Cond: (base.id = ets.id)"
"  CTE base"
"    ->  Unique  (cost=966.96..1016.82 rows=1940 width=24) (actual time=9.759..12.550 rows=1907 loops=1)"
"          ->  Sort  (cost=966.96..991.89 rows=9971 width=24) (actual time=9.758..10.766 rows=9971 loops=1)"
"                Sort Key: external_tracking_status.order_id, external_tracking_status.tracking_system_timestamp, external_tracking_status.server_timestamp"
"                Sort Method: quicksort  Memory: 1163kB"
"                ->  Seq Scan on external_tracking_status  (cost=0.00..304.71 rows=9971 width=24) (actual time=0.006..3.179 rows=9971 loops=1)"
"  ->  CTE Scan on base  (cost=0.00..38.80 rows=1940 width=4) (actual time=9.761..13.306 rows=1907 loops=1)"
"  ->  Hash  (cost=304.71..304.71 rows=9971 width=192) (actual time=5.837..5.837 rows=9971 loops=1)"
"        Buckets: 1024  Batches: 1  Memory Usage: 1638kB"
"        ->  Seq Scan on external_tracking_status ets  (cost=0.00..304.71 rows=9971 width=192) (actual time=0.003..1.438 rows=9971 loops=1)"
"Planning time: 0.184 ms"
"Execution time: 21.281 ms"

Per node type stats

node type	count	sum of times	% of query
CTE Scan	1	13.306 ms	63.7 %
Hash	1	4.399 ms	21.1 %
Hash Join	1	1.732 ms	8.3 %
Seq Scan	2	4.617 ms	22.1 %
Sort	1	7.587 ms	36.3 %
Unique	1	1.784 ms	8.5 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
external_tracking_status	2	4.617 ms	22.1 %
Seq Scan	2	4.617 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MqXs : Optimization for: plan #k95Q

Color mode:

Visible columns:

Optimization path:

Optimization(s) for this plan:

Per node type stats

Per table stats