explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DBbG

Settings
# exclusive inclusive rows x rows loops node
1. 0.445 604.363 ↑ 5.9 29 1

Sort (cost=45,011.84..45,012.26 rows=170 width=43) (actual time=604.164..604.363 rows=29 loops=1)

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

HashAggregate (cost=45,004.69..45,005.54 rows=170 width=43) (actual time=603.709..603.918 rows=29 loops=1)

3. 15.112 595.852 ↑ 96.7 1,009 1

Hash Join (cost=309.32..43,297.56 rows=97,550 width=43) (actual time=176.833..595.852 rows=1,009 loops=1)

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

Seq Scan on wtsperfrec wtsperform2_ (cost=0.00..42,133.72 rows=97,806 width=3) (actual time=5.978..409.952 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.884 170.788 ↓ 1.0 1,145 1

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

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

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

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

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

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

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

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

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 49kB
11. 8.902 8.902 ↓ 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.902 rows=1,145 loops=1)

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

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

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

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

14. 1.329 1.329 ↑ 1.0 85 1

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