explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iFfh

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.064 ↑ 1.0 1 1

Aggregate (cost=23.09..23.10 rows=1 width=32) (actual time=0.064..0.064 rows=1 loops=1)

2. 0.007 0.062 ↓ 0.0 0 1

Sort (cost=23.06..23.06 rows=2 width=16) (actual time=0.062..0.062 rows=0 loops=1)

  • Sort Key: (row_number() OVER (?))
  • Sort Method: quicksort Memory: 25kB
3. 0.000 0.055 ↓ 0.0 0 1

Unique (cost=23.02..23.03 rows=2 width=16) (actual time=0.055..0.055 rows=0 loops=1)

4. 0.003 0.055 ↓ 0.0 0 1

Sort (cost=23.02..23.02 rows=2 width=16) (actual time=0.055..0.055 rows=0 loops=1)

  • Sort Key: mv1.content_pid
  • Sort Method: quicksort Memory: 25kB
5. 0.001 0.052 ↓ 0.0 0 1

WindowAgg (cost=0.00..22.99 rows=2 width=16) (actual time=0.052..0.052 rows=0 loops=1)

6. 0.000 0.051 ↓ 0.0 0 1

Nested Loop (cost=0.00..22.96 rows=2 width=8) (actual time=0.051..0.051 rows=0 loops=1)

  • Join Filter: (mv1.content_pid = sv.content_pid)
7. 0.001 0.051 ↓ 0.0 0 1

Append (cost=0.00..8.16 rows=2 width=8) (actual time=0.051..0.051 rows=0 loops=1)

8. 0.027 0.027 ↓ 0.0 0 1

Seq Scan on resource_multivalued_index mv1 (cost=0.00..0.00 rows=1 width=8) (actual time=0.027..0.027 rows=0 loops=1)

  • Filter: ((type = ANY ('{Observation}'::text[])) AND ('org.1994969384149321699'::ltree @> materialized_path) AND (param_name = 'code'::text) AND (_search_token_code(search_value) = '11557-6'::text))
9. 0.023 0.023 ↓ 0.0 0 1

Index Scan using _indx_observation_multivalued_index_search_code_code on observation_multivalued_index mv1_1 (cost=0.14..8.16 rows=1 width=8) (actual time=0.023..0.023 rows=0 loops=1)

  • Index Cond: (_search_token_code(search_value) = '11557-6'::text)
  • Filter: ((type = ANY ('{Observation}'::text[])) AND ('org.1994969384149321699'::ltree @> materialized_path))
  • Rows Removed by Filter: 1
10. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..14.75 rows=2 width=8) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..14.74 rows=2 width=8) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Seq Scan on resource_index sv (cost=0.00..0.00 rows=1 width=8) (never executed)

  • Filter: ((type = ANY ('{Observation}'::text[])) AND ('org.1994969384149321699'::ltree @> materialized_path) AND (_search_date('date'::text, search_value) &< '["2013-04-06 00:00:00+05:30","2013-04-06 00:00:00+05:30"]'::tstzrange) AND (_search_date('date'::text, search_value) &> '["2013-04-01 23:59:59+05:30","2013-04-01 23:59:59+05:30"]'::tstzrange))
13. 0.000 0.000 ↓ 0.0 0

Index Scan using observation_index_materialized_path_type_logical_id_key on observation_index sv_1 (cost=0.15..14.74 rows=1 width=8) (never executed)

  • Index Cond: (type = ANY ('{Observation}'::text[]))
  • Filter: (('org.1994969384149321699'::ltree @> materialized_path) AND (_search_date('date'::text, search_value) &< '["2013-04-06 00:00:00+05:30","2013-04-06 00:00:00+05:30"]'::tstzrange) AND (_search_date('date'::text, search_value) &> '["2013-04-01 23:59:59+05:30","2013-04-01 23:59:59+05:30"]'::tstzrange))