explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mkXW : process_import_gl_tree

Settings
# exclusive inclusive rows x rows loops node
1. 1,226.402 1,638.798 ↓ 1.0 101,404 1

Sort (cost=13,693.81..13,936.89 rows=97,232 width=2,398) (actual time=1,589.343..1,638.798 rows=101,404 loops=1)

  • Sort Key: p.property_name
  • Sort Method: quicksort Memory: 92,036kB
2. 104.704 412.396 ↓ 1.0 101,404 1

Hash Left Join (cost=96.83..5,638.55 rows=97,232 width=2,398) (actual time=1.348..412.396 rows=101,404 loops=1)

  • Hash Cond: ((pgs.cid = gt.cid) AND (pgs.gl_tree_id = gt.id))
3. 103.436 307.602 ↓ 1.0 101,404 1

Hash Join (cost=92.63..5,109.00 rows=97,232 width=2,382) (actual time=1.252..307.602 rows=101,404 loops=1)

  • Hash Cond: (p.id = pgs.property_id)
4. 138.390 203.583 ↓ 1.0 101,404 1

Hash Join (cost=54.08..4,812.69 rows=97,437 width=2,378) (actual time=0.661..203.583 rows=101,404 loops=1)

  • Hash Cond: (pp.property_id = p.id)
  • Join Filter: (((p.property_type_id <> 99) AND (p.property_type_id <> 38) AND ((pp.key)::text <> 'ENABLE_SEMESTER_SELECTION'::text)) OR ((10 = ANY (p.occupancy_type_ids)) AND ((pp.key)::text = 'ENABLE_SEMESTER_SELECTION'::text)))
  • Rows Removed by Join Filter: 1,251
5. 64.546 64.546 ↑ 1.0 112,953 1

Seq Scan on property_preferences pp (cost=0.00..4,454.70 rows=113,147 width=38) (actual time=0.005..64.546 rows=112,953 loops=1)

  • Filter: ((value IS NOT NULL) AND (cid = 2,603))
  • Rows Removed by Filter: 17,823
6. 0.263 0.647 ↑ 1.0 475 1

Hash (cost=48.14..48.14 rows=475 width=2,374) (actual time=0.647..0.647 rows=475 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 278kB
7. 0.384 0.384 ↑ 1.0 475 1

Seq Scan on properties p (cost=0.00..48.14 rows=475 width=2,374) (actual time=0.004..0.384 rows=475 loops=1)

  • Filter: ((cid = 2,603) AND (is_disabled = 0))
  • Rows Removed by Filter: 68
8. 0.255 0.583 ↑ 1.0 542 1

Hash (cost=31.77..31.77 rows=542 width=12) (actual time=0.583..0.583 rows=542 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 32kB
9. 0.328 0.328 ↑ 1.0 542 1

Seq Scan on property_gl_settings pgs (cost=0.00..31.77 rows=542 width=12) (actual time=0.007..0.328 rows=542 loops=1)

  • Filter: (cid = 2,603)
10. 0.044 0.090 ↑ 1.0 80 1

Hash (cost=3.00..3.00 rows=80 width=28) (actual time=0.089..0.090 rows=80 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
11. 0.046 0.046 ↑ 1.0 80 1

Seq Scan on gl_trees gt (cost=0.00..3.00 rows=80 width=28) (actual time=0.005..0.046 rows=80 loops=1)

  • Filter: (cid = 2,603)