explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2bdn : Optimization for: plan #ZJaI

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 111.508 4,956.117 ↓ 72.7 22,249 1

Gather (cost=8,301.15..62,836.18 rows=306 width=36) (actual time=1,068.966..4,956.117 rows=22,249 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 554.591 4,844.609 ↓ 57.9 7,416 3 / 3

Nested Loop (cost=7,301.15..61,805.58 rows=128 width=36) (actual time=957.859..4,844.609 rows=7,416 loops=3)

3. 596.858 4,000.781 ↓ 57.9 7,416 3 / 3

Nested Loop (cost=7,300.87..61,766.02 rows=128 width=45) (actual time=951.292..4,000.781 rows=7,416 loops=3)

4. 393.139 1,594.338 ↓ 6.3 7,416 3 / 3

Parallel Hash Join (cost=7,300.45..58,079.19 rows=1,172 width=49) (actual time=931.474..1,594.338 rows=7,416 loops=3)

  • Hash Cond: (pp.blog_id = pb.id)
5. 274.853 276.129 ↑ 1.3 7,416 3 / 3

Parallel Bitmap Heap Scan on post_post pp (cost=225.28..50,979.00 rows=9,531 width=44) (actual time=4.220..276.129 rows=7,416 loops=3)

  • Recheck Cond: (client_id = 36)
  • Heap Blocks: exact=1587
6. 1.276 1.276 ↑ 1.0 22,249 1 / 3

Bitmap Index Scan on post_post_client__11a3d3_gin (cost=0.00..219.56 rows=22,875 width=0) (actual time=3.819..3.828 rows=22,249 loops=1)

  • Index Cond: (client_id = 36)
7. 398.995 925.070 ↑ 1.2 14,850 3 / 3

Parallel Hash (cost=6,843.59..6,843.59 rows=18,526 width=13) (actual time=925.024..925.070 rows=14,850 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 2688kB
8. 521.094 526.075 ↑ 1.2 14,850 3 / 3

Parallel Bitmap Heap Scan on post_blog pb (cost=837.01..6,843.59 rows=18,526 width=13) (actual time=8.238..526.075 rows=14,850 loops=3)

  • Recheck Cond: (client_id = 36)
  • Heap Blocks: exact=1468
9. 4.981 4.981 ↓ 1.0 44,551 1 / 3

Bitmap Index Scan on post_blog_client_id_c2a326b0_idx (cost=0.00..825.89 rows=44,463 width=0) (actual time=14.933..14.942 rows=44,551 loops=1)

  • Index Cond: (client_id = 36)
10. 1,809.585 1,809.585 ↑ 1.0 1 22,249 / 3

Index Scan using post_author_pkey on post_author pa (cost=0.42..3.15 rows=1 width=4) (actual time=0.244..0.244 rows=1 loops=22,249)

  • Index Cond: (id = pp.author_id)
  • Filter: (client_id = 36)
11. 289.237 289.237 ↑ 1.0 1 22,249 / 3

Index Only Scan using reference_host_url_4f98804f_like on reference_host rh (cost=0.28..0.31 rows=1 width=22) (actual time=0.039..0.039 rows=1 loops=22,249)

  • Index Cond: (url = (pb.host_id)::text)
  • Heap Fetches: 22249
Planning time : 127.570 ms
Execution time : 5,628.417 ms