explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LfuP

Settings
# exclusive inclusive rows x rows loops node
1. 0.551 644.856 ↑ 5.9 29 1

Sort (cost=45,015.48..45,015.91 rows=170 width=43) (actual time=644.610..644.856 rows=29 loops=1)

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

HashAggregate (cost=45,008.34..45,009.19 rows=170 width=43) (actual time=644.024..644.305 rows=29 loops=1)

3. 16.734 635.175 ↑ 96.8 1,009 1

Hash Join (cost=309.32..43,298.78 rows=97,689 width=43) (actual time=180.511..635.175 rows=1,009 loops=1)

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

Seq Scan on wtsperfrec wtsperform2_ (cost=0.00..42,133.72 rows=97,945 width=3) (actual time=5.742..443.732 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. 9.017 174.709 ↓ 1.0 1,145 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

14. 1.385 1.385 ↑ 1.0 85 1

Hash (cost=1.43..1.43 rows=85 width=43) (actual time=1.385..1.385 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.012..0.656 rows=85 loops=1)"Total runtime: 645.275 ms