explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GqM2

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

nsert on aircraft_beacons (cost=2,191.13..17,446.31 rows=7,299 width=334) (actual rows= loops=)

  • Conflict Resolution: NOTHING
2. 0.000 0.000 ↓ 0.0

Subquery Scan on sq (cost=2,191.13..17,446.31 rows=7,299 width=334) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=2,191.13..17,263.83 rows=7,299 width=320) (actual rows= loops=)

  • Group Key: ab."timestamp", ab.name, ab.receiver_name
  • Filter: ((max(ab.receiver_id) IS NOT NULL) AND (max(ab.device_id) IS NOT NULL))
4. 0.000 0.000 ↓ 0.0

Sort (cost=2,191.13..2,211.77 rows=8,258 width=199) (actual rows= loops=)

  • Sort Key: ab."timestamp", ab.name, ab.receiver_name
5. 0.000 0.000 ↓ 0.0

Seq Scan on aircraft_beacons_continuous_import ab (cost=0.00..1,190.58 rows=8,258 width=199) (actual rows= loops=)