#	exclusive	inclusive	rows x	rows	loops	node
1.	0.008	32,991.504	↑ 1.0	30	1	→ Limit (cost=374,914.91..374,918.41 rows=30 width=188) (actual time=32,991.473..32,991.504 rows=30 loops=1)
2.	15.222	32,991.496	↑ 4,114.9	30	1	→ Gather Merge (cost=374,914.91..389,317.94 rows=123,446 width=188) (actual time=32,991.470..32,991.496 rows=30 loops=1) Workers Planned: 2 Workers Launched: 2
3.	190.200	32,976.274	↑ 269.5	229	3 / 3	→ Sort (cost=373,914.88..374,069.19 rows=61,723 width=188) (actual time=32,976.187..32,976.274 rows=229 loops=3) Sort Key: this_1_.date_ DESC Sort Method: external merge Disk: 8,224kB
4.	92.374	32,786.074	↑ 1.2	50,175	3 / 3	→ Nested Loop (cost=6,233.16..363,305.73 rows=61,723 width=188) (actual time=14,195.288..32,786.074 rows=50,175 loops=3)
5.	13,683.949	18,393.920	↑ 1.2	50,175	3 / 3	→ Parallel Bitmap Heap Scan on tbl_proj_com_history_item this_ (cost=6,232.60..102,626.37 rows=61,723 width=66) (actual time=14,166.099..18,393.920 rows=50,175 loops=3) Recheck Cond: ((dialproject)::text = 'corebo00000000000m70pt4aqgmt59n8'::text) Heap Blocks: exact=20,207
6.	4,709.971	4,709.971	↓ 1.0	150,524	1 / 3	→ Bitmap Index Scan on idx_fk116 (cost=0.00..6,195.57 rows=148,135 width=0) (actual time=14,129.914..14,129.914 rows=150,524 loops=1) Index Cond: ((dialproject)::text = 'corebo00000000000m70pt4aqgmt59n8'::text)
7.	14,299.780	14,299.780	↑ 1.0	1	150,524 / 3	→ Index Scan using tbl_change_history_item_pkey on tbl_change_history_item this_1_ (cost=0.56..4.22 rows=1 width=155) (actual time=0.285..0.285 rows=1 loops=150,524) Index Cond: ((uuid)::text = (this_.uuid)::text)

Planning time	:	51.784 ms
Execution time	:	33,065.828 ms

 Limit  (cost=374914.91..374918.41 rows=30 width=188) (actual time=32991.473..32991.504 rows=30 loops=1)
   ->  Gather Merge  (cost=374914.91..389317.94 rows=123446 width=188) (actual time=32991.470..32991.496 rows=30 loops=1)
         Workers Planned: 2
         Workers Launched: 2
         ->  Sort  (cost=373914.88..374069.19 rows=61723 width=188) (actual time=32976.187..32976.274 rows=229 loops=3)
               Sort Key: this_1_.date_ DESC
               Sort Method: external merge  Disk: 8224kB
               ->  Nested Loop  (cost=6233.16..363305.73 rows=61723 width=188) (actual time=14195.288..32786.074 rows=50175 loops=3)
                     ->  Parallel Bitmap Heap Scan on tbl_proj_com_history_item this_  (cost=6232.60..102626.37 rows=61723 width=66) (actual time=14166.099..18393.920 rows=50175 loops=3)
                           Recheck Cond: ((dialproject)::text = 'corebo00000000000m70pt4aqgmt59n8'::text)
                           Heap Blocks: exact=20207
                           ->  Bitmap Index Scan on idx_fk116  (cost=0.00..6195.57 rows=148135 width=0) (actual time=14129.914..14129.914 rows=150524 loops=1)
                                 Index Cond: ((dialproject)::text = 'corebo00000000000m70pt4aqgmt59n8'::text)
                     ->  Index Scan using tbl_change_history_item_pkey on tbl_change_history_item this_1_  (cost=0.56..4.22 rows=1 width=155) (actual time=0.285..0.285 rows=1 loops=150524)
                           Index Cond: ((uuid)::text = (this_.uuid)::text)
 Planning time: 51.784 ms
 Execution time: 33065.828 ms
(17 rows)

Per node type stats

node type	count	sum of times	% of query
Bitmap Index Scan	1	4,709.971 ms	14.3 %
Gather Merge	1	15.222 ms	0.0 %
Index Scan	1	14,299.780 ms	43.3 %
Limit	1	0.008 ms	0.0 %
Nested Loop	1	92.374 ms	0.3 %
Parallel Bitmap Heap Scan	1	13,683.949 ms	41.5 %
Sort	1	190.200 ms	0.6 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
tbl_change_history_item	1	14,299.780 ms	43.3 %
Index Scan	1	14,299.780 ms	100.0 %
tbl_proj_com_history_item	1	13,683.949 ms	41.5 %
Parallel Bitmap Heap Scan	1	13,683.949 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XZL7

Color mode:

Visible columns:

Per node type stats

Per table stats