explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1UUo

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

Hash Join (cost=17,419.79..173,814.35 rows=1,028 width=32) (actual rows= loops=)

  • Hash Cond: ((((event.data -> 'data'::text) ->> 'data_asset_id'::text))::bigint = tile.id)
2. 0.000 0.000 ↓ 0.0

Index Scan using event_index on event (cost=0.56..154,583.11 rows=205,619 width=235) (actual rows= loops=)

  • Index Cond: ((data ->> 'event'::text) = 'TILE_INTERACTION'::text)
3. 0.000 0.000 ↓ 0.0

Hash (cost=17,419.22..17,419.22 rows=1 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Foreign Scan on tile (cost=100.42..17,419.22 rows=1 width=4) (actual rows= loops=)