explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p4dj

Settings
# exclusive inclusive rows x rows loops node
1. 339,639.749 340,436.523 ↓ 0.0 0 1

Insert on castoncast_central.efp_objects_statuses (cost=22,949.68..30,626.48 rows=383,840 width=36) (actual time=340,436.523..340,436.523 rows=0 loops=1)

  • Buffers: shared hit=3355072 read=265470 dirtied=265111, local hit=3159
2. 559.624 796.774 ↑ 1.0 383,840 1

HashAggregate (cost=22,949.68..26,788.08 rows=383,840 width=36) (actual time=424.792..796.774 rows=383,840 loops=1)

  • Output: wkd.object_id, wkd.module_id, (230), (229), wkd.object_status, (CASE WHEN (wka.object_id IS NULL) THEN '-1'::integer ELSE 1 END), (CASE WHEN (wka.object_id IS NULL) THEN '-1'::double precision ELSE wka.cost_complexity END), (CASE WHEN (wka.object_id IS NULL) THEN 0 ELSE wkd.techno_type_id END)
  • Group Key: wkd.object_id, wkd.module_id, 230, 229, wkd.object_status, CASE WHEN (wka.object_id IS NULL) THEN '-1'::integer ELSE 1 END, CASE WHEN (wka.object_id IS NULL) THEN '-1'::double precision ELSE wka.cost_complexity END, CASE WHEN (wka.object_id IS NULL) THEN 0 ELSE wkd.techno_type_id END
  • Buffers: local hit=3159
3. 166.715 237.150 ↑ 1.0 383,840 1

Hash Left Join (cost=5,592.35..15,272.88 rows=383,840 width=36) (actual time=41.051..237.150 rows=383,840 loops=1)

  • Output: wkd.object_id, wkd.module_id, 230, 229, wkd.object_status, CASE WHEN (wka.object_id IS NULL) THEN '-1'::integer ELSE 1 END, CASE WHEN (wka.object_id IS NULL) THEN '-1'::double precision ELSE wka.cost_complexity END, CASE WHEN (wka.object_id IS NULL) THEN 0 ELSE wkd.techno_type_id END
  • Hash Cond: (wkd.object_id = wka.object_id)
  • Buffers: local hit=3159
4. 29.643 29.643 ↑ 1.0 383,840 1

Seq Scan on pg_temp_40.wk_efp_obj_status_light wkd (cost=0.00..5,913.40 rows=383,840 width=16) (actual time=0.011..29.643 rows=383,840 loops=1)

  • Output: wkd.object_id, wkd.module_id, wkd.object_status, wkd.techno_type_id
  • Buffers: local hit=2075
5. 23.152 40.792 ↑ 1.0 200,371 1

Hash (cost=3,087.71..3,087.71 rows=200,371 width=12) (actual time=40.792..40.792 rows=200,371 loops=1)

  • Output: wka.object_id, wka.cost_complexity
  • Buckets: 262144 Batches: 1 Memory Usage: 11441kB
  • Buffers: local hit=1084
6. 17.640 17.640 ↑ 1.0 200,371 1

Seq Scan on pg_temp_40.wk_efp_artifacts wka (cost=0.00..3,087.71 rows=200,371 width=12) (actual time=0.010..17.640 rows=200,371 loops=1)

  • Output: wka.object_id, wka.cost_complexity
  • Buffers: local hit=1084