explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Os8t : prod_prije_prod_spor_cest_upit_1

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 589.999 ↑ 2.7 3 1

Sort (cost=479,261.96..479,261.98 rows=8 width=8,071) (actual time=589.998..589.999 rows=3 loops=1)

  • Sort Key: transno DESC
  • Sort Method: quicksort Memory: 28kB
2. 10.061 594.694 ↑ 2.7 3 1

Gather (cost=1,000.00..479,261.84 rows=8 width=8,071) (actual time=499.202..594.694 rows=3 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 584.633 584.633 ↑ 2.0 1 5 / 5

Parallel Seq Scan on srservicerequesthist servicereq0_ (cost=0.00..478,261.04 rows=2 width=8,071) (actual time=531.715..584.633 rows=1 loops=5)

  • Filter: (id = 2,364,686)
  • Rows Removed by Filter: 1,314,723
Planning time : 0.160 ms
Execution time : 594.790 ms