explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P3xy

Settings
# exclusive inclusive rows x rows loops node
1. 455.658 798.062 ↑ 6,758.0 43 1

Seq Scan on user_entity ue (cost=12.50..25,070.00 rows=290,592 width=75) (actual time=745.478..798.062 rows=43 loops=1)

  • Filter: ((NOT (hashed SubPlan 1)) AND ((username)::text !~* 'sm-'::text) AND ((realm_id)::text = 'EduPowerKeycloak'::text))
  • Rows Removed by Filter: 587,600
2.          

SubPlan (for Seq Scan)

3. 342.404 342.404 ↓ 587.2 587,232 1

Function Scan on dblink u (cost=0.00..10.00 rows=1,000 width=32) (actual time=282.548..342.404 rows=587,232 loops=1)

Planning time : 0.143 ms
Execution time : 806.990 ms