explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T4Jl

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

ModifyTable (cost=5.42..7.52 rows=1 width=249) (actual time=0.047..0.047 rows=0 loops=1)

  • Buffers: shared read=1
2. 0.001 0.046 ↓ 0.0 0 1

Nested Loop (cost=5.42..7.52 rows=1 width=249) (actual time=0.046..0.046 rows=0 loops=1)

  • Buffers: shared read=1
3. 0.001 0.045 ↓ 0.0 0 1

Aggregate (cost=5.15..5.16 rows=1 width=98) (actual time=0.045..0.045 rows=0 loops=1)

  • Buffers: shared read=1
4. 0.001 0.044 ↓ 0.0 0 1

Subquery Scan on ANY_subquery (cost=0.14..5.15 rows=1 width=98) (actual time=0.044..0.044 rows=0 loops=1)

  • Buffers: shared read=1
5. 0.001 0.043 ↓ 0.0 0 1

LockRows (cost=0.14..5.14 rows=1 width=43) (actual time=0.043..0.043 rows=0 loops=1)

  • Buffers: shared read=1
6. 0.042 0.042 ↓ 0.0 0 1

Index Scan using test_iscale_client_registry on iscale_client_registry x (cost=0.14..5.13 rows=1 width=43) (actual time=0.042..0.042 rows=0 loops=1)

  • Index Cond: (((x.datastore_id)::text = 'bf22fd65-9aaf-4beb-9ab9-94c6e18cffe9'::text) AND (x.last_accessed_dt < '2019-02-20 1 1:29:00'::timestamp without time zone))
  • Filter: (x.updator_ind OR (x.updator_ind IS NULL))
  • Buffers: shared read=1
7. 0.000 0.000 ↓ 0.0 0 0

Index Scan using iscale_client_registry_pkey on iscale_client_registry iscale_client_registry (cost=0.27..2.28 rows=1 width=187) (never executed)

  • Index Cond: ((iscale_client_registry.rid)::text = ("ANY_subquery".rid)::text)