#	exclusive	inclusive	rows x	rows	loops	node
1.	2,214.746	3,572.732	↓ 2.5	2,225,121	1	→ Hash Right Join (cost=21,527.94..120,379.48 rows=907,458 width=178) (actual time=1,507.448..3,572.732 rows=2,225,121 loops=1) Hash Cond: (vehicleatt1_.vehicle_id = vehicle0_.id)
2.	788.827	788.827	↑ 1.0	2,267,962	1	→ Seq Scan on vehicle_attribute vehicleatt1_ (cost=0.00..44,465.10 rows=2,275,710 width=38) (actual time=0.008..788.827 rows=2,267,962 loops=1)
3.	155.279	569.159	↓ 3.7	219,107	1	→ Hash (cost=19,564.44..19,564.44 rows=59,480 width=140) (actual time=569.159..569.159 rows=219,107 loops=1) Buckets: 32768 (originally 32768) Batches: 16 (originally 4) Memory Usage: 3841kB
4.	145.572	413.880	↓ 3.7	219,107	1	→ Hash Left Join (cost=541.49..19,564.44 rows=59,480 width=140) (actual time=19.943..413.880 rows=219,107 loops=1) Hash Cond: (capabiliti2_.capabilities_id = capability3_.id)
5.	107.473	260.954	↓ 3.7	219,107	1	→ Nested Loop Left Join (cost=191.14..18,396.24 rows=59,480 width=105) (actual time=12.523..260.954 rows=219,107 loops=1)
6.	19.067	69.481	↓ 1.8	2,000	1	→ Hash Semi Join (cost=190.71..4,762.96 rows=1,094 width=89) (actual time=12.493..69.481 rows=2,000 loops=1) Hash Cond: ((vehicle0_.platform_identifier)::text = (vehicle.platform_identifier)::text)
7.	37.952	37.952	↓ 1.1	64,407	1	→ Seq Scan on vehicle vehicle0_ (cost=0.00..4,401.49 rows=60,414 width=89) (actual time=0.011..37.952 rows=64,407 loops=1) Filter: ((tenant)::text = 'mb-prod'::text) Rows Removed by Filter: 89629
8.	0.569	12.462	↑ 1.0	2,000	1	→ Hash (cost=165.71..165.71 rows=2,000 width=32) (actual time=12.462..12.462 rows=2,000 loops=1) Buckets: 2048 Batches: 1 Memory Usage: 143kB
9.	0.804	11.893	↑ 1.0	2,000	1	→ Limit (cost=0.00..145.71 rows=2,000 width=32) (actual time=0.008..11.893 rows=2,000 loops=1)
10.	11.089	11.089	↑ 30.2	2,000	1	→ Seq Scan on vehicle (cost=0.00..4,401.49 rows=60,414 width=32) (actual time=0.006..11.089 rows=2,000 loops=1) Filter: ((tenant)::text = 'mb-prod'::text) Rows Removed by Filter: 83408
11.	84.000	84.000	↑ 1.8	110	2,000	→ Index Scan using vehicle_capability_vehicles_id_idx on vehicle_capability capabiliti2_ (cost=0.43..10.51 rows=195 width=16) (actual time=0.005..0.042 rows=110 loops=2,000) Index Cond: (vehicle0_.id = vehicles_id)
12.	4.069	7.354	↓ 1.0	11,201	1	→ Hash (cost=214.60..214.60 rows=10,860 width=35) (actual time=7.354..7.354 rows=11,201 loops=1) Buckets: 16384 Batches: 1 Memory Usage: 870kB
13.	3.285	3.285	↓ 1.0	11,201	1	→ Seq Scan on capability capability3_ (cost=0.00..214.60 rows=10,860 width=35) (actual time=0.005..3.285 rows=11,201 loops=1)

