explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4tXv : myplan

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=119,735.95..119,744.70 rows=100 width=352) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Unique (cost=119,735.95..135,295.03 rows=177,818 width=352) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=119,735.95..120,180.50 rows=177,818 width=352) (actual rows= loops=)

  • Sort Key: oms_orderexecutive.id DESC, oms_orderexecutive.create_date, oms_orderexecutive.update_date, oms_orderexecutive.user_id, oms_orderexecutive.enabled, oms_orderexecutive.phone, oms_orderexecutive.role_id, oms_orderexecutive.outsourcer_id, oms_orderexecutive.last_assigned_time, oms_orderexecutive.last_free_time, oms_orderexecutive.rating, oms_orderexecutive.current_order_count, oms_orderexecutive.start_duty, oms_orderexecutive.group_id, oms_orderexecutive.source_city_id, oms_orderexecutive.assignment_source, auth_user.password, auth_user.last_login, auth_user.is_superuser, auth_user.username, auth_user.first_name, auth_user.last_name, auth_user.email, auth_user.is_staff, auth_user.is_active, auth_user.date_joined, oms_oerole.create_date, oms_oerole.update_date, oms_oerole.role, oms_outsource.create_date, oms_outsource.update_date, oms_outsource.name, oms_outsource.rating, oms_outsource.percentage
4. 0.000 0.000 ↓ 0.0

Gather (cost=1,002.74..54,033.89 rows=177,818 width=352) (actual rows= loops=)

  • Workers Planned: 1
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.73..35,252.09 rows=104,599 width=352) (actual rows= loops=)

  • Hash Cond: (oms_orderexecutive.outsourcer_id = oms_outsource.id)
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.58..33,812.69 rows=104,599 width=313) (actual rows= loops=)

  • Hash Cond: (oms_orderexecutive.role_id = oms_oerole.id)
7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..32,373.30 rows=104,599 width=283) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on auth_user (cost=0.00..1,431.37 rows=14,437 width=152) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Scan using oms_orderexecutive_user_id_key on oms_orderexecutive (cost=0.42..2.13 rows=1 width=131) (actual rows= loops=)

  • Index Cond: (user_id = auth_user.id)
10. 0.000 0.000 ↓ 0.0

Hash (cost=1.07..1.07 rows=7 width=30) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on oms_oerole (cost=0.00..1.07 rows=7 width=30) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash (cost=1.07..1.07 rows=7 width=39) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on oms_outsource (cost=0.00..1.07 rows=7 width=39) (actual rows= loops=)