explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PVky

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.052 ↑ 1.0 1 1

Sort (cost=8.45..8.45 rows=1 width=197) (actual time=0.052..0.052 rows=1 loops=1)

  • Sort Key: id
  • Sort Method: quicksort Memory: 25kB
2. 0.041 0.041 ↑ 1.0 1 1

Index Scan using idx_text_assignment on sungero_wf_text texts0_ (cost=0.42..8.44 rows=1 width=197) (actual time=0.040..0.041 rows=1 loops=1)

  • Index Cond: (assignment = 870)
Planning time : 0.211 ms
Execution time : 0.098 ms