explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XZL7

Settings
# 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