explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9BEA

Settings
# exclusive inclusive rows x rows loops node
1. 2,375.756 2,877.253 ↓ 0.0 0 1

Insert on aircraft_beacons (cost=2,191.13..17,446.31 rows=7,299 width=334) (actual time=2,877.253..2,877.253 rows=0 loops=1)

  • Conflict Resolution: NOTHING
  • Tuples Inserted: 6057
  • Conflicting Tuples: 0
2. 76.918 501.497 ↑ 1.2 6,057 1

Subquery Scan on sq (cost=2,191.13..17,446.31 rows=7,299 width=334) (actual time=188.617..501.497 rows=6,057 loops=1)

3. 292.025 424.579 ↑ 1.2 6,057 1

GroupAggregate (cost=2,191.13..17,263.83 rows=7,299 width=320) (actual time=188.550..424.579 rows=6,057 loops=1)

  • 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))
  • Rows Removed by Filter: 8278
4. 102.311 132.554 ↓ 1.7 14,338 1

Sort (cost=2,191.13..2,211.77 rows=8,258 width=199) (actual time=97.656..132.554 rows=14,338 loops=1)

  • Sort Key: ab."timestamp", ab.name, ab.receiver_name
  • Sort Method: external merge Disk: 1592kB
5. 30.243 30.243 ↓ 1.7 14,338 1

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