explain.depesz.com

PostgreSQL's explain analyze made readable

Result: htOM

Settings
# exclusive inclusive rows x rows loops node
1. 0.023 0.346 ↓ 20.0 20 1

Nested Loop (cost=3.13..4.67 rows=1 width=136) (actual time=0.105..0.346 rows=20 loops=1)

  • Join Filter: (t.i = t4.i)
2. 0.024 0.223 ↓ 20.0 20 1

Merge Left Join (cost=2.70..4.21 rows=1 width=144) (actual time=0.095..0.223 rows=20 loops=1)

  • Merge Cond: (t.i = t3.i)
3. 0.020 0.165 ↓ 10.0 10 1

Nested Loop (cost=2.41..2.96 rows=1 width=122) (actual time=0.083..0.165 rows=10 loops=1)

  • Join Filter: (t.i = t2.i)
4. 0.012 0.105 ↓ 10.0 10 1

Merge Join (cost=2.13..2.64 rows=1 width=114) (actual time=0.071..0.105 rows=10 loops=1)

  • Merge Cond: (t.i = t6.i)
5. 0.017 0.077 ↓ 10.0 10 1

Merge Join (cost=1.70..1.80 rows=1 width=61) (actual time=0.058..0.077 rows=10 loops=1)

  • Merge Cond: (t.i = t5.i)
6. 0.016 0.030 ↑ 1.0 10 1

Sort (cost=1.27..1.29 rows=10 width=8) (actual time=0.028..0.030 rows=10 loops=1)

  • Sort Key: t.i
  • Sort Method: quicksort Memory: 25kB
7. 0.014 0.014 ↑ 1.0 10 1

Seq Scan on t (cost=0.00..1.10 rows=10 width=8) (actual time=0.012..0.014 rows=10 loops=1)

8. 0.030 0.030 ↑ 196.4 10 1

Index Scan using t5_pkey on t5 (cost=0.43..84.80 rows=1,964 width=53) (actual time=0.025..0.030 rows=10 loops=1)

  • Index Cond: (i < 2000)
9. 0.016 0.016 ↑ 399,997.9 10 1

Index Scan using t6_pkey on t6 (cost=0.43..149,338.11 rows=3,999,979 width=53) (actual time=0.011..0.016 rows=10 loops=1)

10. 0.040 0.040 ↑ 1.0 1 10

Index Scan using t2_ix_i on t2 (cost=0.29..0.30 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=10)

  • Index Cond: (i = t6.i)
11. 0.034 0.034 ↑ 3,809.5 21 1

Index Scan using t3_ix_i on t3 (cost=0.29..4,204.48 rows=80,000 width=26) (actual time=0.010..0.034 rows=21 loops=1)

12. 0.100 0.100 ↑ 1.0 1 20

Index Scan using t4_ix_i on t4 (cost=0.42..0.45 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=20)

  • Index Cond: (i = t6.i)
Planning time : 4.996 ms
Execution time : 0.465 ms