explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FElH

Settings
# exclusive inclusive rows x rows loops node
1. 0.873 0.888 ↓ 867.3 2,602 1

"QUERY PLAN": "Seq Scan on userspace_10.client (cost=1.04..120.54 rows=3 width=4) (actual time=0.030..0.888 rows=2,602 loops=1)

  • },
  • "QUERY PLAN": " Output: client.id
  • },
  • "QUERY PLAN": " Filter: (client.access_descriptors @> $0)
  • },
  • "QUERY PLAN": " InitPlan 1 (returns $0)
  • },
  • },
  • "QUERY PLAN": " Output: (\"user\".options #> '{descriptors,client}'::text[])
  • },
  • "QUERY PLAN": " Filter: (\"user\".identity_id = (current_setting('app.user_id'::text))::integer)
  • },
  • "QUERY PLAN": " Rows Removed by Filter: 2
  • },
  • "QUERY PLAN": "Planning Time: 0.079 ms
  • },
  • "QUERY PLAN": "Execution Time: 1.034 ms
  • }]
2. 0.015 0.015 ↑ 1.0 1 1

"QUERY PLAN": " -> Seq Scan on userspace_10.\"user\" (cost=0.00..1.04 rows=1 width=32) (actual time=0.015..0.015 rows=1 loops=1)