explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5Lo

Settings
# exclusive inclusive rows x rows loops node
1. 1.355 4,777.520 ↑ 1.0 10 1

Limit (cost=364,988.73..365,078.34 rows=10 width=989) (actual time=4,776.104..4,777.520 rows=10 loops=1)

2. 0.043 4,776.165 ↑ 34,819.9 10 1

Result (cost=364,988.73..3,485,148.51 rows=348,199 width=989) (actual time=4,776.103..4,776.165 rows=10 loops=1)

3. 412.984 4,776.042 ↑ 34,819.9 10 1

Sort (cost=364,988.73..365,859.23 rows=348,199 width=961) (actual time=4,776.041..4,776.042 rows=10 loops=1)

  • Sort Key: v.date_publication DESC, c.created_at DESC
  • Sort Method: top-N heapsort Memory: 36kB
4. 372.752 4,363.058 ↓ 1.0 348,203 1

Gather (cost=98,684.68..357,464.27 rows=348,199 width=961) (actual time=738.662..4,363.058 rows=348,203 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 72.976 3,990.306 ↑ 1.2 116,068 3 / 3

Hash Join (cost=97,684.68..321,136.58 rows=145,083 width=961) (actual time=705.212..3,990.306 rows=116,068 loops=3)

  • Hash Cond: (c.contenu_type_id = t.id)
6. 66.149 3,917.317 ↑ 1.2 116,068 3 / 3

Hash Join (cost=97,683.57..320,069.11 rows=145,083 width=946) (actual time=705.106..3,917.317 rows=116,068 loops=3)

  • Hash Cond: (v.etat_courant_id = e.id)
7. 2,876.753 3,851.160 ↑ 1.2 116,068 3 / 3

Hash Join (cost=97,682.48..319,283.66 rows=145,083 width=923) (actual time=705.090..3,851.160 rows=116,068 loops=3)

  • Hash Cond: (v.id = c.current_version_id)
8. 269.848 269.848 ↑ 1.2 281,367 3 / 3

Parallel Seq Scan on contenu_version v (cost=0.00..145,575.39 rows=351,539 width=750) (actual time=0.004..269.848 rows=281,367 loops=3)

9. 325.442 704.559 ↓ 1.0 348,203 3 / 3

Hash (cost=84,828.99..84,828.99 rows=348,199 width=173) (actual time=704.559..704.559 rows=348,203 loops=3)

  • Buckets: 32,768 Batches: 32 Memory Usage: 2,443kB
10. 379.117 379.117 ↓ 1.0 348,203 3 / 3

Seq Scan on contenu c (cost=0.00..84,828.99 rows=348,199 width=173) (actual time=0.008..379.117 rows=348,203 loops=3)

  • Filter: (deleted_at IS NULL)
11. 0.003 0.008 ↑ 1.0 4 3 / 3

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

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

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

13. 0.005 0.013 ↑ 1.0 5 3 / 3

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
14. 0.008 0.008 ↑ 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.008 rows=5 loops=3)

15.          

SubPlan (for Result)

16. 0.080 0.080 ↑ 2.0 1 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.008..0.008 rows=1 loops=10)

  • Index Cond: (contenu_version_id = v.id)
Planning time : 0.743 ms
Execution time : 4,777.872 ms