#	exclusive	inclusive	rows x	rows	loops	node
1.	0.057	164.450	↓ 1.4	321	1	→ Limit (cost=871.56..872.12 rows=226 width=883) (actual time=164.351..164.450 rows=321 loops=1)
2.	0.804	164.393	↓ 1.4	321	1	→ Sort (cost=871.56..872.12 rows=226 width=883) (actual time=164.350..164.393 rows=321 loops=1) Sort Key: pl.generated_at DESC Sort Method: quicksort Memory: 110kB
3.	5.014	163.589	↓ 1.4	321	1	→ Hash Left Join (cost=61.02..862.72 rows=226 width=883) (actual time=4.802..163.589 rows=321 loops=1) Hash Cond: (pl.administrator_id = a.id)
4.	0.798	158.301	↓ 1.4	321	1	→ Hash Join (cost=43.52..838.72 rows=226 width=608) (actual time=4.305..158.301 rows=321 loops=1) Hash Cond: (pl.position_source_id = ps.id)
5.	154.294	157.484	↓ 1.4	321	1	→ Bitmap Heap Scan on position_log_data pl (cost=14.17..806.26 rows=226 width=578) (actual time=4.184..157.484 rows=321 loops=1) Recheck Cond: (vehicle_id = 3275) Heap Blocks: exact=164
6.	3.190	3.190	↓ 1.4	321	1	→ Bitmap Index Scan on position_log_vehicle_position_idx (cost=0.00..14.12 rows=226 width=0) (actual time=3.190..3.190 rows=321 loops=1) Index Cond: (vehicle_id = 3275)
7.	0.006	0.019	↑ 172.0	5	1	→ Hash (cost=18.60..18.60 rows=860 width=34) (actual time=0.019..0.019 rows=5 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 9kB
8.	0.013	0.013	↑ 172.0	5	1	→ Seq Scan on position_source ps (cost=0.00..18.60 rows=860 width=34) (actual time=0.013..0.013 rows=5 loops=1)
9.	0.036	0.274	↑ 1.0	111	1	→ Hash (cost=16.11..16.11 rows=111 width=155) (actual time=0.274..0.274 rows=111 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 29kB
10.	0.238	0.238	↑ 1.0	111	1	→ Seq Scan on administrator a (cost=0.00..16.11 rows=111 width=155) (actual time=0.009..0.238 rows=111 loops=1)

                                                                              QUERY PLAN                                                                               
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=871.56..872.12 rows=226 width=883) (actual time=164.351..164.450 rows=321 loops=1)
   ->  Sort  (cost=871.56..872.12 rows=226 width=883) (actual time=164.350..164.393 rows=321 loops=1)
         Sort Key: pl.generated_at DESC
         Sort Method: quicksort  Memory: 110kB
         ->  Hash Left Join  (cost=61.02..862.72 rows=226 width=883) (actual time=4.802..163.589 rows=321 loops=1)
               Hash Cond: (pl.administrator_id = a.id)
               ->  Hash Join  (cost=43.52..838.72 rows=226 width=608) (actual time=4.305..158.301 rows=321 loops=1)
                     Hash Cond: (pl.position_source_id = ps.id)
                     ->  Bitmap Heap Scan on position_log_data pl  (cost=14.17..806.26 rows=226 width=578) (actual time=4.184..157.484 rows=321 loops=1)
                           Recheck Cond: (vehicle_id = 3275)
                           Heap Blocks: exact=164
                           ->  Bitmap Index Scan on position_log_vehicle_position_idx  (cost=0.00..14.12 rows=226 width=0) (actual time=3.190..3.190 rows=321 loops=1)
                                 Index Cond: (vehicle_id = 3275)
                     ->  Hash  (cost=18.60..18.60 rows=860 width=34) (actual time=0.019..0.019 rows=5 loops=1)
                           Buckets: 1024  Batches: 1  Memory Usage: 9kB
                           ->  Seq Scan on position_source ps  (cost=0.00..18.60 rows=860 width=34) (actual time=0.013..0.013 rows=5 loops=1)
               ->  Hash  (cost=16.11..16.11 rows=111 width=155) (actual time=0.274..0.274 rows=111 loops=1)
                     Buckets: 1024  Batches: 1  Memory Usage: 29kB
                     ->  Seq Scan on administrator a  (cost=0.00..16.11 rows=111 width=155) (actual time=0.009..0.238 rows=111 loops=1)
 Planning time: 1.236 ms
 Execution time: 164.795 ms
(21 rows)

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	154.294 ms	93.8 %
Bitmap Index Scan	1	3.190 ms	1.9 %
Hash	2	0.042 ms	0.0 %
Hash Join	1	0.798 ms	0.5 %
Hash Left Join	1	5.014 ms	3.0 %
Limit	1	0.057 ms	0.0 %
Seq Scan	2	0.251 ms	0.2 %
Sort	1	0.804 ms	0.5 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
administrator	1	0.238 ms	0.1 %
Seq Scan	1	0.238 ms	100.0 %
position_log_data	1	154.294 ms	93.8 %
Bitmap Heap Scan	1	154.294 ms	100.0 %
position_source	1	0.013 ms	0.0 %
Seq Scan	1	0.013 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E95J

Color mode:

Visible columns:

Per node type stats

Per table stats