explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SsaM

Settings
# exclusive inclusive rows x rows loops node
1. 1,089.054 1,382.665 ↓ 0.0 0 1

Update on shift_members (cost=23,755.01..145,623.81 rows=31,404 width=196) (actual time=1,382.664..1,382.665 rows=0 loops=1)

  • Update on shift_members_org_part_2_l2_f
  • Update on shift_members_org_part_2_l2_t
2. 10.663 193.917 ↑ 2.2 7,232 1

Nested Loop (cost=23,755.01..80,254.93 rows=15,702 width=196) (actual time=44.179..193.917 rows=7,232 loops=1)

3. 4.218 53.078 ↑ 2.2 7,232 1

Subquery Scan on sb (cost=23,754.44..24,068.48 rows=15,702 width=56) (actual time=44.072..53.078 rows=7,232 loops=1)

4. 7.316 48.860 ↑ 2.2 7,232 1

HashAggregate (cost=23,754.44..23,911.46 rows=15,702 width=16) (actual time=44.062..48.860 rows=7,232 loops=1)

  • Group Key: sync_diff_oltp_deleted_shift_members.revision_uuid
5. 41.544 41.544 ↑ 2.2 7,232 1

Seq Scan on sync_diff_oltp_deleted_shift_members (cost=0.00..23,715.19 rows=15,702 width=16) (actual time=24.814..41.544 rows=7,232 loops=1)

  • Filter: ((organization_uuid <> ALL ('{}'::uuid[])) AND (organization_uuid = 'def9f910-08cb-4ada-b8b0-2d41faa9e44c'::uuid))
  • Rows Removed by Filter: 190,979
6. 130.176 130.176 ↑ 1.0 1 7,232

Index Scan using shift_members_org_part_2_l2_f_revision_uuid_uidx on shift_members_org_part_2_l2_f (cost=0.57..3.57 rows=1 width=146) (actual time=0.018..0.018 rows=1 loops=7,232)

  • Index Cond: (revision_uuid = sb.revision_uuid)
  • Filter: (organization_uuid = 'def9f910-08cb-4ada-b8b0-2d41faa9e44c'::uuid)
7. 0.000 99.694 ↓ 0.0 0 1

Nested Loop (cost=23,754.87..65,368.88 rows=15,702 width=195) (actual time=99.694..99.694 rows=0 loops=1)

8. 1.923 49.332 ↑ 2.2 7,232 1

Subquery Scan on sb_1 (cost=23,754.44..24,068.48 rows=15,702 width=56) (actual time=44.841..49.332 rows=7,232 loops=1)

9. 5.493 47.409 ↑ 2.2 7,232 1

HashAggregate (cost=23,754.44..23,911.46 rows=15,702 width=16) (actual time=44.832..47.409 rows=7,232 loops=1)

  • Group Key: sync_diff_oltp_deleted_shift_members_1.revision_uuid
10. 41.916 41.916 ↑ 2.2 7,232 1

Seq Scan on sync_diff_oltp_deleted_shift_members sync_diff_oltp_deleted_shift_members_1 (cost=0.00..23,715.19 rows=15,702 width=16) (actual time=24.082..41.916 rows=7,232 loops=1)

  • Filter: ((organization_uuid <> ALL ('{}'::uuid[])) AND (organization_uuid = 'def9f910-08cb-4ada-b8b0-2d41faa9e44c'::uuid))
  • Rows Removed by Filter: 190,979
11. 50.624 50.624 ↓ 0.0 0 7,232

Index Scan using shift_members_org_part_2_l2_t_revision_uuid_uidx on shift_members_org_part_2_l2_t (cost=0.42..2.62 rows=1 width=137) (actual time=0.007..0.007 rows=0 loops=7,232)

  • Index Cond: (revision_uuid = sb_1.revision_uuid)
  • Filter: (organization_uuid = 'def9f910-08cb-4ada-b8b0-2d41faa9e44c'::uuid)
Planning time : 2.698 ms
Execution time : 1,383.798 ms