explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bG2O

Settings
# exclusive inclusive rows x rows loops node
1. 70.004 70.004 ↓ 1.0 137,857 1

Seq Scan on discount_relations (cost=0.00..5,135.22 rows=137,847 width=119) (actual time=0.013..70.004 rows=137,857 loops=1)

  • Filter: (((discountable_id)::text = '37085bff-f591-4344-a848-de2269e6c4e8'::text) AND ((discountable_type)::text = 'CartDiscount'::text) AND ((relation_type)::text = 'apply'::text) AND ((discount_relatable_type)::text = 'Sku'::text))
  • Rows Removed by Filter: 3
Planning time : 0.180 ms
Execution time : 76.870 ms