explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3JAF : New Index

Settings

Optimization path:

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

Limit (cost=0.42..0.81 rows=1 width=16) (actual time=0.023..0.024 rows=1 loops=1)

2. 0.004 0.023 ↑ 4,459.0 1 1

Nested Loop (cost=0.42..1,730.15 rows=4,459 width=16) (actual time=0.022..0.023 rows=1 loops=1)

3. 0.015 0.015 ↑ 5,708.0 1 1

Index Scan Backward using useractions_useraction_created_idx on useractions_useraction uu (cost=0.28..815.06 rows=5,708 width=16) (actual time=0.015..0.015 rows=1 loops=1)

4. 0.004 0.004 ↑ 1.0 1 1

Index Scan using userdata_userinfo_user_id_key on userdata_userinfo ui (cost=0.14..0.16 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: (user_id = uu.user_id)
  • Filter: (organization_id = 1,753)
Planning time : 0.425 ms
Execution time : 0.047 ms