explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OQvw

Settings
# exclusive inclusive rows x rows loops node
1. 106.518 979.486 ↓ 151.5 49,835 1

Nested Loop (cost=11,084.54..15,236.47 rows=329 width=163) (actual time=351.252..979.486 rows=49,835 loops=1)

2. 10.800 424.399 ↓ 118.4 49,841 1

Subquery Scan on s (cost=11,084.13..14,243.99 rows=421 width=90) (actual time=351.204..424.399 rows=49,841 loops=1)

  • Filter: (((s.kokrs)::text = '1000'::text) AND (s.hvr_is_deleted = '0'::smallint) AND (s.rw = 1))
3. 50.637 413.599 ↓ 1.0 84,271 1

WindowAgg (cost=11,084.13..12,769.39 rows=84,263 width=130) (actual time=351.202..413.599 rows=84,271 loops=1)

4. 315.502 362.962 ↓ 1.0 84,271 1

Sort (cost=11,084.13..11,294.78 rows=84,263 width=90) (actual time=351.194..362.962 rows=84,271 loops=1)

  • Sort Key: c.kostl, c.datbi DESC
  • Sort Method: quicksort Memory: 14923kB
5. 47.460 47.460 ↓ 1.0 84,271 1

Seq Scan on csks c (cost=0..4,190.31 rows=84,263 width=90) (actual time=0.005..47.46 rows=84,271 loops=1)

  • Filter: ((mandt)::text = '400'::text)
6. 448.569 448.569 ↑ 1.0 1 49,841

Index Scan using cskt_pkey on cskt t (cost=0.42..2.34 rows=1 width=65) (actual time=0.009..0.009 rows=1 loops=49,841)

  • Index Cond: (((mandt)::text = (s.mandt)::text) AND ((spras)::text = 'E'::text) AND ((kokrs)::text = '1000'::text) AND ((kostl)::text = (s.kostl)::text) AND ((datbi)::text = (s.datbi)::text))
  • Filter: (hvr_is_deleted = '0'::smallint)
Planning time : 0.742 ms
Execution time : 982.709 ms