Odoo 20.0 Community · Persistent

ir.profile.query: fields, relations and API

The ir.profile.query model ("Profiling Query") is a persistent model declared by the Base module. It exposes 9 fields, 7 of them declared directly on the model. Below you will find every field with its technical name, type, label and relations, followed by an Odoo 20 JSON-2 API call.

View source code Search another model

Model identity

Technical name: ir.profile.query
Label: Profiling Query
Type: Persistent (models.Model)
SQL table: ir_profile_query
Origin module: Base (base)
Default order (_order): id asc
Display field (_rec_name): query_preview

Model fields

7 own fields, 0 inherited from mixins and 2 automatic ORM fields. Click a name to get a direct link to that field.

Hide inherited fields

9 of 9 fields shown

Technical name	Label	Type	Details
formatted_query	Formatted Query	`text`	computed
full_query	Full Query Query with its parameters injected, ready to execute	`text`	required
plan	Query Plan	`text`
profile_id	Profile	`many2one` → ir.profile	required
query	Query Query with placeholders, before injecting the parameters	`text`	read-only
query_preview	Query Preview	`text`	computed
time	Time Time spent executing the query (seconds)	`float`
display_name	Display Name	`char`	read-onlycomputedautomatic
id	ID	`integer`	read-onlyautomatic

Relations

Models linked from this model

ir.profile: profile_id

Fields of other models pointing here

No Many2one or Many2many field of another model points to this model.

Reading this model through the API

Odoo 20 JSON-2 API call reading the first five records with real fields of the model. Replace the instance, database and API key with your own.

curl

curl -X POST "https://your-instance.odoo.com/json/2/ir.profile.query/search_read" \
  -H "Authorization: bearer $ODOO_API_KEY" \
  -H "X-Odoo-Database: your-db" \
  -H "Content-Type: application/json" \
  -d '{"domain":[],"fields":["query_preview","full_query","profile_id","plan","query"],"limit":5}'

Python (requests)

import requests

BASE_URL = "https://your-instance.odoo.com/json/2"
headers = {"Authorization": f"bearer {API_KEY}", "X-Odoo-Database": "your-db"}

res = requests.post(
    f"{BASE_URL}/ir.profile.query/search_read",
    headers=headers,
    json={"domain": [], "fields": ["query_preview","full_query","profile_id","plan","query"], "limit": 5},
)
res.raise_for_status()
print(res.json())

External API access requires Odoo's Custom plan.
XML-RPC and JSON-RPC will be removed in Odoo 22 (fall 2028): use JSON-2.
The access rights and record rules of the key's user apply.

Cite this tool

Writing a tutorial, internal documentation or a forum answer? Copy this link to send your readers to the up-to-date reference.

<a href="https://aidoo.ai/en/outils/explorateur-modeles-odoo/ir-profile-query">ir.profile.query (Odoo 20.0)</a>

Sources

Data verified on September 25, 2026 · Odoo 20.0 Community

Have an Odoo project, or want to put your ERP to work with AI? Let's talk

Implementation, custom module development, connecting Claude or ChatGPT to your data: tell us about your context and we will reply within 24 business hours.