explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JvPN : Existing Indexes

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 2.818 ↑ 1.0 1 1

Limit (cost=815.04..815.04 rows=1 width=16) (actual time=2.818..2.818 rows=1 loops=1)

2. 0.497 2.817 ↑ 4,459.0 1 1

Sort (cost=815.04..826.19 rows=4,459 width=16) (actual time=2.817..2.817 rows=1 loops=1)

  • Sort Key: uu.created DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 1.280 2.320 ↓ 1.1 4,703 1

Hash Join (cost=16.70..792.74 rows=4,459 width=16) (actual time=0.044..2.320 rows=4,703 loops=1)

  • Hash Cond: (uu.user_id = ui.user_id)
4. 1.005 1.005 ↑ 1.0 5,708 1

Seq Scan on useractions_useraction uu (cost=0.00..759.08 rows=5,708 width=16) (actual time=0.003..1.005 rows=5,708 loops=1)

5. 0.007 0.035 ↓ 1.5 37 1

Hash (cost=16.39..16.39 rows=25 width=8) (actual time=0.035..0.035 rows=37 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
6. 0.028 0.028 ↓ 1.5 37 1

Seq Scan on userdata_userinfo ui (cost=0.00..16.39 rows=25 width=8) (actual time=0.004..0.028 rows=37 loops=1)

  • Filter: (organization_id = 1,753)
  • Rows Removed by Filter: 16
Planning time : 0.286 ms
Execution time : 2.844 ms