explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ftrM

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.246 ↓ 1.5 3 1

Append (cost=7.23..30.89 rows=2 width=1,232) (actual time=0.143..0.246 rows=3 loops=1)

2. 0.002 0.235 ↓ 3.0 3 1

Subquery Scan on *SELECT* 1 (cost=7.23..22.69 rows=1 width=339) (actual time=0.143..0.235 rows=3 loops=1)

3. 0.018 0.233 ↓ 3.0 3 1

Hash Join (cost=7.23..22.67 rows=1 width=335) (actual time=0.142..0.233 rows=3 loops=1)

  • Hash Cond: ((td1.lokalprcnr = td2.lokalprcnr) AND (td1.lokal = td2.lokal))
4. 0.015 0.189 ↓ 4.7 70 1

Nested Loop (cost=0.42..15.70 rows=15 width=345) (actual time=0.103..0.189 rows=70 loops=1)

5. 0.004 0.114 ↓ 3.0 3 1

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

6. 0.003 0.104 ↓ 3.0 3 1

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

7. 0.004 0.089 ↓ 3.0 3 1

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

8. 0.005 0.064 ↓ 3.0 3 1

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

9. 0.044 0.044 ↓ 3.0 3 1

Index Scan using pk_tttidf on tttidf f (cost=0.08..4.11 rows=1 width=323) (actual time=0.042..0.044 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.015 0.015 ↑ 1.0 1 3

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

  • Index Cond: (kodlnr = f.kodlnr)
11. 0.021 0.021 ↑ 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.007..0.007 rows=1 loops=3)

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

Index Scan using pk_ttprc on ttprc p (cost=0.06..0.08 rows=1 width=4) (actual time=0.004..0.004 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.060 0.060 ↑ 4.0 23 3

Index Scan using pk_tttid on tttid td1 (cost=0.09..2.34 rows=91 width=10) (actual time=0.014..0.020 rows=23 loops=3)

  • Index Cond: (turlnr = t.turlnr)
15. 0.002 0.026 ↑ 4.0 1 1

Hash (cost=6.76..6.76 rows=4 width=12) (actual time=0.026..0.026 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
16. 0.024 0.024 ↑ 4.0 1 1

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

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

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

18. 0.010 0.010 ↓ 0.0 0 1

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

  • Index Cond: ((turlnr2 = 171494) AND (turlnr1 = 7095))
  • Filter: ((fnotfdat <= '2018-10-21'::date) AND (fnottdat >= '2018-11-15'::date) AND (tillfran = 'T'::bpchar) AND (tidlnr = 8))
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)