explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7G7i

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 883.703 ↓ 20.0 20 1

Limit (cost=81,107.73..81,143.41 rows=1 width=814) (actual time=879.216..883.703 rows=20 loops=1)

2. 883.699 883.699 ↓ 20.0 20 1

Nested Loop (cost=81,107.73..81,143.41 rows=1 width=814) (actual time=879.214..883.699 rows=20 loops=1)

  • Join Filter: (product_type_product_group_side.product_group_side_id = pgs2.id)
  • Rows Removed by Join Filter: 346