#	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.	0.000	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.	570.600	98,928.822	↑ 269.5	229	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: 8224kB
4.	277.122	98,358.222	↑ 1.2	50,175	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.	41,051.846	55,181.760	↑ 1.2	50,175	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=20207
6.	14,129.914	14,129.914	↓ 1.0	150,524	1	→ 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.	42,899.340	42,899.340	↑ 1.0	1	150,524	→ 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	14,129.914 ms	42.8 %
Gather Merge	1	0.000 ms	0.0 %
Index Scan	1	42,899.340 ms	130.0 %
Limit	1	0.008 ms	0.0 %
Nested Loop	1	277.122 ms	0.8 %
Parallel Bitmap Heap Scan	1	41,051.846 ms	124.4 %
Sort	1	570.600 ms	1.7 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
tbl_change_history_item	1	42,899.340 ms	130.0 %
Index Scan	1	42,899.340 ms	100.0 %
tbl_proj_com_history_item	1	41,051.846 ms	124.4 %
Parallel Bitmap Heap Scan	1	41,051.846 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