explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lXKE : Optimization for: plan #Gkqr

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.074 0.147 ↓ 0.0 0 1

Update on vit_user_touched_tag_count (cost=0.41..8.43 rows=1 width=95) (actual time=0.147..0.147 rows=0 loops=1)

2. 0.073 0.073 ↑ 1.0 1 1

Index Scan using vit_user_touched_tag_count_pkey on vit_user_touched_tag_count (cost=0.41..8.43 rows=1 width=95) (actual time=0.072..0.073 rows=1 loops=1)

  • Index Cond: (((user_id)::text = '078638d98f650593ff2ef5b0431c4bf5'::text) AND ((curr_node_id)::text = 'e8a71fcd04db438e7d5f42c61fa0f40a'::text) AND ((term)::text = '2019-2020'::text))
Planning time : 0.524 ms
Execution time : 0.185 ms