explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xaej

Settings
# exclusive inclusive rows x rows loops node
1. 0.460 816.908 ↑ 5.9 29 1

Sort (cost=47,273.39..47,273.82 rows=170 width=43) (actual time=816.744..816.908 rows=29 loops=1)

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

HashAggregate (cost=47,266.24..47,267.09 rows=170 width=43) (actual time=816.263..816.448 rows=29 loops=1)

3. 24.814 799.242 ↑ 96.8 2,018 1

Hash Join (cost=246.87..43,847.16 rows=195,376 width=43) (actual time=209.537..799.242 rows=2,018 loops=1)

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

Seq Scan on wtsperfrec wtsperform2_ (cost=0.00..42,133.70 rows=97,944 width=3) (actual time=8.456..573.409 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. 16.758 201.019 ↓ 1.0 2,290 1

Hash (cost=229.72..229.72 rows=2,286 width=46) (actual time=201.019..201.019 rows=2,290 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 178kB
6. 32.944 184.261 ↓ 1.0 2,290 1

Hash Join (cost=171.58..229.72 rows=2,286 width=46) (actual time=134.955..184.261 rows=2,290 loops=1)

  • Hash Cond: ((btxvenuete4_.btx_venue_id)::text = (btxvenue3_.id)::text)
7. 16.476 16.476 ↓ 1.0 2,292 1

Index Only Scan using venue_text_btx_venue_id_idx on venue_text btxvenuete4_ (cost=0.00..38.13 rows=2,288 width=3) (actual time=0.074..16.476 rows=2,292 loops=1)

  • Heap Fetches: 373
8. 8.511 134.841 ↓ 1.0 1,145 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 89kB
9. 16.112 126.330 ↓ 1.0 1,145 1

Hash Join (cost=110.71..163.01 rows=1,143 width=46) (actual time=85.551..126.330 rows=1,145 loops=1)

  • Hash Cond: (btxtown1_.btx_city_id = btxcity0_.id)
10. 16.637 108.938 ↓ 1.0 1,145 1

Hash Join (cost=108.65..150.95 rows=1,143 width=11) (actual time=84.224..108.938 rows=1,145 loops=1)

  • Hash Cond: (btxvenue3_.btx_town_id = btxtown1_.id)
11. 8.137 8.137 ↓ 1.0 1,145 1

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 258kB
13. 41.732 41.732 ↑ 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.732 rows=5,492 loops=1)

14. 1.280 1.280 ↑ 1.0 85 1

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