explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8KgWy

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

Unique (cost=17,270.62..17,363.92 rows=18,661 width=16) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=17,270.62..17,317.27 rows=18,661 width=16) (actual rows= loops=)

  • Sort Key: object_id
3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=15,760.22..15,946.83 rows=18,661 width=16) (actual rows= loops=)

  • Group Key: object_id, user_id
4. 0.000 0.000 ↓ 0.0

Seq Scan on operation (cost=0.00..15,571.15 rows=25,209 width=16) (actual rows= loops=)

  • Filter: ((date >= '2020-01-01 00:00:00'::timestamp without time zone) AND (date <= '2020-12-31 00:00:00'::timestamp without time zone) AND ((code)::text = 'receipt_id_update'::text))