explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I2eu : Prashant

Settings
# exclusive inclusive rows x rows loops node
1. 0.036 0.362 ↑ 1.0 1 1

Aggregate (cost=66,565.45..66,565.46 rows=1 width=5) (actual time=0.362..0.362 rows=1 loops=1)

2. 0.035 0.326 ↑ 17.0 62 1

Nested Loop (cost=32.72..66,562.81 rows=1,053 width=5) (actual time=0.147..0.326 rows=62 loops=1)

3. 0.025 0.082 ↑ 8.0 11 1

Bitmap Heap Scan on org_users ou (cost=22.80..356.14 rows=88 width=13) (actual time=0.064..0.082 rows=11 loops=1)

  • Recheck Cond: ((department_id)::text = ANY ('{deptGrIYQnMfXS,deptiGWDgHwwCi,dept8K3MRXY9E2,deptm1PZSZRknf,deptjCU6eeGaFp}'::text[]))
  • Heap Blocks: exact=10
4. 0.057 0.057 ↑ 8.0 11 1

Bitmap Index Scan on idx_org_users_dept_id (cost=0.00..22.78 rows=88 width=0) (actual time=0.057..0.057 rows=11 loops=1)

  • Index Cond: ((department_id)::text = ANY ('{deptGrIYQnMfXS,deptiGWDgHwwCi,dept8K3MRXY9E2,deptm1PZSZRknf,deptjCU6eeGaFp}'::text[]))
5. 0.088 0.209 ↑ 32.2 6 11

Bitmap Heap Scan on transactions txn (cost=9.93..750.42 rows=193 width=18) (actual time=0.013..0.019 rows=6 loops=11)

  • Recheck Cond: ((org_user_id)::text = (ou.id)::text)
  • Heap Blocks: exact=37
6. 0.121 0.121 ↑ 32.2 6 11

Bitmap Index Scan on idx_transactions_org_user_id (cost=0.00..9.88 rows=193 width=0) (actual time=0.011..0.011 rows=6 loops=11)

  • Index Cond: ((org_user_id)::text = (ou.id)::text)
Planning time : 0.465 ms
Execution time : 0.418 ms