explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ki6w : FTS no Count

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1.571 ↑ 1.0 1 1

Limit (cost=0.00..6.87 rows=1 width=2,247) (actual time=1.570..1.571 rows=1 loops=1)

2. 1.569 1.569 ↑ 266,443.0 1 1

Seq Scan on products (cost=0.00..1,829,758.86 rows=266,443 width=2,247) (actual time=1.569..1.569 rows=1 loops=1)

  • Filter: ((_search @@ '''wall'''::tsquery) AND ((store_id)::text = '9WtSLypBB'::text))
  • Rows Removed by Filter: 1
Planning time : 1.781 ms
Execution time : 1.896 ms