explain.depesz.com

A tool for finding a real cause for slow queries.

Result: aOn

options
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=0.00..1586845.33 rows=1 width=2332) (actual time=.. rows= loops=)

  • Join Filter: ((kuaf.auftnr = kurt.auftnr) AND (kuaf.auftpo = kurt.auftpo))
2. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=0.00..1579300.04 rows=1 width=2087) (actual time=.. rows= loops=)

3. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=0.00..1579297.22 rows=1 width=1884) (actual time=.. rows= loops=)

4. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=0.00..1579294.91 rows=1 width=1004) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0
→

Index Scan using kuapx0 on kuap (cost=0.00..46985.25 rows=73899 width=822) (actual time=.. rows= loops=)

  • Index Cond: ((firmnr = 3::numeric) AND (werkli = 3::numeric))
6. 0.000 0.000 ↓ 0.0
→

Index Scan using kuaex0 on kuae (cost=0.00..20.72 rows=1 width=182) (actual time=.. rows= loops=)

  • Index Cond: ((kuae.firmnr = 3::numeric) AND (kuae.werkli = 3::numeric) AND (kuae.auftnr = kuap.auftnr) AND (kuae.auftpo = kuap.auftpo) AND (kuae.aufdat >= 79
7. 0.000 0.000 ↓ 0.0
→

Index Scan using kuakx0 on kuak (cost=0.00..2.29 rows=1 width=880) (actual time=.. rows= loops=)

  • Index Cond: ((kuak.firmnr = 3::numeric) AND (kuak.werkli = 3::numeric) AND (kuak.auftnr = kuae.auftnr))
8. 0.000 0.000 ↓ 0.0
→

Index Scan using kuafx0 on kuaf (cost=0.00..2.80 rows=1 width=203) (actual time=.. rows= loops=)

  • Index Cond: ((kuaf.firmnr = 3::numeric) AND (kuaf.werkli = 3::numeric) AND (kuaf.auftnr = kuae.auftnr) AND (kuaf.auftpo = kuae.auftpo) AND (kuaf.aufdat = kuae.aufdat) AN
9. 0.000 0.000 ↓ 0.0
→

Seq Scan on kurt (cost=0.00..6381.20 rows=77606 width=245) (actual time=.. rows= loops=)

  • Filter: ((kurt.firmnr = 3::numeric) AND (kurt.auwerk = 3::numeric) AND (kurt.abbddt = 0::numeric) AND (kurt.abbdfz = 0::numeric))