explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uzkn

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 34.099 ↑ 1.0 1 1

Limit (cost=0.71..12.75 rows=1 width=4) (actual time=34.093..34.099 rows=1 loops=1)

2. 0.011 34.096 ↑ 1.0 1 1

Nested Loop (cost=0.71..12.75 rows=1 width=4) (actual time=34.091..34.096 rows=1 loops=1)

3. 23.614 23.614 ↑ 1.0 1 1

Index Scan using pk_roadworkrequestcomment on comment "Extent1" (cost=0.43..8.45 rows=1 width=4) (actual time=23.610..23.614 rows=1 loops=1)

  • Index Cond: (id = 1354221)
4. 10.471 10.471 ↑ 1.0 1 1

Index Only Scan using pk_user on "user" "Extent2" (cost=0.29..4.30 rows=1 width=4) (actual time=10.471..10.471 rows=1 loops=1)

  • Index Cond: (id = "Extent1".userid)
  • Heap Fetches: 0
Planning time : 97.645 ms