explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aKG

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1.083 ↑ 1.0 1 1

Limit (cost=0.43..23.92 rows=1 width=266) (actual time=1.082..1.083 rows=1 loops=1)

2. 1.082 1.082 ↑ 5,480.0 1 1

Index Scan Backward using index_comments_on_created_at on comments (cost=0.43..128,734.87 rows=5,480 width=266) (actual time=1.082..1.082 rows=1 loops=1)

  • Filter: ((commentable_id = 305273) AND ((commentable_type)::text = 'Topic'::text))
  • Rows Removed by Filter: 2506
Planning time : 0.060 ms
Execution time : 1.093 ms