explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6t5w

Settings
# exclusive inclusive rows x rows loops node
1. 1.242 109,333.568 ↑ 170.5 676 1

Finalize GroupAggregate (cost=725,367.92..755,144.78 rows=115,258 width=38) (actual time=109,330.190..109,333.568 rows=676 loops=1)

  • Group Key: courtlocationcode, courtlocation
2. 9.822 109,332.326 ↑ 133.0 1,733 1

Gather Merge (cost=725,367.92..752,263.33 rows=230,516 width=38) (actual time=109,330.175..109,332.326 rows=1,733 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 2.919 109,322.504 ↑ 199.4 578 3 / 3

Sort (cost=724,367.89..724,656.04 rows=115,258 width=38) (actual time=109,322.297..109,322.504 rows=578 loops=3)

  • Sort Key: courtlocationcode, courtlocation
  • Sort Method: quicksort Memory: 73kB
  • Worker 0: Sort Method: quicksort Memory: 74kB
  • Worker 1: Sort Method: quicksort Memory: 74kB
4. 1,352.711 109,319.585 ↑ 199.4 578 3 / 3

Partial HashAggregate (cost=713,525.28..714,677.86 rows=115,258 width=38) (actual time=109,318.678..109,319.585 rows=578 loops=3)

  • Group Key: courtlocationcode, courtlocation
5. 107,966.874 107,966.874 ↑ 1.3 950,251 3 / 3

Parallel Seq Scan on pr_la_fw_sfw_data_listing "PC0" (cost=0.00..704,616.68 rows=1,187,814 width=74) (actual time=0.410..107,966.874 rows=950,251 loops=3)

  • Filter: ((pxobjclass)::text = 'LA-FW-SFW-Data-Listing'::text)