explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SL1o

Settings
# exclusive inclusive rows x rows loops node
1. 15.305 72.532 ↑ 5.4 5,756 1

Hash Left Join (cost=4,191.36..2,075,635.10 rows=30,969 width=198) (actual time=25.588..72.532 rows=5,756 loops=1)

  • Hash Cond: (kt.rechiv = l.recnum)
2. 3.042 33.883 ↑ 5.4 5,756 1

Hash Left Join (cost=4,110.54..59,839.11 rows=30,969 width=86) (actual time=25.055..33.883 rows=5,756 loops=1)

  • Hash Cond: (r.ktrechiv = kt.recnum)
3. 6.248 6.248 ↑ 5.4 5,756 1

Index Scan using ku_rend_idx on ku_rend r (cost=0.43..55,303.17 rows=30,969 width=86) (actual time=0.018..6.248 rows=5,756 loops=1)

  • Index Cond: (kk_rst = ANY ('{K,T,W}'::bpchar[]))
4. 13.877 24.593 ↑ 1.0 95,337 1

Hash (cost=2,918.40..2,918.40 rows=95,337 width=16) (actual time=24.593..24.593 rows=95,337 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 5493kB
5. 10.716 10.716 ↑ 1.0 95,337 1

Index Only Scan using ktleiro_kapac_idx2 on ktleiro kt (cost=0.42..2,918.40 rows=95,337 width=16) (actual time=0.020..10.716 rows=95,337 loops=1)

  • Heap Fetches: 62
6. 0.206 0.455 ↑ 1.0 1,474 1

Hash (cost=62.39..62.39 rows=1,474 width=19) (actual time=0.455..0.455 rows=1,474 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 97kB
7. 0.249 0.249 ↑ 1.0 1,474 1

Index Only Scan using leiro_kapac_idx on leiro l (cost=0.28..62.39 rows=1,474 width=19) (actual time=0.013..0.249 rows=1,474 loops=1)

  • Heap Fetches: 0
8.          

SubPlan (forHash Left Join)

9. 0.000 11.512 ↑ 1.0 1 5,756

Aggregate (cost=21.68..21.69 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=5,756)

10. 11.512 11.512 ↑ 4.0 1 5,756

Index Scan using ku_rendkszuk_idx on ku_rendkszuk (cost=0.42..21.67 rows=4 width=8) (actual time=0.001..0.002 rows=1 loops=5,756)

  • Index Cond: (rechiv = r.recnum)
  • Filter: ((kapac)::text <> ALL ('{MEO,TRANSPORT}'::text[]))
  • Rows Removed by Filter: 0
11. 5.756 5.756 ↓ 0.0 0 5,756

Index Scan using ku_rendkszuk_idx on ku_rendkszuk ksz (cost=0.42..21.67 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=5,756)

  • Index Cond: (rechiv = r.recnum)
  • Filter: ((kapac)::text = 'AWBL'::text)
  • Rows Removed by Filter: 2
12. 5.621 5.621 ↓ 0.0 0 5,621

Index Scan using ku_rendkszuk_idx on ku_rendkszuk ksz_1 (cost=0.42..21.67 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=5,621)

  • Index Cond: (rechiv = r.recnum)
  • Filter: ((kapac)::text = 'CSM7'::text)
  • Rows Removed by Filter: 2