explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yeQ1

Settings
# exclusive inclusive rows x rows loops node
1. 0.032 4,456.218 ↑ 1.0 10 1

Limit (cost=80,288.86..80,288.88 rows=10 width=106) (actual time=4,456.181..4,456.218 rows=10 loops=1)

2. 122.020 4,456.186 ↑ 4,814.9 10 1

Sort (cost=80,288.86..80,409.23 rows=48,149 width=106) (actual time=4,456.179..4,456.186 rows=10 loops=1)

  • Sort Key: ((mainarticl0_2_.display_name ->> 'DE'::text)), mainarticl0_.id
  • Sort Method: top-N heapsort Memory: 26kB
3. 404.853 4,334.166 ↓ 2.9 137,501 1

HashAggregate (cost=78,646.51..79,248.38 rows=48,149 width=106) (actual time=4,132.723..4,334.166 rows=137,501 loops=1)

  • Group Key: mainarticl0_.id, mainarticl0_2_.display_name
4. 457.274 3,929.313 ↓ 2.9 137,501 1

Hash Join (cost=55,378.38..78,405.77 rows=48,149 width=74) (actual time=3,179.979..3,929.313 rows=137,501 loops=1)

  • Hash Cond: (mainarticl0_2_.id = mainarticl0_.id)
5. 292.409 292.409 ↑ 1.0 442,102 1

Seq Scan on article_tree_node mainarticl0_2_ (cost=0.00..20,888.02 rows=442,102 width=74) (actual time=0.023..292.409 rows=442,102 loops=1)

6. 120.415 3,179.630 ↓ 2.9 137,501 1

Hash (cost=54,776.51..54,776.51 rows=48,149 width=48) (actual time=3,179.629..3,179.630 rows=137,501 loops=1)

  • Buckets: 262144 (originally 65536) Batches: 1 (originally 1) Memory Usage: 12791kB
7. 438.866 3,059.215 ↓ 2.9 137,501 1

Hash Join (cost=45,473.87..54,776.51 rows=48,149 width=48) (actual time=2,380.467..3,059.215 rows=137,501 loops=1)

  • Hash Cond: (mainarticl0_1_.id = mainarticl0_.id)
8. 240.165 240.165 ↑ 1.0 438,411 1

Seq Scan on selectable_article mainarticl0_1_ (cost=0.00..7,177.11 rows=438,411 width=16) (actual time=0.016..240.165 rows=438,411 loops=1)

9. 119.175 2,380.184 ↓ 2.9 137,501 1

Hash (cost=44,872.01..44,872.01 rows=48,149 width=32) (actual time=2,380.183..2,380.184 rows=137,501 loops=1)

  • Buckets: 262144 (originally 65536) Batches: 1 (originally 1) Memory Usage: 10642kB
10. 221.246 2,261.009 ↓ 2.9 137,501 1

Hash Join (cost=41,064.66..44,872.01 rows=48,149 width=32) (actual time=1,952.976..2,261.009 rows=137,501 loops=1)

  • Hash Cond: (mainarticl0_.id = atn.parent_id)
11. 87.066 87.066 ↑ 1.0 150,238 1

Seq Scan on main_article mainarticl0_ (cost=0.00..2,799.38 rows=150,238 width=16) (actual time=0.008..87.066 rows=150,238 loops=1)

12. 94.835 1,952.697 ↓ 2.9 137,501 1

Hash (cost=40,462.79..40,462.79 rows=48,149 width=16) (actual time=1,952.697..1,952.697 rows=137,501 loops=1)

  • Buckets: 262144 (originally 65536) Batches: 1 (originally 1) Memory Usage: 8494kB
13. 301.531 1,857.862 ↓ 2.9 137,502 1

HashAggregate (cost=39,981.30..40,462.79 rows=48,149 width=16) (actual time=1,744.037..1,857.862 rows=137,502 loops=1)

  • Group Key: atn.parent_id
14. 526.637 1,556.331 ↑ 1.2 194,287 1

Hash Join (cost=18,223.28..39,406.78 rows=229,809 width=16) (actual time=764.727..1,556.331 rows=194,287 loops=1)

  • Hash Cond: (atn.id = va.id)
15. 272.258 272.258 ↑ 1.0 442,102 1

Index Only Scan using ix_article_tree_node_parent_id2 on article_tree_node atn (cost=0.42..17,227.95 rows=442,102 width=32) (actual time=0.040..272.258 rows=442,102 loops=1)

  • Heap Fetches: 0
16. 198.436 757.436 ↑ 1.2 194,287 1

Hash (cost=15,350.24..15,350.24 rows=229,809 width=16) (actual time=757.435..757.436 rows=194,287 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 11156kB
17. 335.682 559.000 ↑ 1.2 194,287 1

Hash Join (cost=4.78..15,350.24 rows=229,809 width=16) (actual time=0.238..559.000 rows=194,287 loops=1)

  • Hash Cond: (va.vendor_id = vendorcomp3_.id)
18. 223.168 223.168 ↑ 1.0 288,173 1

Seq Scan on vendor_article va (cost=0.00..11,966.73 rows=288,173 width=32) (actual time=0.030..223.168 rows=288,173 loops=1)

19. 0.050 0.150 ↑ 1.0 63 1

Hash (cost=3.99..3.99 rows=63 width=16) (actual time=0.150..0.150 rows=63 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
20. 0.100 0.100 ↑ 1.0 63 1

Seq Scan on vendor_company vendorcomp3_ (cost=0.00..3.99 rows=63 width=16) (actual time=0.013..0.100 rows=63 loops=1)

  • Filter: (status = 0)
  • Rows Removed by Filter: 16