explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SN1f

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 1,801.207 ↑ 1.0 100 1

Limit (cost=15.86..60.56 rows=100 width=32) (actual time=1,766.309..1,801.207 rows=100 loops=1)

2.          

CTE dublicate_users

3. 0.341 0.341 ↑ 1.0 340 1

Values Scan on "*VALUES*" (cost=0.00..4.25 rows=340 width=32) (actual time=0.004..0.341 rows=340 loops=1)

4. 800.469 1,801.194 ↑ 15,956.1 100 1

Hash Join (cost=11.61..713,276.55 rows=1,595,608 width=32) (actual time=1,766.308..1,801.194 rows=100 loops=1)

  • Hash Cond: (t_upd.owner_id = dublicate_users.dublicate_id)
5. 999.785 999.785 ↑ 1.2 4,451,029 1

Index Scan using i__motion__account_id on motion t_upd (cost=0.56..460,474.20 rows=5,263,005 width=32) (actual time=0.358..999.785 rows=4,451,029 loops=1)

  • Index Cond: (account_id = 'ed1d05b1-e159-11e6-7a69-971100001e4d'::uuid)
6. 0.199 0.940 ↑ 1.0 340 1

Hash (cost=6.80..6.80 rows=340 width=32) (actual time=0.940..0.940 rows=340 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
7. 0.741 0.741 ↑ 1.0 340 1

CTE Scan on dublicate_users (cost=0.00..6.80 rows=340 width=32) (actual time=0.011..0.741 rows=340 loops=1)

Planning time : 1.418 ms
Execution time : 1,801.299 ms