"Hash Right Join  (cost=21527.94..120379.48 rows=907458 width=178) (actual time=1507.448..3572.732 rows=2225121 loops=1)"
"  Hash Cond: (vehicleatt1_.vehicle_id = vehicle0_.id)"
"  ->  Seq Scan on vehicle_attribute vehicleatt1_  (cost=0.00..44465.10 rows=2275710 width=38) (actual time=0.008..788.827 rows=2267962 loops=1)"
"  ->  Hash  (cost=19564.44..19564.44 rows=59480 width=140) (actual time=569.159..569.159 rows=219107 loops=1)"
"        Buckets: 32768 (originally 32768)  Batches: 16 (originally 4)  Memory Usage: 3841kB"
"        ->  Hash Left Join  (cost=541.49..19564.44 rows=59480 width=140) (actual time=19.943..413.880 rows=219107 loops=1)"
"              Hash Cond: (capabiliti2_.capabilities_id = capability3_.id)"
"              ->  Nested Loop Left Join  (cost=191.14..18396.24 rows=59480 width=105) (actual time=12.523..260.954 rows=219107 loops=1)"
"                    ->  Hash Semi Join  (cost=190.71..4762.96 rows=1094 width=89) (actual time=12.493..69.481 rows=2000 loops=1)"
"                          Hash Cond: ((vehicle0_.platform_identifier)::text = (vehicle.platform_identifier)::text)"
"                          ->  Seq Scan on vehicle vehicle0_  (cost=0.00..4401.49 rows=60414 width=89) (actual time=0.011..37.952 rows=64407 loops=1)"
"                                Filter: ((tenant)::text = 'mb-prod'::text)"
"                                Rows Removed by Filter: 89629"
"                          ->  Hash  (cost=165.71..165.71 rows=2000 width=32) (actual time=12.462..12.462 rows=2000 loops=1)"
"                                Buckets: 2048  Batches: 1  Memory Usage: 143kB"
"                                ->  Limit  (cost=0.00..145.71 rows=2000 width=32) (actual time=0.008..11.893 rows=2000 loops=1)"
"                                      ->  Seq Scan on vehicle  (cost=0.00..4401.49 rows=60414 width=32) (actual time=0.006..11.089 rows=2000 loops=1)"
"                                            Filter: ((tenant)::text = 'mb-prod'::text)"
"                                            Rows Removed by Filter: 83408"
"                    ->  Index Scan using vehicle_capability_vehicles_id_idx on vehicle_capability capabiliti2_  (cost=0.43..10.51 rows=195 width=16) (actual time=0.005..0.042 rows=110 loops=2000)"
"                          Index Cond: (vehicle0_.id = vehicles_id)"
"              ->  Hash  (cost=214.60..214.60 rows=10860 width=35) (actual time=7.354..7.354 rows=11201 loops=1)"
"                    Buckets: 16384  Batches: 1  Memory Usage: 870kB"
"                    ->  Seq Scan on capability capability3_  (cost=0.00..214.60 rows=10860 width=35) (actual time=0.005..3.285 rows=11201 loops=1)"
"Planning time: 1.331 ms"
"Execution time: 4025.383 ms"

Per node type stats

node type	count	sum of times	% of query
Hash	3	159.917 ms	4.5 %
Hash Left Join	1	145.572 ms	4.1 %
Hash Right Join	1	2,214.746 ms	62.0 %
Hash Semi Join	1	19.067 ms	0.5 %
Index Scan	1	84.000 ms	2.4 %
Limit	1	0.804 ms	0.0 %
Nested Loop Left Join	1	107.473 ms	3.0 %
Seq Scan	4	841.153 ms	23.5 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
capability	1	3.285 ms	0.1 %
Seq Scan	1	3.285 ms	100.0 %
vehicle	2	49.041 ms	1.4 %
Seq Scan	2	49.041 ms	100.0 %
vehicle_attribute	1	788.827 ms	22.1 %
Seq Scan	1	788.827 ms	100.0 %
vehicle_capability	1	84.000 ms	2.4 %
Index Scan	1	84.000 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H8Ov

Color mode:

Visible columns:

Per node type stats

Per table stats