explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bx6h : q19-p2y

Settings
# exclusive inclusive rows x rows loops node
1. 2.286 7.326 ↑ 1.0 1 1

Aggregate (cost=2,004.22..2,004.73 rows=1 width=82) (actual time=7.326..7.326 rows=1 loops=1)

2. 0.142 5.040 ↑ 1.0 121 1

Nested Loop (cost=1.12..2,003.01 rows=121 width=82) (actual time=0.184..5.040 rows=121 loops=1)

3. 0.121 2.841 ↑ 1.0 121 1

Nested Loop (cost=0.85..2,000.32 rows=121 width=250) (actual time=0.042..2.841 rows=121 loops=1)

4. 0.110 1.752 ↑ 1.0 121 1

Nested Loop (cost=0.43..1,026.17 rows=121 width=154) (actual time=0.031..1.752 rows=121 loops=1)

5. 0.069 0.069 ↑ 1.0 121 1

Seq Scan on join2 j (cost=0.00..2.51 rows=121 width=8) (actual time=0.015..0.069 rows=121 loops=1)

  • Filter: ((location)::integer = (1)::integer)
6. 1.573 1.573 ↑ 1.0 1 121

Index Scan using lineitem_2_pkey on lineitem_2 l (cost=0.43..8.45 rows=1 width=154) (actual time=0.012..0.013 rows=1 loops=121)

  • Index Cond: (tuid = j.tuid1)
7. 0.968 0.968 ↑ 1.0 1 121

Index Scan using part_2_pkey on part_2 p (cost=0.42..8.04 rows=1 width=104) (actual time=0.007..0.008 rows=1 loops=121)

  • Index Cond: (tuid = j.tuid2)
8. 2.057 2.057 ↑ 1.0 1 121

Function Scan on toy _y (cost=0.27..0.28 rows=1 width=32) (actual time=0.017..0.017 rows=1 loops=121)

Planning time : 2.537 ms
Execution time : 7.515 ms