explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6eAm : 123

Settings
# exclusive inclusive rows x rows loops node
1. 0.239 0.494 ↓ 1.0 148 1

Hash Join (cost=25.39..47.64 rows=145 width=1) (actual time=0.174..0.494 rows=148 loops=1)

  • Output: $1
  • Hash Cond: (devicerevi0_1_.id = devicerevi0_.rev)
  • Buffers: shared hit=22
2.          

Initplan (forHash Join)

3. 0.001 0.026 ↓ 0.0 0 1

Nested Loop (cost=0.28..16.12 rows=1 width=0) (actual time=0.026..0.026 rows=0 loops=1)

  • Inner Unique: true
  • Buffers: shared hit=6
4. 0.025 0.025 ↓ 0.0 0 1

Seq Scan on public.devices_aud devicerevi1_ (cost=0.00..7.81 rows=1 width=4) (actual time=0.025..0.025 rows=0 loops=1)

  • Output: devicerevi1_.rev
  • Filter: (devicerevi1_.uuid = '5334470d-66e7-423b-8692-2c9da00fee08'::uuid)
  • Rows Removed by Filter: 148
  • Buffers: shared hit=6
5. 0.000 0.000 ↓ 0.0 0

Index Scan using user_aware_revision_entities_pkey on public.user_aware_revision_entities devicerevi1_1_ (cost=0.28..8.29 rows=1 width=4) (never executed)

  • Output: devicerevi1_1_.id, devicerevi1_1_."timestamp", devicerevi1_1_.user_uuid
  • Index Cond: (devicerevi1_1_.id = devicerevi1_.rev)
  • Filter: (devicerevi1_1_."timestamp" >= 3)
6. 0.133 0.133 ↓ 1.0 943 1

Seq Scan on public.user_aware_revision_entities devicerevi0_1_ (cost=0.00..16.20 rows=920 width=4) (actual time=0.011..0.133 rows=943 loops=1)

  • Output: devicerevi0_1_.id, devicerevi0_1_."timestamp", devicerevi0_1_.user_uuid
  • Buffers: shared hit=7
7. 0.047 0.096 ↓ 1.0 148 1

Hash (cost=7.45..7.45 rows=145 width=4) (actual time=0.096..0.096 rows=148 loops=1)

  • Output: devicerevi0_.rev
  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
  • Buffers: shared hit=6
8. 0.049 0.049 ↓ 1.0 148 1

Seq Scan on public.devices_aud devicerevi0_ (cost=0.00..7.45 rows=145 width=4) (actual time=0.006..0.049 rows=148 loops=1)

  • Output: devicerevi0_.rev
  • Buffers: shared hit=6
Planning time : 1.188 ms
Execution time : 0.572 ms