explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 612b

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 38,953.471 ↓ 1,082.0 1,082 1

Sort (cost=11,211.81..11,211.81 rows=1 width=202) (actual time=38,953.218..38,953.471 rows=1,082 loops=1)

  • Sort Key: (ts_rank_cd((title_text.title_text || fulltext_text.fulltext_text), query.query)) DESC
  • Sort Method: quicksort Memory: 762kB
2. 101.224 39,045.435 ↓ 1,082.0 1,082 1

Gather (cost=1,000.50..11,211.80 rows=1 width=202) (actual time=16.731..39,045.435 rows=1,082 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 134.321 38,944.211 ↓ 361.0 361 3

Nested Loop (cost=0.51..10,211.70 rows=1 width=202) (actual time=248.879..38,944.211 rows=361 loops=3)

  • Join Filter: ((title_text.title_text || fulltext_text.fulltext_text) @@ query.query)
  • Rows Removed by Join Filter: 124
4. 4,594.317 38,809.889 ↓ 40.4 485 3

Nested Loop (cost=0.51..10,211.39 rows=12 width=256) (actual time=31.128..38,809.889 rows=485 loops=3)

5. 28.653 34,206.076 ↓ 40.4 485 3

Nested Loop (cost=0.25..10,210.90 rows=12 width=224) (actual time=20.250..34,206.076 rows=485 loops=3)

6. 34,177.368 34,177.368 ↓ 40.4 485 3

Parallel Seq Scan on _bmc_fulltext (cost=0.00..10,210.41 rows=12 width=192) (actual time=19.752..34,177.368 rows=485 loops=3)

  • Filter: (((pm_id)::text <> ALL ('{26487087,29592810}'::text[])) AND ((doi)::text <> '10.1186/s12929-018-0413-9'::text) AND ((fulltext)::text ~* 'pd-1'::text))
  • Rows Removed by Filter: 95351
7. 0.055 0.055 ↑ 1.0 1 1,454

Function Scan on setweight title_text (cost=0.25..0.26 rows=1 width=32) (actual time=0.055..0.055 rows=1 loops=1,454)

8. 9.496 9.496 ↑ 1.0 1 1,454

Function Scan on setweight fulltext_text (cost=0.25..0.26 rows=1 width=32) (actual time=9.496..9.496 rows=1 loops=1,454)

9. 0.001 0.001 ↑ 1.0 1 1,454

Function Scan on query (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.001 rows=1 loops=1,454)