explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WX3s

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,091.858 ↑ 1.0 1 1

Finalize Aggregate (cost=184,698.80..184,698.81 rows=1 width=8) (actual time=2,091.858..2,091.858 rows=1 loops=1)

2. 110.697 2,093.133 ↓ 1.5 3 1

Gather (cost=184,698.58..184,698.79 rows=2 width=8) (actual time=1,926.106..2,093.133 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 7.391 1,982.436 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=183,698.58..183,698.59 rows=1 width=8) (actual time=1,982.436..1,982.436 rows=1 loops=3)

4. 192.974 1,975.045 ↑ 1.2 117,659 3 / 3

Hash Semi Join (cost=132,035.73..183,331.03 rows=147,022 width=0) (actual time=1,516.458..1,975.045 rows=117,659 loops=3)

  • Hash Cond: (c.current_version_id = vr.contenu_version_id)
5. 196.286 724.461 ↑ 1.2 117,662 3 / 3

Hash Join (cost=90,665.62..119,950.16 rows=147,022 width=8) (actual time=458.344..724.461 rows=117,662 loops=3)

  • Hash Cond: (v.id = c.current_version_id)
6. 70.515 70.515 ↑ 1.2 285,849 3 / 3

Parallel Index Only Scan using contenu_version_idx_id on contenu_version v (cost=0.42..24,176.03 rows=357,310 width=4) (actual time=0.055..70.515 rows=285,849 loops=3)

  • Heap Fetches: 0
7. 121.364 457.660 ↓ 1.0 352,987 3 / 3

Hash (cost=84,875.53..84,875.53 rows=352,853 width=4) (actual time=457.660..457.660 rows=352,987 loops=3)

  • Buckets: 131,072 Batches: 8 Memory Usage: 2,577kB
8. 336.296 336.296 ↓ 1.0 352,987 3 / 3

Seq Scan on contenu c (cost=0.00..84,875.53 rows=352,853 width=4) (actual time=0.008..336.296 rows=352,987 loops=3)

  • Filter: (deleted_at IS NULL)
9. 342.293 1,057.610 ↓ 1.0 1,086,799 3 / 3

Hash (cost=23,997.19..23,997.19 rows=1,058,874 width=4) (actual time=1,057.610..1,057.610 rows=1,086,799 loops=3)

  • Buckets: 131,072 Batches: 16 Memory Usage: 3,414kB
10. 551.628 715.317 ↓ 1.0 1,086,799 3 / 3

Hash Join (cost=16.85..23,997.19 rows=1,058,874 width=4) (actual time=0.173..715.317 rows=1,086,799 loops=3)

  • Hash Cond: (vr.rubrique_id = r.id)
11. 163.528 163.528 ↓ 1.0 1,086,820 3 / 3

Seq Scan on contenu_version_rubrique vr (cost=0.00..21,145.40 rows=1,065,640 width=8) (actual time=0.005..163.528 rows=1,086,820 loops=3)

12. 0.061 0.161 ↑ 1.0 313 3 / 3

Hash (cost=12.94..12.94 rows=313 width=4) (actual time=0.161..0.161 rows=313 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 20kB
13. 0.100 0.100 ↑ 1.0 313 3 / 3

Seq Scan on rubrique r (cost=0.00..12.94 rows=313 width=4) (actual time=0.005..0.100 rows=313 loops=3)

  • Filter: (marque_id = 1)
  • Rows Removed by Filter: 2
Planning time : 0.711 ms
Execution time : 2,093.699 ms