explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gypx

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=1,737.53..1,737.56 rows=11 width=831) (actual rows= loops=)

  • Sort Key: (ts_rank(((((((((to_tsvector('simple'::regconfig, COALESCE((pipelines_1.uid)::text, ''::text)) || to_tsvector('simple'::regconfig, COALESCE((pipelines_1.metadata)::text, ''::text))) || to_tsvector('simple'::regconfig, COALESCE((pipelines_1.status)::text, ''::text))) || to_tsvector('simple'::regconfig, COALESCE((pipelines_1.type)::text, ''::text))) || to_tsvector('simple'::regconfig, COALESCE((pipelines_1.target_type)::text, ''::text))) || to_tsvector('simple'::regconfig, COALESCE((pipelines_1.target_id)::text, ''::text))) || to_tsvector('simple'::regconfig, COALESCE((pipelines_1.user_type)::text, ''::text))) || to_tsvector('simple'::regconfig, COALESCE((pipelines_1.user_id)::text, ''::text))) || to_tsvector('simple'::regconfig, COALESCE((pipelines_1.performed_by)::text, ''::text))), '''matt'':*'::tsquery, 0)) DESC, pipelines.id
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..1,737.34 rows=11 width=831) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on pipelines pipelines_1 (cost=0.00..1,628.79 rows=11 width=455) (actual rows= loops=)

  • Filter: (((((((((to_tsvector('simple'::regconfig, COALESCE((uid)::text, ''::text)) || to_tsvector('simple'::regconfig, COALESCE((metadata)::text, ''::text))) || to_tsvector('simple'::regconfig, COALESCE((status)::text, ''::text))) || to_tsvector('simple'::regconfig, COALESCE((type)::text, ''::text))) || to_tsvector('simple'::regconfig, COALESCE((target_type)::text, ''::text))) || to_tsvector('simple'::regconfig, COALESCE((target_id)::text, ''::text))) || to_tsvector('simple'::regconfig, COALESCE((user_type)::text, ''::text))) || to_tsvector('simple'::regconfig, COALESCE((user_id)::text, ''::text))) || to_tsvector('simple'::regconfig, COALESCE((performed_by)::text, ''::text))) @@ '''matt'':*'::tsquery)
4. 0.000 0.000 ↓ 0.0

Index Scan using pipelines_pkey on pipelines (cost=0.28..7.57 rows=1 width=827) (actual rows= loops=)

  • Index Cond: (id = pipelines_1.id)