explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qa7B

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

Sort (cost=88.53..90.29 rows=702 width=16) (actual rows= loops=)

  • Sort Key: node_id, source
2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=48.32..55.34 rows=702 width=16) (actual rows= loops=)

  • Group Key: node_id, source
3. 0.000 0.000 ↓ 0.0

Seq Scan on nodes_availability (cost=0.00..37.22 rows=1,481 width=16) (actual rows= loops=)

  • Filter: ((validity @> '2020-06-23 00:00:00-05'::timestamp with time zone) AND (release_date <= '2020-06-23 14:00:00-05'::timestamp with time zone))