explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xeHi

Settings
# exclusive inclusive rows x rows loops node
1. 81.723 81.723 ↓ 35.9 1,470 1

CTE Scan on _r (cost=2,815.01..2,815.83 rows=41 width=8) (actual time=0.430..81.723 rows=1,470 loops=1)

2.          

CTE _r

3. 0.218 81.357 ↓ 35.9 1,470 1

Recursive Union (cost=0.00..2,815.01 rows=41 width=8) (actual time=0.429..81.357 rows=1,470 loops=1)

4. 0.559 0.559 ↑ 1.0 1 1

Seq Scan on pl_saleorg_resp _s (cost=0.00..97.63 rows=1 width=8) (actual time=0.428..0.559 rows=1 loops=1)

  • Filter: ((platstatus = 1) AND (memberid = '1271009751085486080'::bigint))
  • Rows Removed by Filter: 3,255
5. 8.000 80.580 ↓ 73.5 294 5

Nested Loop (cost=0.29..271.66 rows=4 width=8) (actual time=14.921..16.116 rows=294 loops=5)

  • Join Filter: (_a.orgtypeid = _t.orgtypeid)
  • Rows Removed by Join Filter: 24,300
6. 0.040 0.040 ↓ 13.0 13 5

Seq Scan on pl_orgtype _t (cost=0.00..1.20 rows=1 width=8) (actual time=0.004..0.008 rows=13 loops=5)

  • Filter: (orgtypecategory = 1)
  • Rows Removed by Filter: 6
7. 32.890 72.540 ↓ 33.8 1,892 65

Nested Loop (cost=0.29..269.76 rows=56 width=16) (actual time=0.003..1.116 rows=1,892 loops=65)

8. 1.430 1.430 ↓ 29.4 294 65

WorkTable Scan on _r _r_1 (cost=0.00..0.20 rows=10 width=8) (actual time=0.000..0.022 rows=294 loops=65)

9. 38.220 38.220 ↑ 1.0 6 19,110

Index Scan using ix_pl_orgstruct_parentorgstructid on pl_orgstruct _a (cost=0.29..26.90 rows=6 width=24) (actual time=0.001..0.002 rows=6 loops=19,110)

  • Index Cond: (parentorgstructid = _r_1.orgstructid)
Planning time : 0.806 ms
Execution time : 81.870 ms