explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jUl7

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.212 ↓ 1.5 3 1

Append (cost=0.51..31.43 rows=2 width=1,232) (actual time=0.115..0.212 rows=3 loops=1)

2. 0.002 0.205 ↓ 3.0 3 1

Subquery Scan on *SELECT* 1 (cost=0.51..23.23 rows=1 width=339) (actual time=0.114..0.205 rows=3 loops=1)

3. 0.042 0.203 ↓ 3.0 3 1

Nested Loop (cost=0.51..23.22 rows=1 width=335) (actual time=0.113..0.203 rows=3 loops=1)

  • Join Filter: ((td1.lokalprcnr = td2.lokalprcnr) AND (td1.lokal = td2.lokal))
  • Rows Removed by Join Filter: 67
4. 0.014 0.161 ↓ 4.7 70 1

Nested Loop (cost=0.42..15.76 rows=15 width=345) (actual time=0.092..0.161 rows=70 loops=1)

5. 0.002 0.105 ↓ 3.0 3 1

Nested Loop (cost=0.33..12.45 rows=1 width=347) (actual time=0.078..0.105 rows=3 loops=1)

6. 0.001 0.097 ↓ 3.0 3 1

Nested Loop (cost=0.28..12.37 rows=1 width=345) (actual time=0.074..0.097 rows=3 loops=1)

7. 0.003 0.081 ↓ 3.0 3 1

Nested Loop (cost=0.22..12.30 rows=1 width=343) (actual time=0.062..0.081 rows=3 loops=1)

8. 0.006 0.054 ↓ 3.0 3 1

Nested Loop (cost=0.14..8.19 rows=1 width=329) (actual time=0.047..0.054 rows=3 loops=1)

9. 0.036 0.036 ↓ 3.0 3 1

Index Scan using pk_tttidf on tttidf f (cost=0.08..4.11 rows=1 width=323) (actual time=0.034..0.036 rows=3 loops=1)

  • Index Cond: ((turlnr1 = 7095) AND (tidlnr = 8))
  • Filter: ((fnotfdat <= '2018-10-21'::date) AND (fnottdat >= '2018-11-15'::date) AND (tillfran = 'T'::bpchar))
10. 0.012 0.012 ↑ 1.0 1 3

Index Scan using pk_ttkod on ttkod k1 (cost=0.06..4.08 rows=1 width=10) (actual time=0.004..0.004 rows=1 loops=3)

  • Index Cond: (kodlnr = f.kodlnr)
11. 0.024 0.024 ↑ 1.0 1 3

Index Scan using ux_tttur_02 on tttur t (cost=0.08..4.11 rows=1 width=14) (actual time=0.008..0.008 rows=1 loops=3)

  • Index Cond: (turlnr = f.turlnr2)
12. 0.015 0.015 ↑ 1.0 1 3

Index Scan using pk_ttprc on ttprc p (cost=0.06..0.08 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=3)

  • Index Cond: (prcnr = t.fmprcnr)
13. 0.006 0.006 ↑ 1.0 1 3

Index Scan using pk_ttkod on ttkod k2 (cost=0.06..0.08 rows=1 width=6) (actual time=0.002..0.002 rows=1 loops=3)

  • Index Cond: (kodlnr = t.tmkodlnr)
14. 0.042 0.042 ↑ 4.0 23 3

Index Scan using pk_tttid on tttid td1 (cost=0.09..2.38 rows=93 width=10) (actual time=0.008..0.014 rows=23 loops=3)

  • Index Cond: (turlnr = t.turlnr)
15. 0.000 0.000 ↑ 4.0 1 70

Materialize (cost=0.09..6.77 rows=4 width=12) (actual time=0.000..0.000 rows=1 loops=70)

16. 0.012 0.012 ↑ 4.0 1 1

Index Scan using pk_tttid on tttid td2 (cost=0.09..6.76 rows=4 width=12) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: ((turlnr = 7095) AND (tidlnr = 8))
17. 0.001 0.007 ↓ 0.0 0 1

Nested Loop (cost=0.14..8.19 rows=1 width=367) (actual time=0.007..0.007 rows=0 loops=1)

18. 0.006 0.006 ↓ 0.0 0 1

Index Scan using pk_tttidf on tttidf f_1 (cost=0.08..4.11 rows=1 width=313) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((turlnr1 = 7095) AND (tidlnr = 8))
  • Filter: ((fnotfdat <= '2018-10-21'::date) AND (fnottdat >= '2018-11-15'::date) AND (turlnr2 = 171494) AND (tillfran = 'T'::bpchar))
  • Rows Removed by Filter: 3
19. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ttkod on ttkod k1_1 (cost=0.06..4.08 rows=1 width=10) (never executed)

  • Index Cond: (kodlnr = f_1.kodlnr)