explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4gt

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 527.235 ↑ 1.0 1 1

Finalize Aggregate (cost=479,334.47..479,334.48 rows=1 width=8) (actual time=527.235..527.235 rows=1 loops=1)

2. 2.245 527.232 ↓ 1.5 3 1

Gather (cost=479,334.26..479,334.47 rows=2 width=8) (actual time=527.229..527.232 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.070 524.987 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=478,334.26..478,334.27 rows=1 width=8) (actual time=524.987..524.987 rows=1 loops=3)

4. 0.869 524.917 ↑ 2.7 308 3 / 3

Nested Loop (cost=0.43..478,332.21 rows=821 width=0) (actual time=1.286..524.917 rows=308 loops=3)

5. 512.201 512.201 ↑ 1.1 3,949 3 / 3

Parallel Seq Scan on articleden (cost=0.00..449,653.47 rows=4,211 width=8) (actual time=0.398..512.201 rows=3,949 loops=3)

  • Filter: ((articleden_search ~~ '%red%'::text) AND (articleden_dossier_id = 189))
  • Rows Removed by Filter: 601,289
6. 11.847 11.847 ↓ 0.0 0 11,847 / 3

Index Scan using article_pk on article (cost=0.43..6.81 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=11,847)

  • Index Cond: (article_id = articleden.articleden_article_id)
  • Filter: ((article_dossier_id = 189) AND (article_etat = 0) AND (article_type = ANY ('{0,10,5,6}'::integer[])))
  • Rows Removed by Filter: 1
Planning time : 0.243 ms