explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oDF3

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 25.829 ↑ 1.0 3,049 1

Nested Loop (cost=1,089.22..14,292.48 rows=3,146 width=4,380) (actual time=4.264..25.829 rows=3,049 loops=1)

2. 0.013 0.013 ↑ 1.0 1 1

Index Scan using tag_pkey on tag tag2_ (cost=0.42..8.44 rows=1 width=203) (actual time=0.011..0.013 rows=1 loops=1)

  • Index Cond: (id = 'f0f65abc-0d7d-4f3c-a646-cf157a4d0387'::uuid)
3. 8.822 25.813 ↑ 1.0 3,049 1

Gather (cost=1,088.80..14,252.58 rows=3,146 width=4,177) (actual time=4.244..25.813 rows=3,049 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 13.139 16.991 ↑ 1.2 1,524 2

Nested Loop (cost=88.80..12,937.98 rows=1,851 width=4,177) (actual time=1.055..16.991 rows=1,524 loops=2)

5. 2.511 3.846 ↑ 1.2 1,525 2

Parallel Bitmap Heap Scan on news_tag tags1_ (cost=88.38..3,556.85 rows=1,851 width=32) (actual time=0.998..3.846 rows=1,525 loops=2)

  • Recheck Cond: (tags_id = 'f0f65abc-0d7d-4f3c-a646-cf157a4d0387'::uuid)
  • Heap Blocks: exact=954
6. 1.335 1.335 ↑ 1.0 3,050 1

Bitmap Index Scan on news_tag_tags_id_index (cost=0.00..87.59 rows=3,146 width=0) (actual time=1.335..1.335 rows=3,050 loops=1)

  • Index Cond: (tags_id = 'f0f65abc-0d7d-4f3c-a646-cf157a4d0387'::uuid)
7. 0.006 0.006 ↑ 1.0 1 3,050

Index Scan using news_pkey on news news0_ (cost=0.42..5.07 rows=1 width=4,145) (actual time=0.006..0.006 rows=1 loops=3,050)

  • Index Cond: (id = tags1_.news_id)
Planning time : 0.891 ms
Execution time : 30.290 ms