explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CVtW

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 72.910 ↓ 0.0 0 1

Unique (cost=28,358.91..28,359.99 rows=216 width=16) (actual time=72.910..72.910 rows=0 loops=1)

2. 0.009 72.909 ↓ 0.0 0 1

Sort (cost=28,358.91..28,359.45 rows=216 width=16) (actual time=72.909..72.909 rows=0 loops=1)

  • Sort Key: s.recipient_uuid
  • Sort Method: quicksort Memory: 25kB
3. 0.000 72.900 ↓ 0.0 0 1

Nested Loop (cost=1,000.55..28,350.54 rows=216 width=16) (actual time=72.900..72.900 rows=0 loops=1)

  • Join Filter: (s.commit_date >= v.validation_timestamp)
4. 14.172 80.175 ↓ 0.0 0 1

Gather (cost=1,000.00..28,279.81 rows=216 width=24) (actual time=72.899..80.175 rows=0 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
5. 66.003 66.003 ↓ 0.0 0 4 / 4

Parallel Seq Scan on sync_diff_oltp_devices s (cost=0.00..27,258.21 rows=70 width=24) (actual time=66.003..66.003 rows=0 loops=4)

  • Filter: (organization_uuid = '7220e4d2-7300-4aee-85c3-7fbdc6b6b6ab'::uuid)
  • Rows Removed by Filter: 442,510
6. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.56..61.01 rows=3 width=8) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Subquery Scan on v (cost=0.56..61.00 rows=3 width=8) (never executed)

  • Filter: ((v.rn = 1) OR (v.recover_timestamp IS NULL))
8. 0.000 0.000 ↓ 0.0 0

WindowAgg (cost=0.56..60.52 rows=38 width=89) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using completed_validations_org_tab_tz_pk on completed_validations (cost=0.56..59.76 rows=38 width=81) (never executed)

  • Index Cond: ((organization_uuid = '7220e4d2-7300-4aee-85c3-7fbdc6b6b6ab'::uuid) AND ((diff_table)::text = 'auditstore_validate.sync_diff_oltp_devices'::text))
Planning time : 0.196 ms
Execution time : 80.303 ms