explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EtKM

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 74.643 ↑ 71.3 74 1

Unique (cost=4,116.01..4,155.57 rows=5,275 width=12) (actual time=74.622..74.643 rows=74 loops=1)

2. 0.051 74.629 ↑ 71.3 74 1

Sort (cost=4,116.01..4,129.20 rows=5,275 width=12) (actual time=74.621..74.629 rows=74 loops=1)

  • Sort Key: (min((row_number() OVER (?)))), m0_.id
  • Sort Method: quicksort Memory: 28kB
3. 0.156 74.578 ↑ 71.3 74 1

HashAggregate (cost=3,737.13..3,789.88 rows=5,275 width=12) (actual time=74.564..74.578 rows=74 loops=1)

  • Group Key: m0_.id
4. 0.208 74.422 ↑ 8.9 592 1

WindowAgg (cost=3,565.69..3,658.01 rows=5,275 width=1,096) (actual time=74.161..74.422 rows=592 loops=1)

5. 0.185 74.214 ↑ 8.9 592 1

Sort (cost=3,565.69..3,578.88 rows=5,275 width=8) (actual time=74.151..74.214 rows=592 loops=1)

  • Sort Key: m0_.popularity DESC
  • Sort Method: quicksort Memory: 52kB
6. 65.654 74.029 ↑ 8.9 592 1

Hash Right Join (cost=629.76..3,239.57 rows=5,275 width=8) (actual time=2.801..74.029 rows=592 loops=1)

  • Hash Cond: (m1_.translatable_id = m0_.id)
  • Filter: ((lower((m1_.label)::text) ~~ '%ber%'::text) OR (lower((m1_.terms)::text) ~~ '%ber%'::text) OR ((m0_.id)::text ~~ '%ber%'::text))
  • Rows Removed by Filter: 40016
7. 5.843 5.843 ↑ 1.0 45,742 1

Seq Scan on md_point_of_interest_translation m1_ (cost=0.00..1,179.65 rows=45,765 width=49) (actual time=0.004..5.843 rows=45,742 loops=1)

8. 0.956 2.532 ↑ 2.5 5,076 1

Hash (cost=470.45..470.45 rows=12,745 width=8) (actual time=2.532..2.532 rows=5,076 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 327kB
9. 1.576 1.576 ↑ 2.5 5,076 1

Seq Scan on md_point_of_interest m0_ (cost=0.00..470.45 rows=12,745 width=8) (actual time=0.006..1.576 rows=5,076 loops=1)