explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yGRr

Settings
# exclusive inclusive rows x rows loops node
1. 12.963 7,281.210 ↑ 13.2 1,435 1

GroupAggregate (cost=374,668.60..375,188.24 rows=18,896 width=57) (actual time=7,261.530..7,281.210 rows=1,435 loops=1)

  • Group Key: (date((parkbee_history_by_product.hourly_frame + '01:00:00'::interval))), tbl_garages.garagename
2.          

Initplan (for GroupAggregate)

3. 0.013 0.013 ↑ 1.0 1 1

Result (cost=0.00..0.03 rows=1 width=8) (actual time=0.013..0.013 rows=1 loops=1)

4. 0.012 0.012 ↑ 1.0 1 1

Result (cost=0.00..0.03 rows=1 width=8) (actual time=0.012..0.012 rows=1 loops=1)

5. 120.574 7,268.222 ↓ 1.8 34,440 1

Sort (cost=374,668.54..374,715.78 rows=18,896 width=28) (actual time=7,261.501..7,268.222 rows=34,440 loops=1)

  • Sort Key: (date((parkbee_history_by_product.hourly_frame + '01:00:00'::interval))) DESC, tbl_garages.garagename
  • Sort Method: quicksort Memory: 3,644kB
6. 50.786 7,147.648 ↓ 1.8 34,440 1

Hash Join (cost=15.85..373,326.38 rows=18,896 width=28) (actual time=17.822..7,147.648 rows=34,440 loops=1)

  • Hash Cond: (parkbee_history_by_product.garageid = tbl_garages.garageid)
7. 7,080.400 7,080.400 ↑ 1.1 51,240 1

Seq Scan on "lr$bbyxj0ofn4ucckthrubyg_parkbee_history_by_product" parkbee_history_by_product (cost=0.00..372,823.20 rows=54,370 width=19) (actual time=1.334..7,080.400 rows=51,240 loops=1)

  • Filter: (((hourly_frame + '01:00:00'::interval) >= $0) AND ((hourly_frame + '01:00:00'::interval) < $1))
  • Rows Removed by Filter: 10,822,704
8. 0.071 16.462 ↓ 1.9 205 1

Hash (cost=14.53..14.53 rows=106 width=21) (actual time=16.461..16.462 rows=205 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 19kB
9. 16.391 16.391 ↓ 1.9 205 1

Seq Scan on "lr$bbx2qhatwv5uin5blqibh_tbl_garages" tbl_garages (cost=0.00..14.53 rows=106 width=21) (actual time=0.017..16.391 rows=205 loops=1)

  • Filter: ((NOT COALESCE(issecretzone, false)) AND (NOT _fivetran_deleted) AND (country = 'Netherlands'::text))
  • Rows Removed by Filter: 77
Planning time : 0.896 ms
Execution time : 7,281.556 ms