explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GGy5

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 3,151.026 ↓ 0.0 0 1

Sort (cost=721,152.46..721,152.46 rows=1 width=54) (actual time=3,151.026..3,151.026 rows=0 loops=1)

  • Output: id, likable_type, likable_id, liker_type, liker_id, created_at, updated_at
  • Sort Key: likes.created_at
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=649743
2. 3,151.023 3,151.023 ↓ 0.0 0 1

Seq Scan on public.likes (cost=0.00..721,152.45 rows=1 width=54) (actual time=3,151.023..3,151.023 rows=0 loops=1)

  • Output: id, likable_type, likable_id, liker_type, liker_id, created_at, updated_at
  • Filter: ((likes.liker_id = 1234) AND ((likes.liker_type)::text = 'abc'::text))
  • Rows Removed by Filter: 26325511
  • Buffers: shared hit=649743
Planning time : 0.056 ms
Execution time : 3,151.042 ms