explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CRbd

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

Update on shift_members (cost=64,161.89..1,602,937.21 rows=778,982 width=196) (actual rows= loops=)

  • Update on shift_members_org_part_1_l2_f
  • Update on shift_members_org_part_1_l2_t
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=64,161.89..1,360,272.56 rows=389,491 width=196) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Subquery Scan on sb (cost=64,161.32..70,003.69 rows=389,491 width=56) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Unique (cost=64,161.32..66,108.78 rows=389,491 width=16) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Sort (cost=64,161.32..65,135.05 rows=389,491 width=16) (actual rows= loops=)

  • Sort Key: sync_diff_oltp_deleted_shift_members.revision_uuid
6. 0.000 0.000 ↓ 0.0

Seq Scan on sync_diff_oltp_deleted_shift_members (cost=0.00..23,715.19 rows=389,491 width=16) (actual rows= loops=)

  • Filter: ((organization_uuid <> ALL ('{}'::uuid[])) AND (organization_uuid = 'f3185a16-1604-4839-ba8b-c251a95023d2'::uuid))
7. 0.000 0.000 ↓ 0.0

Index Scan using shift_members_org_part_1_l2_f_revision_uuid_uidx on shift_members_org_part_1_l2_f (cost=0.57..3.31 rows=1 width=146) (actual rows= loops=)

  • Index Cond: (revision_uuid = sb.revision_uuid)
  • Filter: (organization_uuid = 'f3185a16-1604-4839-ba8b-c251a95023d2'::uuid)
8. 0.000 0.000 ↓ 0.0

Merge Join (cost=64,161.75..242,664.65 rows=389,491 width=196) (actual rows= loops=)

  • Merge Cond: (shift_members_org_part_1_l2_t.revision_uuid = sb_1.revision_uuid)
9. 0.000 0.000 ↓ 0.0

Index Scan using shift_members_org_part_1_l2_t_revision_uuid_uidx on shift_members_org_part_1_l2_t (cost=0.43..160,990.21 rows=1,552,375 width=138) (actual rows= loops=)

  • Filter: ((organization_uuid <> ALL ('{}'::uuid[])) AND (organization_uuid = 'f3185a16-1604-4839-ba8b-c251a95023d2'::uuid))
10. 0.000 0.000 ↓ 0.0

Subquery Scan on sb_1 (cost=64,161.32..70,003.69 rows=389,491 width=56) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Unique (cost=64,161.32..66,108.78 rows=389,491 width=16) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Sort (cost=64,161.32..65,135.05 rows=389,491 width=16) (actual rows= loops=)

  • Sort Key: sync_diff_oltp_deleted_shift_members_1.revision_uuid
13. 0.000 0.000 ↓ 0.0

Seq Scan on sync_diff_oltp_deleted_shift_members sync_diff_oltp_deleted_shift_members_1 (cost=0.00..23,715.19 rows=389,491 width=16) (actual rows= loops=)

  • Filter: ((organization_uuid <> ALL ('{}'::uuid[])) AND (organization_uuid = 'f3185a16-1604-4839-ba8b-c251a95023d2'::uuid))