explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 619i : FTS with Count

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 11,706.167 ↑ 1.0 1 1

Limit (cost=0.00..6.88 rows=1 width=2,255) (actual time=11,706.166..11,706.167 rows=1 loops=1)

2. 832.087 11,706.165 ↑ 266,443.0 1 1

WindowAgg (cost=0.00..1,833,089.40 rows=266,443 width=2,255) (actual time=11,706.165..11,706.165 rows=1 loops=1)

3. 10,874.078 10,874.078 ↑ 1.0 263,121 1

Seq Scan on products (cost=0.00..1,829,758.86 rows=266,443 width=2,247) (actual time=0.021..10,874.078 rows=263,121 loops=1)

  • Filter: ((_search @@ '''wall'''::tsquery) AND ((store_id)::text = '9WtSLypBB'::text))
  • Rows Removed by Filter: 2,047,397
Planning time : 1.239 ms
Execution time : 11,728.906 ms