explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 43Ek

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4,505.01..4,517.95 rows=162 width=192) (actual rows= loops=)

  • Group Key: ((dgeography.attr ->> 'country_code'::text)), ((dsecurity.attr ->> 'asset_type'::text)), ((dsecurity.attr ->> 'asset_class'::text))
2. 0.000 0.000 ↓ 0.0

Sort (cost=4,505.01..4,506.28 rows=508 width=120) (actual rows= loops=)

  • Sort Key: ((dsecurity.attr ->> 'asset_type'::text)), ((dsecurity.attr ->> 'asset_class'::text))
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=46.38..4,482.18 rows=508 width=120) (actual rows= loops=)

  • Hash Cond: (fflow.securityid = dsecurity.id)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=43.78..4,474.22 rows=508 width=136) (actual rows= loops=)

  • Hash Cond: (fflow.geographyid = dgeography.id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on fflow (cost=0.00..4,167.00 rows=100,000 width=40) (actual rows= loops=)

  • Filter: ((perioddate >= '2019-07-01'::date) AND (perioddate <= '2019-10-31'::date))
6. 0.000 0.000 ↓ 0.0

Hash (cost=43.70..43.70 rows=6 width=108) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on dgeography (cost=0.00..43.70 rows=6 width=108) (actual rows= loops=)

  • Filter: ((attr ->> 'country_code'::text) = 'US'::text)
8. 0.000 0.000 ↓ 0.0

Hash (cost=2.27..2.27 rows=27 width=409) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on dsecurity (cost=0.00..2.27 rows=27 width=409) (actual rows= loops=)