explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KPhu

Settings
# exclusive inclusive rows x rows loops node
1. 0.495 624.413 ↑ 5.9 29 1

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

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

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

3. 16.362 615.475 ↑ 96.8 1,009 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

14. 1.313 1.313 ↑ 1.0 85 1

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