explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PTXM

Settings
# exclusive inclusive rows x rows loops node
1. 0.349 82.043 ↓ 0.0 0 1

Update on shift_members (cost=23,716.64..23,849.66 rows=39 width=195) (actual time=82.043..82.043 rows=0 loops=1)

  • Update on shift_members_org_part_118
2. 0.058 81.694 ↑ 39.0 1 1

Nested Loop (cost=23,716.64..23,849.66 rows=39 width=195) (actual time=81.691..81.694 rows=1 loops=1)

3. 0.819 81.547 ↑ 39.0 1 1

Subquery Scan on sb (cost=23,716.22..23,716.80 rows=39 width=56) (actual time=81.545..81.547 rows=1 loops=1)

4. 0.003 80.728 ↑ 39.0 1 1

Unique (cost=23,716.22..23,716.41 rows=39 width=16) (actual time=80.727..80.728 rows=1 loops=1)

5. 0.017 80.725 ↑ 39.0 1 1

Sort (cost=23,716.22..23,716.32 rows=39 width=16) (actual time=80.725..80.725 rows=1 loops=1)

  • Sort Key: sync_diff_oltp_deleted_shift_members.revision_uuid
  • Sort Method: quicksort Memory: 25kB
6. 80.708 80.708 ↑ 39.0 1 1

Seq Scan on sync_diff_oltp_deleted_shift_members (cost=0.00..23,715.19 rows=39 width=16) (actual time=65.296..80.708 rows=1 loops=1)

  • Filter: ((organization_uuid <> ALL ('{}'::uuid[])) AND (organization_uuid = '83078fa3-f643-4128-944e-486ede2a6b37'::uuid))
  • Rows Removed by Filter: 198,210
7. 0.089 0.089 ↑ 1.0 1 1

Index Scan using shift_members_org_part_118_revision_uuid_uidx on shift_members_org_part_118 (cost=0.42..3.40 rows=1 width=144) (actual time=0.089..0.089 rows=1 loops=1)

  • Index Cond: (revision_uuid = sb.revision_uuid)
  • Filter: (organization_uuid = '83078fa3-f643-4128-944e-486ede2a6b37'::uuid)
Planning time : 1.644 ms
Execution time : 82.266 ms