explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FnA3

Settings
# exclusive inclusive rows x rows loops node
1. 1.064 2,965.297 ↑ 1.0 10 1

Limit (cost=399,373.08..399,590.09 rows=10 width=1,053) (actual time=2,964.117..2,965.297 rows=10 loops=1)

2. 0.069 2,964.233 ↑ 34,608.8 10 1

Result (cost=399,373.08..7,909,777.62 rows=346,088 width=1,053) (actual time=2,964.116..2,964.233 rows=10 loops=1)

3. 345.126 2,964.054 ↑ 34,608.8 10 1

Sort (cost=399,373.08..400,238.30 rows=346,088 width=961) (actual time=2,964.053..2,964.054 rows=10 loops=1)

  • Sort Key: v.date_publication DESC
  • Sort Method: top-N heapsort Memory: 45kB
4. 478.291 2,618.928 ↑ 1.0 345,967 1

Gather (cost=42,244.08..391,894.24 rows=346,088 width=961) (actual time=1,054.736..2,618.928 rows=345,967 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 59.178 2,140.637 ↑ 1.3 115,322 3 / 3

Hash Join (cost=41,244.08..355,780.73 rows=144,203 width=961) (actual time=962.422..2,140.637 rows=115,322 loops=3)

  • Hash Cond: (c.contenu_type_id = t.id)
6. 69.028 2,081.449 ↑ 1.3 115,322 3 / 3

Hash Join (cost=41,242.97..354,719.72 rows=144,203 width=946) (actual time=962.356..2,081.449 rows=115,322 loops=3)

  • Hash Cond: (v.etat_courant_id = e.id)
7. 70.958 2,012.414 ↑ 1.3 115,322 3 / 3

Nested Loop (cost=41,241.88..353,939.03 rows=144,203 width=923) (actual time=962.340..2,012.414 rows=115,322 loops=3)

  • Join Filter: (c.current_version_id = v.id)
8. 297.679 1,364.844 ↑ 1.3 115,322 3 / 3

Hash Semi Join (cost=41,241.45..151,425.14 rows=144,203 width=177) (actual time=962.319..1,364.844 rows=115,322 loops=3)

  • Hash Cond: (c.current_version_id = vr.contenu_version_id)
9. 105.407 105.407 ↑ 1.3 115,326 3 / 3

Parallel Seq Scan on contenu c (cost=0.00..83,160.36 rows=144,203 width=173) (actual time=0.004..105.407 rows=115,326 loops=3)

  • Filter: ((deleted_at IS NULL) AND (statut_publication = 'publie'::contenu_statut_publication))
  • Rows Removed by Filter: 740
10. 326.392 961.758 ↓ 1.0 1,061,824 3 / 3

Hash (cost=23,943.40..23,943.40 rows=1,054,324 width=4) (actual time=961.758..961.758 rows=1,061,824 loops=3)

  • Buckets: 131,072 Batches: 16 Memory Usage: 3,358kB
11. 495.822 635.366 ↓ 1.0 1,061,824 3 / 3

Hash Join (cost=16.58..23,943.40 rows=1,054,324 width=4) (actual time=0.168..635.366 rows=1,061,824 loops=3)

  • Hash Cond: (vr.rubrique_id = r.id)
12. 139.389 139.389 ↓ 1.0 1,061,845 3 / 3

Seq Scan on contenu_version_rubrique vr (cost=0.00..21,102.06 rows=1,061,306 width=8) (actual time=0.005..139.389 rows=1,061,845 loops=3)

13. 0.058 0.155 ↑ 1.0 302 3 / 3

Hash (cost=12.80..12.80 rows=302 width=4) (actual time=0.154..0.155 rows=302 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 19kB
14. 0.097 0.097 ↑ 1.0 302 3 / 3

Seq Scan on rubrique r (cost=0.00..12.80 rows=302 width=4) (actual time=0.005..0.097 rows=302 loops=3)

  • Filter: (marque_id = 1)
  • Rows Removed by Filter: 2
15. 576.612 576.612 ↑ 1.0 1 345,967 / 3

Index Scan using contenu_version_pkey on contenu_version v (cost=0.42..1.39 rows=1 width=750) (actual time=0.005..0.005 rows=1 loops=345,967)

  • Index Cond: (id = vr.contenu_version_id)
16. 0.003 0.007 ↑ 1.0 4 3 / 3

Hash (cost=1.04..1.04 rows=4 width=27) (actual time=0.007..0.007 rows=4 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
17. 0.004 0.004 ↑ 1.0 4 3 / 3

Seq Scan on contenu_etat e (cost=0.00..1.04 rows=4 width=27) (actual time=0.003..0.004 rows=4 loops=3)

18. 0.003 0.010 ↑ 1.0 5 3 / 3

Hash (cost=1.05..1.05 rows=5 width=18) (actual time=0.010..0.010 rows=5 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
19. 0.007 0.007 ↑ 1.0 5 3 / 3

Seq Scan on contenu_type t (cost=0.00..1.05 rows=5 width=18) (actual time=0.006..0.007 rows=5 loops=3)

20.          

SubPlan (for Result)

21. 0.020 0.020 ↓ 0.0 0 10

Index Scan using auteur_contenu_version_contenu_version_id_idx on auteur_contenu_version (cost=0.29..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=10)

  • Index Cond: (contenu_version_id = v.id)
22. 0.070 0.070 ↑ 1.0 2 10

Index Scan using contenu_version_rubrique_contenu_version_id_idx on contenu_version_rubrique cvr (cost=0.43..8.95 rows=2 width=32) (actual time=0.005..0.007 rows=2 loops=10)

  • Index Cond: (contenu_version_id = v.id)
23. 0.020 0.020 ↓ 0.0 0 10

Index Only Scan using contenu_version_flag_edito_contenu_version_id_flag_edito_id_uni on contenu_version_flag_edito cvf (cost=0.42..4.44 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=10)

  • Index Cond: (contenu_version_id = v.id)
  • Heap Fetches: 0
Planning time : 1.472 ms
Execution time : 2,965.650 ms