explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hckw

Settings
# exclusive inclusive rows x rows loops node
1. 22,800.126 45,847.599 ↑ 1.0 1 1

Aggregate (cost=259,534.61..259,534.62 rows=1 width=0) (actual time=45,847.596..45,847.599 rows=1 loops=1)

2. 23,047.473 23,047.473 ↑ 1.0 9,116,158 1

Index Only Scan using facet_set_product_orders_facet_set_id_index on facet_set_product_orders (cost=0.43..236,742.88 rows=9,116,696 width=0) (actual time=0.049..23,047.473 rows=9,116,158 loops=1)

  • Heap Fetches: 0