explain.depesz.com

PostgreSQL's explain analyze made readable

Result: z9c

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

GroupAggregate (cost=347,300.30..347,300.33 rows=1 width=528) (actual rows= loops=)

  • Group Key: pc.note, rdt.device_id
2. 0.000 0.000 ↓ 0.0

Sort (cost=347,300.30..347,300.31 rows=1 width=528) (actual rows= loops=)

  • Sort Key: pc.note, rdt.device_id
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.00..347,300.29 rows=1 width=528) (actual rows= loops=)

  • Join Filter: (pc.id = (((t.json_credit_guard_response)::json ->> 'clientkey_id'::text))::integer)
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.00..347,286.09 rows=1 width=455) (actual rows= loops=)

  • Join Filter: (rdt.transaction_id = t.id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on transactions t (cost=0.00..301,545.10 rows=1 width=459) (actual rows= loops=)

  • Filter: ((creation_date >= '2019-11-04 10:00:00+02'::timestamp with time zone) AND (creation_date <= '2019-11-04 13:00:00+02'::timestamp with time zone))
6. 0.000 0.000 ↓ 0.0

Seq Scan on rtu_device_transactions rdt (cost=0.00..45,558.85 rows=14,571 width=8) (actual rows= loops=)

  • Filter: (device_id = ANY ('{9681,9955}'::integer[]))
7. 0.000 0.000 ↓ 0.0

Seq Scan on passenger_clientkey pc (cost=0.00..11.20 rows=120 width=524) (actual rows= loops=)