explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ry3d

Settings
# exclusive inclusive rows x rows loops node
1. 0.030 4,590.024 ↑ 1.0 10 1

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

2. 102.576 4,589.994 ↑ 4,814.9 10 1

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

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

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

  • Group Key: mainarticl0_.id, mainarticl0_2_.display_name
4. 474.146 4,135.672 ↓ 2.9 137,501 1

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

  • Hash Cond: (mainarticl0_2_.id = mainarticl0_.id)
5. 310.089 310.089 ↑ 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.010..310.089 rows=442,102 loops=1)

6. 129.008 3,351.437 ↓ 2.9 137,501 1

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

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

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

  • Hash Cond: (mainarticl0_1_.id = mainarticl0_.id)
8. 238.247 238.247 ↑ 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.011..238.247 rows=438,411 loops=1)

9. 127.473 2,540.388 ↓ 2.9 137,501 1

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

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

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

  • Hash Cond: (mainarticl0_.id = atn.parent_id)
11. 97.739 97.739 ↑ 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.020..97.739 rows=150,238 loops=1)

12. 92.235 2,085.402 ↓ 2.9 137,501 1

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

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

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

  • Group Key: atn.parent_id
14. 545.946 1,689.746 ↑ 1.2 194,287 1

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

  • Hash Cond: (atn.id = va.id)
15. 265.530 265.530 ↑ 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.016..265.530 rows=442,102 loops=1)

  • Heap Fetches: 0
16. 196.328 878.270 ↑ 1.2 194,287 1

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

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

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

  • Hash Cond: (va.vendor_id = vendorcomp3_.id)
18. 278.998 278.998 ↑ 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.020..278.998 rows=288,173 loops=1)

19. 0.052 0.113 ↑ 1.0 63 1

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

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

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

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