explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZDV1 : prod_poslije_prod_1

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 548.543 ↑ 1.3 6 1

Sort (cost=479,524.23..479,524.25 rows=8 width=8,071) (actual time=548.543..548.543 rows=6 loops=1)

  • Sort Key: transno DESC
  • Sort Method: quicksort Memory: 29kB
2. 7.679 551.653 ↑ 1.3 6 1

Gather (cost=1,000.00..479,524.11 rows=8 width=8,071) (actual time=44.680..551.653 rows=6 loops=1)

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

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

  • Filter: (id = 8,467)
  • Rows Removed by Filter: 1,315,453
Planning time : 0.154 ms
Execution time : 551.748 ms