explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YIrN : Optimization for: Optimization for: plan #k95Q; plan #MqXs

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1.755 21.112 ↑ 1.0 1,907 1

Hash Join (cost=1,446.16..1,531.98 rows=1,907 width=187) (actual time=15.805..21.112 rows=1,907 loops=1)

  • Hash Cond: (base.id = ets.id)
2.          

CTE base

3. 1.812 12.867 ↑ 1.0 1,907 1

Unique (cost=966.96..1,016.82 rows=1,907 width=24) (actual time=10.051..12.867 rows=1,907 loops=1)

4. 7.721 11.055 ↑ 1.0 9,971 1

Sort (cost=966.96..991.89 rows=9,971 width=24) (actual time=10.049..11.055 rows=9,971 loops=1)

  • Sort Key: external_tracking_status.order_id, external_tracking_status.tracking_system_timestamp, external_tracking_status.server_timestamp
  • Sort Method: quicksort Memory: 1163kB
5. 3.334 3.334 ↑ 1.0 9,971 1

Seq Scan on external_tracking_status (cost=0.00..304.71 rows=9,971 width=24) (actual time=0.005..3.334 rows=9,971 loops=1)

6. 13.621 13.621 ↑ 1.0 1,907 1

CTE Scan on base (cost=0.00..38.14 rows=1,907 width=4) (actual time=10.053..13.621 rows=1,907 loops=1)

7. 4.241 5.736 ↑ 1.0 9,971 1

Hash (cost=304.71..304.71 rows=9,971 width=187) (actual time=5.736..5.736 rows=9,971 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1638kB
8. 1.495 1.495 ↑ 1.0 9,971 1

Seq Scan on external_tracking_status ets (cost=0.00..304.71 rows=9,971 width=187) (actual time=0.003..1.495 rows=9,971 loops=1)