explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Cuxe

Settings
# exclusive inclusive rows x rows loops node
1. 0.484 686.880 ↑ 5.9 29 1

Sort (cost=45,015.44..45,015.86 rows=170 width=43) (actual time=686.668..686.880 rows=29 loops=1)

  • Sort Key: btxcity0_.city_order
  • Sort Method: quicksort Memory: 27kB
2. 8.963 686.396 ↑ 5.9 29 1

HashAggregate (cost=45,008.29..45,009.14 rows=170 width=43) (actual time=686.188..686.396 rows=29 loops=1)

3. 16.921 677.433 ↑ 96.8 1,009 1

Hash Join (cost=309.32..43,298.75 rows=97,688 width=43) (actual time=218.596..677.433 rows=1,009 loops=1)

  • Hash Cond: (wtsperform2_.venuecode = (btxvenue3_.id)::bpchar)
4. 448.842 448.842 ↑ 97.1 1,009 1

Seq Scan on wtsperfrec wtsperform2_ (cost=0.00..42,133.70 rows=97,944 width=3) (actual time=6.881..448.842 rows=1,009 loops=1)

  • Filter: ((wtsisactive > 0) AND (wtsissuspended = 0) AND ((wtspfdate)::timestamp with time zone > ('now'::cstring)::date))
  • Rows Removed by Filter: 399127
5. 10.026 211.670 ↓ 1.0 1,145 1

Hash (cost=300.75..300.75 rows=1,143 width=46) (actual time=211.670..211.670 rows=1,145 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 89kB
6. 20.811 201.644 ↓ 1.0 1,145 1

Hash Join (cost=145.87..300.75 rows=1,143 width=46) (actual time=129.598..201.644 rows=1,145 loops=1)

  • Hash Cond: (btxtown1_.btx_city_id = btxcity0_.id)
7. 18.303 179.498 ↓ 1.0 1,145 1

Hash Join (cost=143.80..288.68 rows=1,143 width=11) (actual time=128.224..179.498 rows=1,145 loops=1)

  • Hash Cond: (btxvenue3_.btx_town_id = btxtown1_.id)
8. 21.833 55.695 ↓ 1.0 1,145 1

Hash Join (cost=35.15..164.32 rows=1,143 width=11) (actual time=22.670..55.695 rows=1,145 loops=1)

  • Hash Cond: ((btxvenuete4_.btx_venue_id)::text = (btxvenue3_.id)::text)
9. 11.263 11.263 ↓ 1.0 1,146 1

Seq Scan on venue_text btxvenuete4_ (cost=0.00..119.16 rows=1,144 width=3) (actual time=0.013..11.263 rows=1,146 loops=1)

  • Filter: (lang = 'tr'::text)
  • Rows Removed by Filter: 1146
10. 10.078 22.599 ↓ 1.0 1,145 1

Hash (cost=26.58..26.58 rows=1,143 width=11) (actual time=22.599..22.599 rows=1,145 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 49kB
11. 12.521 12.521 ↓ 1.0 1,145 1

Seq Scan on venue btxvenue3_ (cost=0.00..26.58 rows=1,143 width=11) (actual time=0.011..12.521 rows=1,145 loops=1)

  • Filter: ((id)::text <> 'ZY'::text)
  • Rows Removed by Filter: 1
12. 51.545 105.500 ↑ 1.0 5,492 1

Hash (cost=67.46..67.46 rows=5,492 width=16) (actual time=105.500..105.500 rows=5,492 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 258kB
13. 53.955 53.955 ↑ 1.0 5,492 1

Seq Scan on town btxtown1_ (cost=0.00..67.46 rows=5,492 width=16) (actual time=0.011..53.955 rows=5,492 loops=1)

14. 1.335 1.335 ↑ 1.0 85 1

Hash (cost=1.43..1.43 rows=85 width=43) (actual time=1.335..1.335 rows=85 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 7kB
  • -> Seq Scan on city btxcity0_ (cost=0.00..1.43 rows=85 width=43) (actual time=0.010..0.650 rows=85 loops=1)"Total runtime: 687.284 ms