explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LSzc

Settings
# exclusive inclusive rows x rows loops node
1. 3.196 11.352 ↑ 1.0 1,048 1

GroupAggregate (cost=262.96..321.03 rows=1,055 width=74) (actual time=7.575..11.352 rows=1,048 loops=1)

  • Group Key: object_id
2. 7.245 8.156 ↑ 1.0 3,144 1

Sort (cost=262.96..270.89 rows=3,169 width=74) (actual time=7.550..8.156 rows=3,144 loops=1)

  • Sort Key: object_id
  • Sort Method: quicksort Memory: 539kB
3. 0.911 0.911 ↑ 1.0 3,144 1

Seq Scan on comment_like (cost=0.00..78.69 rows=3,169 width=74) (actual time=0.017..0.911 rows=3,144 loops=1)

Planning time : 0.150 ms
Execution time : 11.500 ms