explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9Ztl

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 1,921.654 ↓ 0.0 0 1

Update on permissions_device p (cost=93,241.57..111,925.81 rows=734 width=25) (actual time=1,921.654..1,921.654 rows=0 loops=1)

2. 210.399 1,921.651 ↓ 0.0 0 1

Hash Join (cost=93,241.57..111,925.81 rows=734 width=25) (actual time=1,921.651..1,921.651 rows=0 loops=1)

  • Hash Cond: ((t.device_id = p.device_id) AND (t.user_id = p.user_id))
  • Join Filter: (t.is_implicit <> p.is_implicit)
  • Rows Removed by Join Filter: 1664
3. 0.528 0.528 ↓ 1.0 1,664 1

Seq Scan on tmp_user_device t (cost=0.00..25.64 rows=1,656 width=15) (actual time=0.011..0.528 rows=1,664 loops=1)

  • Filter: (is_implicit IS NOT NULL)
4. 934.493 1,710.724 ↑ 1.0 2,571,103 1

Hash (cost=39,609.03..39,609.03 rows=2,571,103 width=19) (actual time=1,710.724..1,710.724 rows=2,571,103 loops=1)

  • Buckets: 65536 Batches: 64 Memory Usage: 2524kB
5. 776.231 776.231 ↑ 1.0 2,571,103 1

Seq Scan on permissions_device p (cost=0.00..39,609.03 rows=2,571,103 width=19) (actual time=0.007..776.231 rows=2,571,103 loops=1)