#	exclusive	inclusive	rows x	rows	loops	node
1.	15.617	1,748.833	↑ 1.0	30	1	→ Limit (cost=85,807.23..85,808.73 rows=30 width=28) (actual time=1,733.146..1,748.833 rows=30 loops=1)
2.	0.065	1,733.216	↑ 65.6	30	1	→ Finalize GroupAggregate (cost=85,807.23..85,885.99 rows=1,969 width=28) (actual time=1,733.144..1,733.216 rows=30 loops=1) Group Key: imports.date
3.	0.000	1,733.151	↑ 48.8	121	1	→ Sort (cost=85,807.23..85,822.00 rows=5,907 width=28) (actual time=1,733.132..1,733.151 rows=121 loops=1) Sort Key: imports.date DESC Sort Method: quicksort Memory: 719kB
4.	51.632	1,745.777	↓ 1.1	6,743	1	→ Gather (cost=84,826.82..85,437.21 rows=5,907 width=28) (actual time=1,693.514..1,745.777 rows=6,743 loops=1) Workers Planned: 3 Workers Launched: 3
5.	115.126	1,694.145	↑ 1.2	1,686	4	→ Partial HashAggregate (cost=83,826.82..83,846.51 rows=1,969 width=28) (actual time=1,693.596..1,694.145 rows=1,686 loops=4) Group Key: imports.date
6.	525.174	1,579.019	↑ 1.3	393,265	4	→ Hash Left Join (cost=51,491.01..80,021.18 rows=507,419 width=20) (actual time=959.886..1,579.019 rows=393,265 loops=4) Hash Cond: (import_timer.import_id = imports.id)
7.	96.264	96.264	↑ 1.3	393,265	4	→ Parallel Seq Scan on import_timer (cost=0.00..15,097.19 rows=507,419 width=20) (actual time=0.021..96.264 rows=393,265 loops=4)
8.	561.360	957.581	↓ 1.0	1,581,979	4	→ Hash (cost=25,648.56..25,648.56 rows=1,575,156 width=8) (actual time=957.581..957.581 rows=1,581,979 loops=4) Buckets: 262144 Batches: 16 Memory Usage: 5911kB
9.	396.221	396.221	↓ 1.0	1,581,979	4	→ Seq Scan on imports (cost=0.00..25,648.56 rows=1,575,156 width=8) (actual time=0.028..396.221 rows=1,581,979 loops=4)

 Limit  (cost=85807.23..85808.73 rows=30 width=28) (actual time=1733.146..1748.833 rows=30 loops=1)                                                                
   ->  Finalize GroupAggregate  (cost=85807.23..85885.99 rows=1969 width=28) (actual time=1733.144..1733.216 rows=30 loops=1)                                      
         Group Key: imports.date                                                                                                                                   
         ->  Sort  (cost=85807.23..85822.00 rows=5907 width=28) (actual time=1733.132..1733.151 rows=121 loops=1)                                                  
               Sort Key: imports.date DESC                                                                                                                         
               Sort Method: quicksort  Memory: 719kB                                                                                                               
               ->  Gather  (cost=84826.82..85437.21 rows=5907 width=28) (actual time=1693.514..1745.777 rows=6743 loops=1)                                         
                     Workers Planned: 3                                                                                                                            
                     Workers Launched: 3                                                                                                                           
                     ->  Partial HashAggregate  (cost=83826.82..83846.51 rows=1969 width=28) (actual time=1693.596..1694.145 rows=1686 loops=4)                    
                           Group Key: imports.date                                                                                                                 
                           ->  Hash Left Join  (cost=51491.01..80021.18 rows=507419 width=20) (actual time=959.886..1579.019 rows=393265 loops=4)                  
                                 Hash Cond: (import_timer.import_id = imports.id)                                                                                  
                                 ->  Parallel Seq Scan on import_timer  (cost=0.00..15097.19 rows=507419 width=20) (actual time=0.021..96.264 rows=393265 loops=4) 
                                 ->  Hash  (cost=25648.56..25648.56 rows=1575156 width=8) (actual time=957.581..957.581 rows=1581979 loops=4)                      
                                       Buckets: 262144  Batches: 16  Memory Usage: 5911kB                                                                          
                                       ->  Seq Scan on imports  (cost=0.00..25648.56 rows=1575156 width=8) (actual time=0.028..396.221 rows=1581979 loops=4)       
 Planning time: 1.728 ms                                                                                                                                           
 Execution time: 1749.970 ms

Per node type stats

node type	count	sum of times	% of query
Finalize GroupAggregate	1	0.065 ms	0.0 %
Gather	1	51.632 ms	3.0 %
Hash	1	561.360 ms	32.1 %
Hash Left Join	1	525.174 ms	30.0 %
Limit	1	15.617 ms	0.9 %
Parallel Seq Scan	1	96.264 ms	5.5 %
Partial HashAggregate	1	115.126 ms	6.6 %
Seq Scan	1	396.221 ms	22.7 %
Sort	1	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
import_timer	1	96.264 ms	5.5 %
Parallel Seq Scan	1	96.264 ms	100.0 %
imports	1	396.221 ms	22.7 %
Seq Scan	1	396.221 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v4Fa

Color mode:

Visible columns:

Per node type stats

Per table stats