explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 65r2

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

Limit (cost=1,131.51..107,280,938.54 rows=7 width=1,629) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

WindowAgg (cost=1,131.51..107,280,938.54 rows=7 width=1,629) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Limit (cost=1,131.51..107,280,938.38 rows=7 width=1,621) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Unique (cost=1,131.51..107,280,938.38 rows=7 width=1,621) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Merge Join (cost=1,131.51..91,387,299.08 rows=6,357,455,718 width=1,621) (actual rows= loops=)

  • Merge Cond: (datawarehouse_usergroupstorelatest.user_group_id = datawarehouse_usergrouppermissionstore311521657385909248.user_group_id)
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=21.24..412,767.99 rows=19,226,676 width=1,637) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=20.96..1,922.83 rows=74,638 width=1,645) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=20.69..327.20 rows=290 width=1,653) (actual rows= loops=)

  • Join Filter: (datawarehouse_usergroupstorelatest.user_group_id = datawarehouse_usergrouppermissionstore311521657385909250.user_group_id)
9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=10.42..108.60 rows=45 width=1,637) (actual rows= loops=)

  • Join Filter: (datawarehouse_usergroupstorelatest.user_group_id = datawarehouse_usergrouppermissionstore311521657385909252.user_group_id)
10. 0.000 0.000 ↓ 0.0

Index Scan Backward using "PK_user_group_id_latest" on datawarehouse_usergroupstorelatest (cost=0.14..36.37 rows=7 width=1,621) (actual rows= loops=)

  • Index Cond: (user_group_id <= '311507559625523200'::bigint)
  • Filter: active
11. 0.000 0.000 ↓ 0.0

Materialize (cost=10.28..45.79 rows=258 width=16) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on datawarehouse_usergrouppermissionstore datawarehouse_usergrouppermissionstore311521657385909252 (cost=10.28..44.50 rows=258 width=16) (actual rows= loops=)

  • Recheck Cond: ((action)::text = 'READ'::text)
  • Filter: active
13. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "IDX_datawarehouse_userGroupPermissionStore_action" (cost=0.00..10.21 rows=258 width=0) (actual rows= loops=)

  • Index Cond: ((action)::text = 'READ'::text)
14. 0.000 0.000 ↓ 0.0

Materialize (cost=10.27..45.77 rows=257 width=16) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on datawarehouse_usergrouppermissionstore datawarehouse_usergrouppermissionstore311521657385909250 (cost=10.27..44.48 rows=257 width=16) (actual rows= loops=)

  • Recheck Cond: ((action)::text = 'DELETE'::text)
  • Filter: active
16. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "IDX_datawarehouse_userGroupPermissionStore_action" (cost=0.00..10.21 rows=257 width=0) (actual rows= loops=)

  • Index Cond: ((action)::text = 'DELETE'::text)
17. 0.000 0.000 ↓ 0.0

Index Only Scan using "IDX_datawarehouse_userGroupPermissionStorelatest_update_id" on datawarehouse_usergrouppermissionstorelatest datawarehouse_usergrouppermissionstorelatest311521657385909253 (cost=0.28..3.82 rows=168 width=8) (actual rows= loops=)

  • Index Cond: (update_id = datawarehouse_usergrouppermissionstore311521657385909252.update_id)
18. 0.000 0.000 ↓ 0.0

Index Only Scan using "IDX_datawarehouse_userGroupPermissionStorelatest_update_id" on datawarehouse_usergrouppermissionstorelatest datawarehouse_usergrouppermissionstorelatest311521657385909251 (cost=0.28..3.82 rows=168 width=8) (actual rows= loops=)

  • Index Cond: (update_id = datawarehouse_usergrouppermissionstore311521657385909250.update_id)
19. 0.000 0.000 ↓ 0.0

Sort (cost=1,110.26..1,141.79 rows=12,611 width=8) (actual rows= loops=)

  • Sort Key: datawarehouse_usergrouppermissionstore311521657385909248.user_group_id DESC
20. 0.000 0.000 ↓ 0.0

Hash Join (cost=76.30..251.30 rows=12,611 width=8) (actual rows= loops=)

  • Hash Cond: (datawarehouse_usergrouppermissionstore311521657385909248.update_id = datawarehouse_usergrouppermissionstorelatest311521657385909249.update_id)
21. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on datawarehouse_usergrouppermissionstore datawarehouse_usergrouppermissionstore311521657385909248 (cost=4.66..37.44 rows=49 width=16) (actual rows= loops=)

  • Recheck Cond: ((resource)::text = 'AUDIT'::text)
  • Filter: active
22. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "IDX_datawarehouse_userGroupPermissionStore_resource" (cost=0.00..4.64 rows=49 width=0) (actual rows= loops=)

  • Index Cond: ((resource)::text = 'AUDIT'::text)
23. 0.000 0.000 ↓ 0.0

Hash (cost=48.51..48.51 rows=1,851 width=8) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Seq Scan on datawarehouse_usergrouppermissionstorelatest datawarehouse_usergrouppermissionstorelatest311521657385909249 (cost=0.00..48.51 rows=1,851 width=8) (actual rows= loops=)