explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GvAo

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.010 ↓ 0.0 0 1

Nested Loop (cost=4.47..23.99 rows=1 width=216) (actual time=0.010..0.010 rows=0 loops=1)

2. 0.001 0.009 ↓ 0.0 0 1

Nested Loop (cost=4.32..19.48 rows=1 width=152) (actual time=0.009..0.009 rows=0 loops=1)

3. 0.008 0.008 ↓ 0.0 0 1

Index Scan using index_udm_schemas_on_resource_type_and_company_entity_id on user_defined_metadata_schemas (cost=0.15..8.17 rows=1 width=60) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (((resource_type)::text = 'Shipments'::text) AND (company_entity_id = 1))
4. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on user_defined_metadata_schema_definitions (cost=4.17..11.30 rows=1 width=92) (never executed)

  • Recheck Cond: (user_defined_metadata_schema_id = user_defined_metadata_schemas.id)
  • Filter: (((label)::text = 'key1'::text) OR ((label)::text = 'key2'::text))
5. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on index_udm_schema_definitions_on_udm_schema_id_and_label (cost=0.00..4.17 rows=3 width=0) (never executed)

  • Index Cond: (user_defined_metadata_schema_id = user_defined_metadata_schemas.id)
6. 0.000 0.000 ↓ 0.0 0

Index Scan using index_udm_metadata_on_udm_schema_definition_id_and_resource_id on user_defined_metadata_metadata (cost=0.15..4.51 rows=1 width=64) (never executed)

  • Index Cond: ((user_defined_metadata_schema_definition_id = user_defined_metadata_schema_definitions.id) AND (resource_id = ANY ('{1,2,3}'::integer[])))
  • Filter: ((((value)::text = 'foo'::text) OR ((value)::text = 'bar'::text)) AND ((((value)::text = 'foo'::text) AND ((user_defined_metadata_schema_definitions.label)::text = 'key1'::text)) OR (((value)::text = 'bar'::text) AND ((user_defined_metadata_schema_definitions.label)::text = 'key2'::text))))
Planning time : 0.947 ms
Execution time : 0.076 ms